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 Oracle Service Cloud driver maps data source objects to target relational tables. The first time it connects to an Oracle Service Cloud instance the driver automatically maps Oracle Service Cloud objects and fields to tables and columns. The driver maps standard and custom objects and includes relationships defined between objects.
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 option 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 Database connection option to override the default setting for the name and location of the database. See "Config Options", "Create Database", and "Database" for details on setting connection options for embedded databases.
