Toad for SAP Solutions - Beta Forum - Toad for SAP Solutions Beta Program - Toad World

Toad for SAP Solutions Beta Program Community

Toad for SAP Solutions - Beta Forum

Daniel Bizon

New beta build Toad for SAP Solutions 3.2.0.317 is available!

Expand content
Toad for SAP Solutions 3.2 beta build 317 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. The current...

Toad for SAP Solutions 3.2 beta build 317 has been posted and is ready for download.

Please download it from the beta page and post any comments or suggestions that you may have.

The current beta will expire on 2/1/2017.

Thanks!

333 0 / Create an account to join the discussion.
Daniel Bizon

New beta build Toad for SAP Solutions 3.2.0.94 is available!

Expand content
Toad for SAP Solutions 3.2 beta build 94 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

Toad for SAP Solutions 3.2 beta build 94 has been posted and is ready for download.

Please download it from the beta page and post any comments or suggestions that you may have.

Thanks!

961 0 / Create an account to join the discussion.
Steve Hilker

New beta cycle has just started! Toad for SAP Solutions v3.2 is available...

Expand content
Toad for SAP Solutions v3.2 beta build 23 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. The big change that...

Toad for SAP Solutions v3.2 beta build 23 has been posted and is ready for download.

Please download it from the beta page and post any comments or suggestions that you may have.

The big change that we wanted to get into Beta is support for SAP HANA multi-tenant database containers.

Thanks!

-Steve

1027 0 / Create an account to join the discussion.
Daniel Bizon

New beta build 3.1.0.252 has been posted and is ready for download...

Expand content
Hi, Toad for SAP Solutions 3.1 beta build 252 has been posted and is ready for download. It has got 60-days expiration set in order to cover the period before our 3.1 release. Please download it...

Hi,

Toad for SAP Solutions 3.1 beta build 252 has been posted and is ready for download.

It has got 60-days expiration set in order to cover the period before our 3.1 release.

Please download it from the beta page and post any comments or suggestions that you may have.

Thanks!

1677 0 / Create an account to join the discussion.
nancysmallwood
Follow / 19 Jan 2016 at 5:47pm / Toad for SAP Solutions Beta Program
Latest post by on 20 Jan 2016 at 5:21pm

Toad for SAP Solutions Beta 3.1.0.170 - When will we see the Schema...

Expand content
I've downloaded, installed and launched the new 3.1.0.170 beta. So far the Data Comparison looks good. When do you think the Schema Comparison will be available? I understand that it was being refactored...

I've downloaded, installed and launched the new 3.1.0.170 beta.  So far the Data Comparison looks good.  When do you think the Schema Comparison will be available?  I understand that it was being refactored, and that the effort was fairly extensive.  We are going into production with HANA this summer and would really like to get this tool (with the schema compare) into our development processes.  Thanks!

Unanswered 2304 4 / Create an account to join the discussion.
Daniel Bizon

New beta build 3.1.0.170 has been posted and is ready for download...

Expand content
Hi, Toad for SAP 3.1 beta build 170 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

Hi,

Toad for SAP 3.1 beta build 170 has been posted and is ready for download.

Please download it from the beta page and post any comments or suggestions that you may have.

Thanks!

1899 0 / Create an account to join the discussion.
Daniel Bizon
Follow / 19 Nov 2015 at 8:30am / Toad for SAP Solutions Beta Program
Latest post by on 16 Dec 2015 at 8:38am

New beta cycle has just started! Toad for SAP Solutions 3.1.0.66 is...

Expand content
Hello Everyone, Toad for SAP 3.1 beta build 66 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

Hello Everyone,

Toad for SAP 3.1 beta build 66 has been posted and is ready for download.

Please download it from the beta page and post any comments or suggestions that you may have.

Thanks!

2364 3 / Create an account to join the discussion.
Steve Hilker

New videos on features in v3.1 Beta!

Expand content
We have posted two new videos to the Toad for SAP Solutions media gallery. These videos show how to use two of the new features in our current v3.1 BETA release . Check them out for yourself! The two...

We have posted two new videos to the Toad for SAP Solutions media gallery.  These videos show how to use two of the new features in our current v3.1 BETA release.  Check them out for yourself!

