Page Comparison

Label

Default Value: N/A
Example: Oracle123DB

String

None

Required. Specify a unique name for the account.

JDBC URL Source

Default Value: Snap Generated
Example: User Provided

String

None

Required. Select the source of the JDBC URL. 

• Snap Generated: The JDBC URL that SnapLogic generates using the details you provide in the Account Settings popup.

• User Provided: The JDBC URLs that you provide directly into the Custom JDBC URL field. 

  Note
  If you select the User Provided option, the Host Name, Port Number, and Database Name fields are replaced by the Custom JDBC URL field.

  
  

Account properties

Required. Enter the information to create a connection to the database.

Hostname

Default Value: N/A
Example: 

• oracledb22.abcdefghijkl.us-west-5.rds.amazonaws.com

• 190.159.0.124

String/Expressions

None

Required if JDBC URL Source is Snap Generated. The server address to which the application must connect.

Port Numbernumber

Default Value:1521
Example:1521

String/Expressions

None

Required if JDBC URL Source is Snap Generated. The database server's port number to which the application must connect.

Database name

Default Value: N/A
Example: MYDB

String/Expressions

None

Required if JDBC URL Source is Snap Generated. The database name to which the application must connect.

Custom JDBC URL

Default Value: N/A
Example: Oracle123DB

String

None

Required if JDBC URL Source is User Provided. The JDBC URLs that you want to use to connect to your Oracle account.

Username

Default Value: N/A
Example: TECTONIC

String/Expressions

None

The user name that is allowed to connect to the database. It is used as the default username when retrieving connections. The user name must be valid in order to set up the data source.

Password

Default Value: N/A
Example: Oracle123DB

String/Expressions

None

The password used to connect to the data source. It is used as the default password when retrieving connections. The password must be valid in order to set up the data source.

JDBC JARs

List of JDBC JAR files to be loaded. Click  to add a JDBC Driver; click  to remove a JDBC Driver.

JDBC Driverdriver

Default Value: N/A
Example: N/A

String

None

Learn more: Oracle Driver Upgrade from Oracle JDBC 11.2.0.4 Driver to 19.20.0.0 Driver

Enter the JDBC jar file to be loaded. Use  to select an existing file. A different driver binary for a driver must have a different name, the same name can not be reused for a different driver. If this property is left blank, a default JDBC driver is loaded.

JDBC Driver ClassJDBC driver class

Default Value: oracle.jdbc.OracleDriver
Example: oracle.jdbc.OracleDriver

String

None

Required. The name of the JBDC driver to use.

Database specifier type

Default Value: Service name
Example: Service name

StringDropdown List

None

Specify the database specifier type to use. The selected option decides which format of URL for JDBC is to be used internally. The valid options are:

• SID: Uses the jdbc:oracle:thin@HOST:PORT:DBNAME format.

• Service name: Uses the jdbc:oracle:thin@//HOST:PORT/DBNAME format. 

SSL/ TCPS

Default Value: Deselected

StringCheckbox

Opt for or against connecting through SSL to the Oracle instance.

If selected, the following format of URL is used internally:

jdbc:oracle:thin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<HOST>)(PORT=<PORT>))(CONNECT_DATA=(<SID/ SERVICE_NAME>=<DATABASE_NAME>)))

Authentication method

Default Value: User ID and Password
Example: Kerberos

Dropdown List

 None

Choose the authentication method to use when connecting to Oracle. The available options are:

• User ID and Password

• Kerberos

Kerberos config path

Default Value: N/A
Example: /opt/app/oracle/dbhome/network/admin/krb5.conf

String/Expression

Appears when the Authentication method is Kerberos.

Specify the path to the Kerberos configuration file.

Advanced properties

Specify advanced properties to connect to the database.

Auto commit

Default Value: Selected

StringCheckbox/Expressions

None

Opt for or against setting the auto-commit property for a database.

• When selected, each of the batches is committed immediately after it is executed. If the Snap fails, only the batch being executed at that moment is rolled back.

• When not selected, the Snap execution output is committed only after all the batches are executed. If the Snap fails, the entire transaction is rolled back, unless the Snap finds invalid input data before it sends the insert request to the server, and routes the error documents to the Error view.

Batch size

Default Value: 50
Example: 100

Integer/Expressions

None

Required. Set the number of statements that the Snap must execute at a time.

Fetch size

Default Value: 100
Example: 100

Integer/Expressions

None

Required. Set the number of rows that the Snap must fetch at a time when executing a query.

Max pool size

Default Value: 50
Example: 50

Integer/Expressions

None

Required. Set the maximum number of connections that a pool must maintain at a time.

Max life timelifetime (minutes)*

Default Value: 30
Example: 35

Integer/Expressions

None

Required. Set the maximum time (in minutes) of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed.

Idle Timeout (minutes)*

Default Value: 5
Example: 5

Integer/Expressions

None

Required. Set the maximum time (in minutes) that a connection is allowed to sit idle in the pool. A value of 0 indicates that idle connections are never removed from the pool.

Checkout timeout (milliseconds)*

Default Value: 10000
Example: 10000

Integer/Expressions

None

Required. Set the time in milliseconds to wait for a connection to be available when the pool is exhausted. 

URL Propertiesproperties

Specify input regarding URL properties.

URL property name

Default Value: N/A
Example: Batch_Refresh_Time

String/Expressions

None

Name for the URL property.

URL property value

Default Value: N/A
Example: 10

NString/AExpressions

None

Value for the URL property.