Toad Data Point 3.8 is here, so what’s new?
There have been some added functionality to query development and the editor/grid.
- If you are using IN or NOT IN in a WHERE clause, you can now load multiple values from a .txt, Excel, or .csv file.
- When a query returns multiple results, you can now display all results in a single grid. When multiple results are displayed in a single tab, select All results to display all result sets in a single grid, or use CRTL+Click to display only the selected sets.
- This release includes support for WITH AS syntax for SAP IQ connections.
- The animated background processes icon has been enhanced to provide a clearer indication that a window is associated with a currently running process.
- Code completion is now available in the Export Wizard query editor.
There have also been some updates to automation.
- You can now use the Email Server Settings dialog in the Send Email activity to authenticate your connection even if you are not using an SSL/TLS connection.
- You can now use the asterisk (*) and question mark (?) wildcard characters, as well as variables, in a file name to help you select one or more files (in the same directory) to add as attachments
There are some added features and options that are platform specific.
- For predefined ODBC connections (such as Vertica, Netezza, PostgreSQL, and Greenplum), you can now limit the number of rows returned in the Data tab (Database Explorer), Query Builder, and Editor.
- Toad has added support for RAISE NOTICE statements in Netezza ODBC connections. If a script contains message or notice statements, the messages/notices display in the Messages tab in the Results pane. Message/notice statements in other types of ODBC connections are also supported.
- Passive Mode is Available for FTP Connections
Some other notable changes and new features:
- This release includes a new interface for organizing and accessing your Toad files—the Library.
When you add a file to the Library, you can add tags and a topic to the file to make it easier to search for the file within the Library. As the number of files in your Library grows, use filter, group, and search features to easily find the files you need. Each file is added to the Library, but remains in its original location. You can publish a file to Intelligence Central from the Library and you can run an Automation script from the Library.
- The Data Compare project file has a new XML format. New Data Compare projects you create will now be saved using this new XML format.
Data Compare files created in previous versions of Toad with the file extension (.dcp) remains the same and are still supported. If you open a Data Compare file created in a previous version of Toad, the file is automatically converted to the new XML format.
- This release has re-implemented version control for Toad files. Toad can integrate with your existing version control system allowing you to manage multiple versions of Toad files.
Toad supports Apache Subversion™ for managing Toad files. Toad has been tested with Subversion 1.7.5 and 1.8. You can manage the following file types using version control within Toad: Editor (.tef, .sql, .txt), Query Builder (.tsm), ER Diagram (.ter), and Automation (.tas).
Some additional features added to the Toad Data Point Professional edition includes the following...
Toad Intelligence Central:
Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
- To successfully publish a view, snapshot, or dataset to Intelligence Central version 2.7 (or later), the Intelligence Central server to which you are publishing must be sufficiently licensed. The license must include the data connectivity module.
- To display a list of licensed modules for your Intelligence Central connection, in the Connection Manager place your cursor over the connection (connection must be open to display information).
- You can now publish a snapshot or a view to Intelligence Central from a Salesforce SOQL query, in addition to publishing as a dataset. The published query uses Salesforce SOQL syntax.
Note: This feature is supported in Intelligence Central 2.7 or later.
- There have been added notification functionality. Whenever an object is shared with you a notification will be logged.
- When you log in (connect) to the server where the object was published you can review these in the Notifications tab in the Object Explorer.
- Similarly the notification is also displayed in the Toad Intelligence Central when you connect.
- When you publish data or other objects to Intelligence Central, Toad allows you to automatically send an email to the list of users with whom you shared the object. After publishing, the email opens for you to review, edit, and send.
- You can now create your own groups in Intelligence Central and populate them with Intelligence Central and Active Directory users. This is useful if you repeatedly share objects with a specific set of users.
- Now you can add Active Directory groups to Intelligence Central, not only individual Active Directory users.
- For Intelligence Central connections, the Object Explorer now includes a Users tab (node). Use this new interface to view information about a user or group. You can also perform management tasks, such as modifying an Intelligence Central group you own, or creating and dropping groups/users.
- You can now publish to Intelligence Central from data sources that allow anonymous user access (no user name), such as MongoDB.
- You can now publish and run an Automation script on Intelligence Central if the script contains one of the following:
- An Intelligence Central connection that uses Windows Authentication
- A SQL Server connection that uses Windows Authentication
In both cases the script must be published and executed in Intelligence Central under the same Windows Active Directory account used in the Windows Authentication connection.
This release provides a new streamlined workflow for opening and using the following tools:
- Transform and Cleanse Data
- Profile Data
- Dimensional View
- Visualize Data
When you click the main toolbar button or select Tools, this action opens a new dialog where you can specify parameters for selecting the data to use. This new dialog can help you get started if you are a new user or help streamline your workflow if you are an experienced user.
You can continue to use the previous workflows: sending data directly from a data grid or object, or entering a query. These workflows are retained.
This release includes several enhancements to the Transform and Cleanse tool that was redesigned in release 3.7.
- Toad now provides Auto Transform as a quick way to transform your data. Toad will giving you a list of recommended rules and you can quickly apply them directly from the dialog.
- Toad provides recommendations for Trim and Convert Data Type rules, at this time.
- Data type analysis has been enhanced to better detect when a Convert Data Type rule should be recommended.
- When creating a group column, you can now specify a default group, which will use the row's current value.
- In a related enhancement, when a new group column is created, it is now displayed immediately adjacent to the original column.
- The Format Data rule editor has been redesigned to simplify selecting a date format, now including examples.
- The Calculated Column expression editor now includes a Search box in the operator toolbar.
- You can now add your transformed and cleansed data to a project in the Project Manager.
- Toad saves your work as a Transform and Cleanse document (.tct) and adds it to the currently-open project in the Project Manager.
- Important: Legacy Transform and Cleanse (.tdc) and Data Browser (.tdb) file formats are no longer supported in Toad Data Point 3.8 or later. Please recreate the content of legacy files using the new Transform and Cleanse tool which saves your work as a .tct file.
There are some additions to DBMS Support and Connections.
- Toad now allows you to create a full-featured, native SAP HANA connection. This type of connection provides complete Query Builder, Query Editor, and Database Explorer functionality.
- Additional functionality includes Cross-Connection query, Data Compare, and Publishing to Intelligence Central.
- Toad supports SAP HANA versions SPS 08 and SPS 09.
- This release supports Hive connections to HiveServer2, and includes support for SSL, HTTP mode, and Kerberos authentication.
- MongoDB Enhancements
- MongoDB collections and their embedded documents are now mapped to separate tables in Toad. Both are displayed as tables in the Object Explorer. Tables representing embedded documents use the following naming format: _, where parent is the name of the collection and child is the name of the field containing the embedded document.
- To view relationships between collections and embedded documents or to find all related objects, use the Database Explorer Relationships tab or the Database Diagram.
- You can easily view data in related MongoDB objects in the Database Explorer (Viewer). The Data tab provides a master-detail type view allowing you to see data in a parent table and then drill down to the data in the immediate sub-tables. So, you can view the data in a MongoDB collection and its embedded documents within the same window.
- Salesforce Enhancements
- This release includes an updated Salesforce API to support tables not visible with the older version.
- Cassandra Support
- This release supports connecting to a CQL-enabled Cassandra version using the CQL API connection.
- Amazon SimpleDB
- Toad no longer provides the Amazon SimpleDB connection in the Create New Connection list in the Connection Manager. Toad will continue to support existing SimpleDB connections.
Other general enhancements and changes in the Professional edition:
- In the Query Builder for a Salesforce connection, you can now easily restore a relationship between tables that may have been dropped.
- Toad now allows you to use named parameters in SQL, even if the underlying provider does not support this method. For example, you can use named parameters in SQL in an ODBC connection. You can also include named and positional parameters in the same SQL. This feature is not supported for Business Intelligence and NoSQL connections.