Purpose

Specifies the name and location of the configuration file used to create the relational map of native data. The driver looks for this file when connecting to an Oracle Sales Cloud instance. If the file does not exist, the driver creates one.

Valid Values

string

where:

string
is the absolute path and filename of the configuration file, including the .config extension. For example, if SchemaMap is set to a value of C:\\Users\\Default\\AppData\\Local\\Progress\\DataDirect\\Oracle_Sales_Cloud_Schema\\testuser.config, the driver either creates or looks for the configuration file testuser.config in the directory C:\Users\Default\AppData\Local\Progress\DataDirect\Oracle_Sales_Cloud_Schema\.

Notes

  • When connecting to a server, the driver looks for the SchemaMap configuration file. If the configuration file does not exist, the driver creates a SchemaMap configuration file using the name and location you have provided. If you do not provide a name and location for a SchemaMap configuration file, the driver creates it using default values.
  • The driver uses the path specified in this connection property to store additional internal files.
  • You can refresh the internal files related to an existing relational view of your data by using the SQL extension Refresh Map. Refresh Map runs a discovery against your native data and updates your internal files accordingly.

Example

As the following examples show, escapes are needed when specifying SchemaMap for a DataSource but are not used when specifying SchemaMap in a DriverManager connection URL.

DriverManager example

jdbc:datadirect:oraclesalescloud://mysite.custhelp.com;
SchemaMap=C:\Users\Default\AppData\Local\Progress\DataDirect
   \Oracle_Sales_Cloud_Schema\testuser.config

DataSource example

OracleSalesCloudDataSource mds = new OracleSalesCloudDataSource();
mds.setDescription("My OracleSalesCloudDataSource");
mds.setServerName("mysite.custhelp.com");
mds.setSchemaMap("C:\\Users\\Default\\AppData\\Local\\Progress
   \\DataDirect\\Oracle_Sales_Cloud_Schema\\testuser.config")

Data Source Method

setSchemaMap

Default

The default is determined by the environment. The driver attempts to create the files in a subdirectory of the first available directory in the following order:

  • Windows
    • DD_HOME environment variable
    • dd.home system property
    • LOCALAPPDATA environment variable
    • APPDATA environment variable
    • user.home system property
    For Windows, the file path takes the following format:
    available_location\Progress\DataDirect\Oracle_Sales_Cloud_Schema\user_name.config
  • UNIX/Linux
    • DD_HOME environment variable
    • dd.home system property
    • user.home system property
    For UNIX/Linux, the file path takes the following format:
    available_location/progress/datadirect/Oracle_Sales_Cloud_schema/user_name.config

Data Type

String