skip to main content
Welcome to the Progress DataDirect for JDBC for Oracle Sales Cloud Driver : Mapping objects to tables
  

Try DataDirect Drivers Now

Mapping objects to tables

The driver automatically maps Oracle Sales Cloud objects and fields to tables and columns when it first connects to an Oracle Sales Cloud instance. The driver maps standard as well as custom objects. The driver uses a local schema map to instantiate the mapping of the remote data source objects to tables and the metadata associated with those tables. The driver creates a schema map for each user. By default, the schema map is created in the directory from which the application is run. The CreateMap connection property allows you to update or re-create the schema map. The schema map uses the user ID specified for the connection as the name of the schema map configuration file. If the user ID contains punctuation or other non-alphanumeric characters, the driver strips those characters from the user ID to form the name of the schema map configuration file. You can set the SchemaMap connection property to override the default setting for the name and location of the database.
Note that the Refresh Map SQL extension can also be used to update the relational map of your data.