The two new features highlighted in the videos are:

  • Visual Database Map - this new feature allows you to better understand the inter-dependencies of your database objects.  And this goes far beyond a typical ER diagram showing the relationships between tables.  You can now visualize the relationships between all your database objects - tables, indexes, views, stored procedures and functions, etc.
     
  • File Version Control - we've extended Toad's capabilities with version control and team collaboration.  Users can now store and share Toad files via a SVN repository.  NOTE:  the video will say Toad for Data Point, but the feature works identically in Toad for SAP Solutions!

Each video is short (~3 to 4 minutes long) so it won't take a ton of your time to see what's new in Toad.  We'd love to get your feedback, too!  You can post it here or as a comment to the video.

1882 0 / Create an account to join the discussion.
KjartanMS
Follow / 16 Jul 2015 at 7:19pm / Toad for SAP Solutions Beta Program
Latest post by on 23 Jul 2015 at 9:40am

Toad for SAP Solutions Beta 3.0.0.122 - Connection problems

Expand content
Hi I have just started using the Beta version (have license for 2.1). I have lately discovered that Toad (both the 2.1 and the latest beta) does not allows manage to connect. I frequently connect over...

Hi

I have just started using the Beta version (have license for 2.1). I have lately discovered that Toad (both the 2.1 and the latest beta) does not allows manage to connect.

I frequently connect over a vpn line as well as from the office and I know that they have recently changed the whole network infrastructure.

