Shared Content for Data Engineering All Products
The Java class that you use to connect to the database.
The following list provides the driver class name that you can enter for the applicable database type:
The URL that you use to connect to the database.
The following list provides the connection string that you can enter for the applicable database type:
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
ALTER SESSION SET CURRENT_SCHEMA=INFA_USR;
Enclose special characters in double quotation marks.
Optional. SQL commands to execute before each transaction. The Data Integration Service executes the transaction SQL at the beginning of each transaction.
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Enclose special characters in double quotes.
Optional. The character that you will use for quotes in this connection.
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the QuoteChar property. Default is DOUBLE_QUOTE.
Optional. Select to enable quotes or not for this connection.
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. Valid values are True or False. Default is True.