Toad Intelligence Central uses the following types of connectivity to make connections to remote data sources:
Because Intelligence Central uses ODBC connectivity, when data is published from a native-provider connection, Toad converts the connection to ODBC (if the database is ODBC-compliant). Before you can successfully publish data from a native-provider (or ODBC) connection, everything necessary to create the correct corresponding ODBC connection must be installed on the Intelligence Central server. This includes the corresponding ODBC driver for the database type, as well as any additional client files required for a correct ODBC connection.
If data is published from an ODBC connection, you must ensure that the DSN name on the Toad Data Point computer and the Intelligence Central server match.
Note:This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
If you plan to publish data objects from a remote database connection using ODBC connectivity in Toad Data Point, the ODBC connection must use a System DSN. This is required for compatibility with Intelligence Central, which uses only System DSNs.
To specify a System DSN for an ODBC connection
Select the System DSN tab and click Add.
Note: You must configure a System DSN because TIC uses only System DSNs.
In order for Toad Data Point users to successfully publish data to Intelligence Central, the Intelligence Central server must have the same ODBC driver, DSN name, and necessary client files that exist on the Toad Data Point user’s computer for each data source. These files are used by Toad Data Point to create the data source connection.
For the data source type you will be using, ensure that the necessary drivers and files are installed on the Intelligence Central server, and that they are the same as those installed on the Toad Data Point user’s computer.
Ensure Toad Data Point is installed on the Toad Intelligence Central host computer. If you plan to schedule and run Automation scripts on Intelligence Central, Toad Data Point must be installed. Additional benefits of having Toad Data Point installed along-side Intelligence Central include the following:
Beginning with Intelligence Central 3.0, when you install using the Toad Intelligence Central Server Installer, Toad Data Point is automatically installed.
For best results, ensure the version of Toad Data Point on the Intelligence Central host computer is the same (or later) as that used to create the Automation scripts.
In addition to installing Toad Data Point, install these additional files if publishing from any of these data sources.
Publishing from Oracle Data Sources
To prepare the Intelligence Central server to receive published data objects from an Oracle database, please ensure that the following are installed on the TIC server:
Publishing from DB2 Data Sources
To prepare the Intelligence Central server to receive published data objects from a DB2 database, please ensure that the following are installed on the TIC server:
Publishing from Teradata Data Sources
To prepare the Intelligence Central server to receive published data objects from a Teradata database, please ensure that the following are installed on the TIC server:
Publishing from ODBC Connections
If you plan to publish objects from Toad Data Point using ODBC connectivity, the Intelligence Central DSN must match the DSN of the original connection used to publish the object.
Ensure the following are true about the Toad Data Point and Intelligence Central ODBC connections:
If you plan to run Toad Data Point Automation scripts that send email, the Intelligence Central server must be configured to support SMTP email transmission. For more information about preparing the Intelligence Central server for published Automation scripts, see Prepare to Publish Automation Scripts.
If an Automation Script scheduled to execute on the Toad Intelligence Central server includes an instruction to run a macro in an Excel spreadsheet, then Microsoft Excel must be installed on the Toad Intelligence Central host computer. For more information about preparing the Intelligence Central server for published Automation scripts, see Prepare to Publish Automation Scripts.