The driver automatically maps Oracle Eloqua objects and fields to tables and columns when it first connects to an Oracle Eloqua instance. The driver maps standard as well as custom objects, including relationships defined among objects. Relationships among objects can be reported with the metadata methods getBestRowIdentifier(), getColumns(), getExportedKeys(), getImportedKeys(), getPrimaryKey(), getTables(), and getTypeInfo().
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.
