Label*

String

Required. Unique name for the account.

N/A

Oracle123DB

JDBC URL Source

Dropdown List

Required. The source of the JDBC URL that you want to use. 

• 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. 

Snap Generated

N/A

Account properties*

Fieldset

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

N/A

N/A

Hostname

String/Expressions

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

N/A

• oratestdb2.cwztruwzzvnq.us-east-1.rds.amazonaws.com

• 190.159.0.124

Port number

String/Expressions

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

1521

1521

Database name

String/Expressions

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

N/A

MYDB

Custom JDBC URL

String/Expressions

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

N/A

N/A

Username

String/Expressions

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.

N/A

TECTONIC

Password

String/Expressions

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.

N/A

N/A

JDBC JARs

Fieldset

List of JDBC JAR files to be loaded. Click 

N/A

N/A

JDBC driver

String

N/A

Project Spaces/my_diagnostic_space/my_diagnostic /sqljdbc4-2.0.jar

JDBC driver class*

String

Required. The name of the JBDC driver to use.

oracle.jdbc.OracleDriver

oracle.jdbc.OracleDriver

Database specifier type*

Dropdown List

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. 

Service name

Service name

SSL/ TCPS

Checkbox

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>)))

For more information, refer to Configure Oracle Client for SSL/TLS (TCPS) Connection.

Not Selected

Not Selected

Authentication method

Dropdown List

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

• User ID and Password

• Kerberos

User ID and Password

Kerberos

Kerberos config path

String/Expression

Appears when the Authentication method is Kerberos. 

Specify the path to the Kerberos configuration file.

N/A

/opt/app/oracle/dbhome/network/admin/krb5.conf

Advanced properties

N/A

Specify advanced properties to connect to the database.

N/A

N/A

Auto commit

Checkbox/Expressions

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.

Selected

Selected

Batch size*

Integer/Expressions

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

50

100

Fetch size*

Integer/Expressions

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

100

100

Max pool size*

Integer/Expressions

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

50

50

Max lifetime (minutes)*

Integer/Expressions

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.

30

35

Idle timeout (minutes)*

Integer/Expressions

Required. Set the maximum time (in seconds?) 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.

5

5

Checkout timeout (milliseconds)*

Integer/Expressions

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

10000

10000

URL properties

N/A

Specify input regarding URL properties.

N/A

N/A

URL property name

String/Expressions

Name for the URL property.

N/A

Batch_Refresh_Time

URL property value

String/Expressions

Value for the URL property.

N/A

10