Name |
Specify a logical database identifier. For the source, specify
the database you want to copy data from. For the target, specify the
database to write the data to. |
className |
Specify the class name of your database driver as follows: - If using Oracle, set to: oracle.jdbc.OracleDriver
- If using DB2®,
set to: com.ibm.db2.jcc.DB2Driver
|
jdbcURL |
Specify the URL to connect to the database: - If using Oracle, set to: jdbc:oracle:thin:@<DatabaseServerHostname/IPaddress>:<TNSListenerPortNumber>:<DatabaseSID>.
- If using DB2,
set to: jdbc:db2://<Database Server Hostname>:<Port
Number>/<Database name>.
|
dbType |
Specify the type of database you are running. Enter it in all
lower case, as shown: - For Oracle, specify oracle
- For DB2,
specify db2
- For an XML datasource, specify xml
|
folder |
If using an XML datasource, specify the complete path of the
folder location for the XML files. |
httpurl |
Only applicable for the target database. Specify a URL for
the application server whose data cache is to be refreshed after data
is deployed into the target database. Use the syntax: http://<hostname/ip-address>:<port-number>/<Application>/interop/InteropHttpServlet,
where <hostname/IP-address> is the server address
where the application is running, <port-number> is
the port on which the application is running, and <Application> is
the name of the application; for example, smcfs. |
httpuser |
Specify the user name associated with the application server
whose data cache is to be refreshed after data is deployed into the
target database. |
schema |
Specify the schema owner as follows: - If you are using Oracle or DB2 database, and the user you specify is different
from the Sterling Selling and
Fulfillment Foundation schema
owner, specify the owner of the Sterling Selling and
Fulfillment Foundation schema.
|
user |
Specify the user name associated with the database. |