Salesforce.com is one of the business intelligence data sources supported by Toad.
Read this topic to learn how Toad maps Salesforce.com data source objects and to review some considerations and limitations before working with Salesforce.com data sources.
To learn how to create a connection to Salesforce.com, see Create Salesforce Connections.
To learn about creating Salesforce queries in Toad, see Create Salesforce SOQL Queries.
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.
The following considerations apply when working with Salesforce.com data sources.
|Object Explorer||The Object Explorer displays the Salesforce.com 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||Salesforce.com 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||Salesforce.com connections are read-only. You cannot create tables and views or new columns using Toad. You cannot import data into a Salesforce.com 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.