Category
产品版本
主题
副主题
How to connect to Oracle Fusion in Toad Data Studio? (4378616)
Oracle Fusion connector is available in Toad Data Studio 2.0 and later versions. ... Watch the below video for details:
User Guide > DB2 Reports
Lists and describes activity reports that the Activity Monitor for the current DB2 for LUW database uses. ... This report also lists the switches required to gather data for a specific activity report.
User Guide > Create SharePoint Connections
Toad allows you to connect to SharePoint via OData service to view and query SharePoint lists as tables. ... You can also create a connection to SharePoint Online. ... Review the following for additional information:
User Guide > About MongoDB Data Sources
With Toad you can create a MongoDB connection, use the Query Builder or Editor to query data, and use the Database Explorer (Viewer) to view data and object details. ... MongoDB is a document database.
User Guide > Google Analytics Date Ranges
Each Google Analytics query requires a date range. ... In addition to using specific dates to define a range, Toad provides some relative date ranges for you to use. ... Date Ranges are selected from the Date Range drop-down list when building a multi-dimensional grid to view your Google Analytics data in the Database Explorer (Viewer).
User Guide > Complete SQL Statements Automatically
Code completion (autocompletion) assists you when entering SQL by automatically displaying a list of objects from which you can select in order to complete parts of your SQL statement. ... Code completion is available in the SQL Editor, as well as other editor windows, such as the Query tab in the Query Builder.
User Guide > Add or Remove Application Code
You can easily add syntax for another development tool such as C# to the SQL statement in the Editor to paste it into the development tool's code. ... You can also remove any syntax specific to the code development tool from the SQL statement so you can execute it in Toad.
User Guide > Publish Projects to Intelligence Central
Toad allows you to publish a project from the Project Manager as an object to a Toad Intelligence Central (TIC) server. ... After publishing, you can share and manage these projects similar to other objects in TIC.
User Guide > Create Generic OData Connections
Toad allows you to connect to OData services, a Business Intelligence data source, to view and query tables. ... After creating a connection, see About Business Intelligence and NoSQL Data Sources for more information about this data source.
User Guide > Add Column Totals and Subtotals
This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... <P class=Procedure>To add a column total or subtotal</P> <OL> <LI value=1>Right-click the data and select <B>Show | Summary Footer Panel</B>.
User Guide > Filter Data
You can filter data to reduce the amount of time required to query the data and display results. ... You can define an advanced data filter, which re-executes the query, or can define a basic data filter for a column, which does not re-execute the query.
User Guide > Specify Excel Export Options
You can export data to Excel from many different tools and locations in Toad, including the following: ... When you export to Excel, the Export options dialog allows you to specify Excel worksheet options for your exported data.
User Guide > Understand
User Guide > Project Manager
Use the Project Manager to conveniently group and organize files and other resources into projects. ... You can save nearly any Toad document or exported file and add it to a project as you work.
User Guide > Create Snowflake Connections
Toad allows you to create a native Snowflake connection, which provides you with a full-featured Object Explorer, Query Builder and SQL Editor. ... Note: You must have a Snowflake ODBC driver 2.24.2 (or later) installed before a native connection is created.
User Guide > Automate Find and Replace
In this tutorial you will learn how to use the Find and Replace activity to find text in a form letter or a report template and replace the text with run-time generated information. ... In this tutorial you will learn:
User Guide > About Working with Data
Use the Data tab of the Database Explorer to view data for the currently-selected object in the Object Explorer. ... From the data grid you can also export data or send data to other tools in Toad.
User Guide > Add Report Bands
A report band determines how and where controls from the Toolbox display in the report. ... The following report bands are available and can be added or removed from the Explorer tool window. ... See About Navigating Reports for more information.
User Guide > Snapshots in TIC
A snapshot is a table in Toad Intelligence Central (TIC) consisting of the result set of a query, the stored SQL query, and the mapping information to the remote object. ... A snapshot is a copy of the data taken at a specific point in time.
User Guide > Create Hive Connections
Toad allows you to connect to a Hive data warehouse system. ... Apache Hive is one of the NoSQL data sources supported by Toad. ... Review the following for additional information: ... Enter the host name or IP address of the Hive data source.
User Guide > Execute SQL
Use one of the following methods to execute SQL: ... To execute all statements, in order, one at a time, click or press F5. ... To execute the current statement, click or press F9. ... To execute the code within a code Region
User Guide > Create Histograms
Histograms are useful for getting a comprehensive overview of the range of data of a column. ... Histogram data can also show the distribution and density of values. ... This range can be used in where conditions and case statements.
User Guide > MySQL Reports
Description ... Help Topic ... Displays the first 10 rows of the mysql.help_topic table. ... Related Topics ... About Managing Reports
User Guide > Publish Toad Documents to Intelligence Central
Toad allows you to publish Toad documents as objects to a Toad Intelligence Central (TIC) server. ... After publishing, you can share and manage these Toad documents similar to other objects in TIC.
User Guide > Execute/Schedule Automation Scripts
You can execute automation scripts on demand from the Automation window or the Project Manager. ... You can also schedule scripts to run on a recurring basis at a specific time. ... For example, schedule a script that performs long-running tasks to run when database activity is light.
新产品关联性