Data mapping describes how to map elements between two distinct data models, usually distinguished as the source and the target. To support SQL access to Oracle Service Cloud data stores, the driver maps data source objects to target relational tables. The driver maps standard and custom objects and includes relationships defined between objects. The first time it connects to an Oracle Service Cloud instance the driver automatically maps source objects and fields to tables and columns. On subsequent connections, the Oracle Service Cloud driver detects when the underlying schema has changed and automatically updates the relational map.
The driver uses a local embedded database to instantiate the mapping of the remote data source objects to tables and the metadata associated with those tables. The driver creates one database for each user. The embedded database is created in the directory from which the application is run. The CreateDB connection property allows you to update or re-create the embedded database that defines and handles the object-to-table mapping. The embedded database uses the user ID specified for the connection as the name of the database. 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 database. You can set the DatabaseName connection property to override the default setting for the name and location of the database.
See the following topics for more information on configuring embedded databases:
