Importing Metadata

Use the adapter datastore to import the Salesforce.com metadata that you want to use in your data flows. You can browse for metadata to import, or specify the name of a table to import.

To import metadata by browsing:

1. In the Local Object Library pane located in the lower-left part of the screen, click the Datastores tab, and then double-click your adapter datastore.

The Datastore Explorer lists the tables that are available through your Salesforce.com connection.

2. To view information about a table, expand the table and then expand any of the following folders as needed:
   • Referenced By: This folder contains the tables that reference the selected table. It is not available if the selected table is not referenced by other tables.
   • References: This folder contains the tables that the selected table references. It is not available if the selected table does not reference other tables.
   • Columns: This folder contains the columns that are part of the selected table.
3. Choose one:
   • To import the metadata of a specific table, right-click the table and then click Import.
   • To import the metadata of all the tables that belong to a folder, right-click the folder and then click Import.

In the Local Object Library pane, the imported metadata appears as tables nested under the adapter datastore.

To import metadata by name:

1. In the Local Object Library pane located in the lower-left part of the screen, click the Datastores tab.
2. Right-click your adapter datastore and then click Import By Name.
3. In the Table Name field, type the table name of the metadata that you want to import, and then click OK.

In the Local Object Library pane, the imported metadata appears as tables nested under the adapter datastore.

The DI_PICKLIST_VALUES Table

A picklist is a Salesforce.com field type that contains a numbered list of values from which one value can be selected. The Simba Salesforce SAP Data Services Adapter represents picklists using a virtual table named DI_PICKLIST_VALUES, which contains all the picklists in your Salesforce.com data source. To use picklist values in your data flows, use the adapter to import the DI_PICKLIST_VALUES table.