Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
A data source is added, or mapped, to a Toad Intelligence Central server when an object from that data source is published to the TIC server. See Publish to Toad Intelligence Central for more information.
A mapped Data Source in Toad Intelligence Central provides the connection to a remote data source. A remote source can be a traditional relational database, such as Oracle or SQL Server, or a non-traditional data source, such as OBIEE or Hive. Most remote data sources that you can connect to using Toad can be mapped as a data source in Intelligence Central. See the Toad Data Point Release Notes for a list of currently supported platforms.
You can view or modify Authentication key information for a datasource using the Alter Authentication dialog.
Data source authentication is performed at the object level in Toad.
To view or modify Authentication key
See User Authentication in Intelligence Central for more information about data source authentication.
An object's data source is displayed in the Alter Authentication dialog and in the Authentication Settings page of the Publishing dialog. Data source names use the following format.
For SQL Server, Sybase, and MySQL, the database name is appended to the end.
<database abbrev>_<host>_<database name>