You can use Toad Data Point to publish data to a Toad Intelligence Central (TIC) server in order to store and share data from remote data sources. Intelligence Central is like a federated server where you can store data from a variety of data sources. See About Toad Intelligence Central for more information.
Note:This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
For a video demonstration of this feature, please see Publishing to Intelligence Central.
You can publish data from any data source that you can connect to using Toad. Data sources that use native provider connections must also be ODBC-compliant.
Data can be published in the form of views, snapshots, and datasets. See Data Objects in Toad Intelligence Central for more information about these objects.
You can publish data from any of the following: an object in the Object Explorer, a query statement in the Editor or Query Builder, or the data in a data grid.
Toad Data Point uses three types of connectivity: native database provider connectivity, ODBC connectivity, and Data Services (Business Intelligence and NoSQL) connectivity. However, Toad Intelligence Central uses only ODBC and Data Services connectivity. If you publish data objects to a TIC server using a native database provider connection, the connection is converted to ODBC on the TIC server.
If you are publishing data using a native provider or ODBC connection, the corresponding ODBC driver must exist on the TIC server. In addition, for native database connections other necessary client files must exist on the TIC server. To learn how to prepare the TIC server for publishing, see Prepare to Publish Data to Toad Intelligence Central.