We use OpenClient 12.0 (at least that's the sql.ini file being used) and I try to connect to our database which is listed as <ourserver>.company.com, 6060, urgent

I frequently get the message: Database Error: There is no server listening at ourserver.company.com:6060.

Then I open BMC SQL-Programmer Expert 18.5 and open the exact same connection as defined in the same sql.ini file and it connects immediately. This leads me to think that Toad handles the dns's differently than SQL-Programmer does. Toad 2.1 simply tries for 15 seconds and then gives the message: "Client unable to establish connection"

This is the same for all my connections to dev, test and production environments.

The environments are Sybase ASE 15.0.3 to Sybase ASE 15.7 on Sun Solaris 10.

The windows host file on my work laptop is empty (default).

Since one application manages to connect fine where as the other doesn't I am suspect that Toad handles the connection differently. Do Toad require IP-addresses and/or local dns translations?

Thanks in advance!

Br

Kjartan M-S

Answered 3670 3 / Create an account to join the discussion.
nancysmallwood
Follow / 11 Mar 2015 at 3:25pm / Toad for SAP Solutions Beta Program
Latest post by on 15 Jul 2015 at 12:59pm

Toad for SQL Beta 3.0.0.666 Cannot find SAP Client Version 1.00.8...

Expand content
I've just downloaded the Toad for SAP Beta 3.0.0.666 and receive and error that the SAP HANA client version of at least 1.00.80 is required. The only version I have installed of the SAP HANA client...

I've just downloaded the Toad for SAP Beta 3.0.0.666 and receive and error that the SAP HANA client version of at least 1.00.80 is required.  The only version I have installed of the SAP HANA client is 1.00.80, so not sure why the dll's cannot be found.  The HANA client installation dir is in correct in my PATH.  Is there anything else that may be preventing Toad from seeing my SAP HANA client instalation?

Answered 16130 10 / Create an account to join the discussion.
Patrick Larsson
Follow / 3 Jun 2015 at 8:23am / Toad for SAP Solutions Beta Program
Latest post by on 13 Jul 2015 at 7:17pm

Beta build 3.0.0.807

Expand content
Hi! Installed this build yesterday and today it says it's BETA period has exired is there any newer BETA version to download? Otherwise i think it is a great tool to use when working in HANA...

Hi!

Installed this build yesterday and today it says it's BETA period has exired is there any newer BETA version to download?

Otherwise i think it is a great tool to use when working in HANA

/Patrick

6030 4 / Create an account to join the discussion.
Steve Hilker
Follow / 1 Jun 2015 at 12:55pm / Toad for SAP Solutions Beta Program
Latest post by on 3 Jun 2015 at 12:39pm

Toad for SAP Solutions 3.0 - nearing General Availability

Expand content
Good day, Beta users. v3.0 will soon be made commercially available, we'd like your feedback. What do you think of v3? Did it meet your expectations? Does it have all the functionality you were hoping...

Good day, Beta users.

 v3.0 will soon be made commercially available, we'd like your feedback.  What do you think of v3?  Did it meet your expectations?  Does it have all the functionality you were hoping for?  If not, what are we missing?  As we get close to exiting one release it's time to plan for the next.  So, your input is very important to us.

I'd also be interested in hearing how you use Toad.  Do you use it primarily for database admin or development?  What's your favorite feature?  Will you be using it for the new ASE 16 or HANA features?  Are you a new user or existing?

I'm hoping you'll take a few minutes and share your thoughts on the product. You can post your thoughts below, or send me an email:  steve.hilker@software.dell.com

Thanks!

Steve Hilker
Product Manager, Toad for SAP Solutions

5970 3 / Create an account to join the discussion.
Cindy.Sang

Beta build 3.0.0.783 has been posted and is ready for download.

Expand content
Hello Everyone, Toad for SAP 3.0 beta build 783 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

Hello Everyone, Toad for SAP 3.0 beta build 783 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

7835 0 / Create an account to join the discussion.
DirkJ
Follow / 9 Mar 2015 at 7:46am / Toad for SAP Solutions Beta Program
Latest post by on 14 Apr 2015 at 8:08am

Some results from testing Toad for SAP 3.0 Beta

Expand content
Hallo, during the evaluation of Toad for Sybase resp. SAP (versions 2.x and 3.0), I found the following issues: Access to system tables Since Version 3.0 Toad seems to require access to some system...

Hallo,

during the evaluation of Toad for Sybase resp. SAP (versions 2.x and 3.0), I found the following issues:

Access to system tables

Since Version 3.0 Toad seems to require access to some system tables, which are not accessible to “normal” users in our setup:

  • Executing “alter table” from the “Object Explorer” fails, because it seems to require access to the “dbccdb” system database.
  • Toad seems to require access to the “sybmgmtdb” during initial connection:
    • When opening the first connection from the Connection Manager, it seems that Toad tries to query sybmgmtdb and receives an error form the server, that the connecting user is not valid for this database.
    • After closing the error message, one of the following happens:
      • Everything works fine
      • Everything works fine, but the Object Explorer is empty. After refreshing, e.g. pressing F5, everything is ok. In some cases the Filter-Inputbox is missing after refreshing.
      • An error occurs (if needed, I can provide message and stack trace)
    • Opening or reopening a second connection to the same or a different server works without problems, as long as one other connection is open.

Both system database are not (and will not be) accessible to “normal” users in our setup. In versions before 3.0, these issues did not exist. Therefore, I am wondering, if this is really needed or could, for example, be controlled by a configuration switch. Is there any posibility to prevent access to these databases in the current version of Toad?

Handling numeric and decimal columns in grids

  • Display, sorting and filtering of columns of type numeric or decimal does not work correctly in grids.
  • The issue exists in all tested versions of Toad. All tests have been performed with German localization settings.
  • Sorting a grid column with values from a numeric or decimal column is somewhat arbitrary. Depending of the pre-sorting from the query (order by clause) the grid sorting results in different orders.
  • Filtering does not work correctly in some cases:
    • “Equal” and “not equals”: result is correct.
    • “less/greater than”, “less/greater than or equal to”: result is correct, iff the comparison value is negative. If the value is positive, the result contains positive and negative values.
    • “less” and “greater” seem to be mismatched.
    • Example:
      • Source: -0.3, -0.2, -0.1, 0.0, 0.1, 0.2, 0.3
      • Filter “less than 0.1”: -0.3, -0.2, 0.2, 0.3
      • Filter “greater than 0.2”: -0.1, 0.0, 0.1

Handling results from print statements

This is not actually an error, but I would suggest to make it configurable. Furthermore, the behavior is not consistent.

  • The results of print statements are displayed as a separate result set for each single print statement. We often use print statements to control the status of loops over cursors. This can result in several thousand result sets displayed in Toad, which is very confusing.
  • The results of print statements of consecutive runs of a script in the same editor are displayed in the same “Result Sets” tab, making it difficult to distinguish the output of the different executions.
  • The display of results of print statements in the “Messages” tab is incomplete. Sometimes they are displayed completely, sometimes partially and sometimes not at all. Independent from this display, the display as result sets is always complete.
  • Toad ignores the setting of “flushmessages”. It always postpones the output of print Statement until the script has finished.

SQL-Debugger

Nice tool. :-) Just two minor question:

  • Hitting F8 (“Step over”) resumes execution to the end of the script or the next breakpoint. Shouldn’t it just execute the next statement?
  • Is it possible to step into a procedure executed inside the procedure the debugger was started on (e.g. stepping into procB which is “exec procB” inside procA)? I thought that F7 (“Step Into”) should do this, but it actually executed the whole procedure in one step.

