Chat now with support
Chat mit Support

Toad Data Point 6.1.2 - Installation Guide

About Data Sources is one of the business intelligence data sources supported by Toad.

Read this topic to learn how Toad maps data source objects and to review some considerations and limitations before working with data sources.

To learn how to create a connection to, see Create Salesforce Connections.

To learn about creating Salesforce queries in Toad, see Create Salesforce SOQL Queries.

Toad Automatically Maps Object Metadata

When you create a new connection to a Business Intelligence or NoSQL data source, Toad automatically maps the data source objects. Toad gathers metadata from these objects which is cached (in a hidden table) and retained between sessions for one week. After one week, all objects are automatically refreshed.

During this initial mapping process, Toad maps only metadata. The actual data in each column is mapped as needed, such as when you execute a query.

Manually refresh object metadata

You can manually refresh object metadata at any time. In the Object Explorer, right-click an object and select Refresh All.

Considerations and Limitations

The following considerations apply when working with data sources.

Consideration/Limitation Description
Object Explorer The Object Explorer displays the Tables and Views that were mapped by Toad, either when the connection was initially created or when the objects were refreshed.
Max character limit Toad maps up to 255 characters per VARCHAR data field.
Delay when executing query columns and data are mapped as needed. Because of this, you may experience a delay when attempting to view columns and data or when executing a query.
Read-only connections are read-only. You cannot create tables and views or new columns using Toad. You cannot import data into a data source from Toad.

Tip: You can view character field lengths for each column by opening a table in the Database Explorer and viewing the Columns tab.


Related Topics

Create Salesforce SOQL Queries

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen