Shared Content for Data Engineering
All Products
Option
| Description
|
---|---|
JDBCDriverClassName
| 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:
|
MetadataConnString
| 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:
|
EnvironmentSQL
| 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.
For example,
ALTER SESSION SET CURRENT_SCHEMA=INFA_USR;
Enclose special characters in double quotation marks.
|
TransactionSQL
| Optional. SQL commands to execute before each transaction. The Data Integration Service executes the transaction SQL at the beginning of each transaction.
For example,
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Enclose special characters in double quotes.
|
QuoteChar
| 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.
|
EnableQuotes
| 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.
|
hadoopConnector
| Required if you want to enable Sqoop connectivity for the data object that uses the JDBC connection. The Data Integration Service runs the mapping in the Hadoop run-time environment through Sqoop.
You can configure Sqoop connectivity for relational data objects, customized data objects, and logical data objects that are based on a JDBC-compliant database.
Set the value to
SQOOP_146 to enable Sqoop connectivity.
|
hadoopConnectorArgs
| Optional. Enter the arguments that the Sqoop program must use to connect to the database. Enclose the Sqoop arguments within single quotes.
For example,
hadoopConnectorArgs='--<Sqoop argument 1> --<Sqoop argument 2>' If you do not enter Sqoop arguments, the Data Integration Service constructs the Sqoop command based on the JDBC connection properties.
|
Updated April 22, 2019