Toad Data Point 4.Toad Data Point 4.Click here for previous versionsRelease Notes.Tuesday, June 2. 7, 2.Contents. About Toad Data Point.New Features. Resolved Issues and Enhancements.Known Issues. Third Party Known Issues.System Requirements.Product Licensing.Globalization. Getting Started.About Us. About Toad Data Point.Toad Data Point is a multi platform database query tool built.With. Toad Data Point.Connect. to almost any database or ODBC data source see the Release Notes for a list of tested ODBC connectionsWrite.SQL queries and join data across all platforms.Automate. and schedule frequent and repetitive tasks.Streamline. data collection.Collaborate. with team members.Export. data in a variety of file formats Toad Data Point provides a full featured Database Explorer, Query Builder, and Editor.OracleSQL. Server and SQL Azure.IBM DB2. LUW and zOSSAP ASE, IQ, SQL Anywhere, and HANATeradataMy.SQL Toad Data Point also provides querying and reporting.ODBC Business Intelligence and No.SQL data sources.Microsoft ExcelMicrosoft AccessODBC Connections.Excel VBA 24Hour Trainer Introduction.Senturus comprehensive library of Cognos and Business Intelligence presentations and information.All of them are free and we add new resources regularly.Great 3rd party addon tools to augment MYOB Business Management Software.FZCD.png' alt='Microsoft Odbc Excel Driver Count Field Incorrect' title='Microsoft Odbc Excel Driver Count Field Incorrect' />The.ODBC provider is to offer basic connection and querying.ODBC 3. 0 or later driver.For a list of databases tested with the ODBC provider, see the System Requirements in the Release Notes.This form of connectivity allows.Netezza, IBM i. Series, Ingres, and Vertica.Because this form of connectivity is generic, it is not full featured.Business Intelligence and No.SQL Data Sources.Toad Data Point provides users with the ability to connect to non traditional data sources, such as Business Intelligence and No.SQL sources. You can connect to these data sources and explore data and objects, query data, report results, and automate tasks.The following data sources are supported Business Intelligence.Oracle Business Intelligence Enterprise Edition OBIEE, SAP Business Objects, Salesforce, Microsoft SQL Server Analysis Services, Google Analytics, OData, and Share.PointNo. SQLAzure Table Services, Cassandra, Cloudera Impala, Dynamo.DB, HBASE, Hive, Mongo.DBBack to Top. New Features.Toad Data Point 4.Toad Data Point 4.See Resolved Issues and Enhancements for more information.Toad Data Point 4.Professional Edition.The Toad Data Point Professional edition includes the following new features and enhancements.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.Publish View with Variable in SQLYou can now publish a view that contains a variable.This new feature allows data providers to include variables in a published view so data consumers can change the value prior to viewing the result set.Note This new feature is supported in Intelligence Central 3.To use this new feature, create a query containing a variable.Then publish the query as a View.The Publishing dialog allows the publisher to specify a default value for each variable in the SQL at the time of publishing.After publishing, the View owner or users with Manage privileges can modify the default value.In this way users can enter their own variable values prior to viewing the result set.To edit the variable default value, in the Object Explorer right click the View and select View Details.Select the Variables tab and click the Edit default variables button.In the Web interface for Toad Intelligence Central 3.SQL prior to Downloading the view.See the Toad Intelligence Central Quick Start Guide for more information.Prompt for Variable Value when Running Published Automation Scripts.Note This new feature is supported in Intelligence Central 3.This release includes a new feature for Automation scripts that allows you to instruct Toad to prompt for a variable value at run time for manually executed scripts.This feature is supported for an Automation script executed locally or for a published script executed in Intelligence Central.This feature applies to the following types of scripts An Automation script containing a Set Variable activity.The Prompt during run option must be selected.An Automation script containing a Send Email activity.The Prompt option must be selected.Review the following feature details To use this feature, create an Automation script containing either a Set Variable activity or a Send Email activity.In the Set Variable activity, select the Prompt during run option.In the Send Email activity, select the Prompt option.Publish and specify default value.Publish the script.The Publishing dialog allows the publisher to specify a default value for each variable in the script.Prompt for run time value.When a user manually executes the published script, Toad prompts for a run time value for each variable in the script.The new value is used in this execution only and the default remains unchanged.Edit default value.After publishing, the script owner or any user with Manage privileges can modify the default value.To modify the default value, select the script in the Object Explorer and click the Edit script default variables button.If the script is scheduled, the default value is used in the scheduled execution.In the Web interface for Toad Intelligence Central 3.Automation script.See the Toad Intelligence Central Quick Start Guide for more information.Publish Data from Dimensional Viewer Using AutomationThis release includes a new Automation activity which allows you to export or publish data from a Dimensional View.Use this new activity in Automation workflows such as the following Publish Dimensional Viewer data to Intelligence Central as a dataset.You can publish each view container in the Dimensional Viewer document to a separate dataset.Publish Dimensional Viewer data to an Excel file.Then add a Publish File activity to your script to publish the Excel file to Intelligence Central.Improved Error Messaging.For scheduled scripts running on Intelligence Central, Toad provides improved error logging and more meaningful error messages.Data Management. Dimensional Viewer This release includes several new enhancements to the Dimensional Viewer.You can now export all views to a file or location, publish data to Intelligence Central, and edit the underlying query.Export All Views to Excel or Local Storage.You can now export all views containers.Multiple views can be exported to multiple worksheets in an Excel file or to multiple tables in Local Storage.To export to Excel, click Export All in the Wizard bar.To save to Local Storage, click Local Storage in the Wizard bar.Publish Data to Toad Intelligence Central.You can now publish view data to Intelligence Central as a dataset.Publish either a single view or publish multiple or all views.Each view is published as an individual dataset.To publish a single view, right click within the view and select Send To Publish Container.To publish multiple or all views, click Publish Data in the Wizard bar.Then in the Publishing dialog, click Publish Detail to select which views to publish.You can also give each dataset container a unique name.Note Publishing to Intelligence Central requires access to a Toad Intelligence Central server.Edit Query. You can now edit the underlying query for the Dimensional View document.Click Edit Query in the Dimensional View window.Connections. ODBC Connections Enable Disk Caching to Improve PerformanceFor ODBC connections, you can now instruct Toad to cache object metadata and retain it between Toad sessions.Using this option can improve performance in future requests.To specify this option, select Tools Options Database ODBC.OData. This release includes support for OData version 4.IBM i. Series ODBC.A Functions tab now displays in the Object Explorer for i.Series connections, as expected. Delete Files Smaller Than Windows 8 . Azure Data. Market.In this release of Toad Data Point, the option to create a connection to Azure Data.Market is no longer available.See https datamarket.Microsofts announcement to retire Data.Market. Automation.Dimensional View ActivityThis release includes a new Automation activity for exporting data from a Dimensional View.This new activity allows you to open an existing Dimensional View file, execute the query, and export the data to Excel, Local Storage, or Intelligence Central.To use the Dimensional Viewer activity, drag it from the Automation toolbox to the script design area.Select an existing Dimensional Viewer file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |