Chat now with support
Chat with Support

Toad Data Point 5.0 - Installation Guide

About Publishing Data

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.

What Data Sources You Can Publish From

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.

What Type of Objects Can Be Published

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.

How Data is Published From Toad

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.

Connectivity and Publishing

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.

Before Publishing

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.

  

Related Topics

Related Documents