In this article

Overview

Use this account type to connect Oracle Snaps with datasources data sources that use Oracle accounts.

Prerequisites

None.

...

Known Issues

None.

Account Settings

Image Removed

...

...

Info

Asterisk ( * ): Indicates a mandatory field. Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration. Expression icon ( ): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic. Add icon ( ): Indicates that you can add fields in the field set. Remove icon ( ): Indicates that you can remove fields from the field set.

Field Name	Field Type	Description
Label Default Value: N/A Example: Oracle123DB	String	Required. Unique name for the account.

N/AOracle123DB

JDBC URL Source Default Value: Snap Generated Example: User Provided	String	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.

Snap GeneratedN/A

Account properties

StringHostname

	Required. Enter the information to create a connection to the database.
Hostname Default Value: N/A

N/A

Example:  oracledb22.abcdefghijkl.us-west-5.rds.amazonaws.com 190.159.0.124

String

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

application Port Number

application must connect.

N/Aoratestdb2.cwztruwzzvnq.us-east-1.rds.amazonaws.com

If you need to connect to an on-premise server, specify the domain name or the IP address. For example, test.mydbserver.com or 190.159.0.124.
Port Number Default Value:1521 Example:1521	String	Required if JDBC URL Source is Snap Generated.

 The database 

The database server's port number

to which

to which the application

must connectDatabase name

must connect.

15211521

Database name Default Value: N/A Example: MYDB

String

Required if JDBC URL Source is Snap Generated. The

database name to which

database name to which the application

must connect

must connect.

NCustom JDBC URL

Custom JDBC URL Default Value: N/A

MYDB

Example: Oracle123DB

String

Required if JDBC URL Source is User Provided. The JDBC URLs that you want to use to connect to your Oracle account. Note Use this option if you want to use complex JDBC URLs (involving multiple hosts and advanced options) to connect to your Oracle instance. For example, if you want to connect to Oracle DataGuard, you can enter a JDBC like the one below: jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(LOAD_BALANCE=on)(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=OracleTest)))

N/A

Username Default Value: N/A

UsernamePassword

Example: TECTONIC	String	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

TECTONIC

Example: Oracle123DB

String

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/AN/A

JDBC JARs

String

List

of JDBC JAR files

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

JDBC Driver Default Value: N/A

N

Example: N/A

String

Multiexcerpt include macro name Oracle JDBC Driver

String

Upgrade -Behavior Change templateData eJyLjgUAARUAuQ== page Oracle Thin Dynamic Account addpanel false 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 Image Modified 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. Warning Only v11.2.0.4.0 or higher

of a JDBC Driver Class

JDBC driver supports user-defined types.

N/AN/A

JDBC Driver Class Default Value:oracle.jdbc.OracleDriver Example: oracle.jdbc.OracleDriver

String

Required. The name of the JBDC driver to use

.oracle.jdbc.OracleDriveroracle.jdbc

.

OracleDriver

Database specifier type Default Value: Service name Example: Service name	String	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 nameService name

SSL/ TCPS Default Value: Deselected	String	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>)))

Not SelectedNot Selected

Advanced properties

N/A

Specify advanced properties to connect to the database.

N/AN/ABatch size

Auto commit Default Value: Selected	String	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.

SelectedSelectedFetch size

Batch size Default Value: 50 Example: 100

Integer

Required. Set the number of statements that the Snap must execute at a time. Note Select queries are not batched. Warning Using a large batch size could use up the JDBC placeholder limit of 2100.

50100

Fetch size Default Value: 100 Example: 100

Integer

Required. Set the number of rows that the Snap must fetch at a time when executing a query. Warning Large values could cause the server to run out of memory.

100100

Max pool size Default Value: 50 Example: 50	Integer	Required. Set the maximum number of connections that a pool must maintain at a time.

5050Idle Timeout

Max life time Default Value: 30 Example: 35

Integer

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.

3035

Idle Timeout Default Value: 5 Example: 5

Integer

Required. Set the maximum time (in

secondsCheckout timeout

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.

55

Checkout timeout Default Value: 10000 Example: 10000

Integer

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

 Zero waits forever.

An exception is thrown after the wait time has expired.

1000010000

Info If you provide 0, the Snap waits infinitely until the connection is available. Therefore, we recommend you not to specify 0 for Checkout Timeout.

URL Properties

N/A

Specify input regarding URL properties.

N/A

URL property name Default Value: N/A

URL property name

Example: Batch_Refresh_Time

String

Name for the URL property.

N

URL property value Default Value: N/A

Batch_Refresh_TimeURL property value

Example: 10

N/A

Value for the URL property.

N/A10

Troubleshooting

See Also

...

...