If needed, I can provide additional Information like scripts and error messages.

Final remark: All tests have been performed on Sybase ASE 15.7 and Sybase ASE 12.5 using Toad for SAP Beta Build 3.0.0.306.

I hope you could help with these issues, because we need to make a tool decision and the mentioned issues are critical for us.

Best regards,

Dirk

11445 10 / Create an account to join the discussion.
Cindy.Sang

Beta build 3.0.0.749 has been posted and is ready for download.

Expand content
Hello Everyone, Toad for SAP 3.0 beta build 749 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

Hello Everyone, Toad for SAP 3.0 beta build 749 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

8601 0 / Create an account to join the discussion.
Daniel Bizon

Beta build 3.0.0.723 has been posted and is ready for download

Expand content
Hello Everyone, Toad for SAP 3.0 beta build 723 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks! In Toad...

Hello Everyone,

Toad for SAP 3.0 beta build 723 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

In Toad for SAP Beta 3.0.0.723 the following new features were implemented:

Support for HANA

  • It is now possible to connect to all HANA instances up to SPS 9
  • Editors for Procedures and Functions were enhanced

Other enhancements

  • Issues TSY-1151, TSY-1145, TSY-1144, and TSY-1140 and other bugs were fixed

9218 0 / Create an account to join the discussion.
john.helge.knutsen
Follow / 9 Mar 2015 at 8:50am / Toad for SAP Solutions Beta Program
Latest post by on 11 Mar 2015 at 4:01pm

Cannot see database devices

Expand content
There seems to be an old error in Toad that is still present in Beta 3.0.0.604: When I select Server Objects -> Devices it says "Devices (0)" and will not show any database devices. It is...

There seems to be an old error in Toad that is still present in Beta 3.0.0.604: When I select Server Objects -> Devices it says "Devices (0)" and will not show any database devices. It is the same in 2.0.

15736 5 / Create an account to join the discussion.
Cindy.Sang

Beta build 3.0.0.666 has been posted and is ready for download

Expand content
Hello Everyone, Toad for SAP 3.0 beta build 666 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

Hello Everyone, Toad for SAP 3.0 beta build 666 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have. Thanks!

9980 0 / Create an account to join the discussion.
john.helge.knutsen
Follow / 26 Feb 2015 at 2:44pm / Toad for SAP Solutions Beta Program
Latest post by on 2 Mar 2015 at 3:24pm

Limited info about logins

Expand content
I just loaded 3.0.0.604 and find that the information displayed about logins is still very limited. Please add tabs for which roles the user has and for which databases the user is registered as a user...

I just loaded 3.0.0.604 and find that the information displayed about logins is still very limited. Please add tabs for which roles the user has and for which databases the user is registered as a user or alias. It should not be necessary to go to Alter login to get this basic information. Anyway alias info is not displayed.

The script displayed for creating the login has the same limitation, please include commands for giving the login it's roles and users/aliases.

Unanswered 10729 1 / Create an account to join the discussion.
ZeenKork
Follow / 26 Feb 2015 at 3:07pm / Toad for SAP Solutions Beta Program
Latest post by on 2 Mar 2015 at 12:04pm

Right Click on a column in the grid issue in Toad 3.0.0.604

Expand content
In the result set window, right click only any column name in the datasets shown. Error: 2 different pop up windows appear at the same time: Close Current Result Set ..... and Copy Rows etc Note: The...

In the result set window, right click only any column name in the datasets shown.

Error: 2 different pop up windows appear at the same time:  Close Current Result Set ..... and Copy Rows etc

Note: The same issue happens when you right lick in the footer of the same grid: you will see two pop up windows :  Sum etc .. and Close Current Results set etc

10705 2 / Create an account to join the discussion.