Versions Compared

Old Version 26

changes.mady.by.user Lakshmi Manda

Saved on

compared with

New Version Current

changes.mady.by.user Gouri Bhagchandani

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use this account type to connect Oracle Snaps with data sources that use Oracle accounts. This account uses dynamic values and enables you to specify account properties as expressions that reference Pipeline parameters.

Multiexcerpt include macro
nameSecrets_Management_Dynamic_Accounts
templateData[]
pageS3 Dynamic Account
addpanelfalse


Multiexcerpt include macro
nameOracle JDBC Driver Upgrade
templateDataeJyLjgUAARUAuQ==
pageOracle Snap Pack
addpanelfalse

...

Known Issues

None.

Account Settings

Image RemovedImage Added

Parameter NameData TypeDescriptionDefault ValueExample
Label*StringRequired. Unique name for the account.N/AOracle123DB
JDBC URL SourceStringDropdown 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. 

    Note

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


Snap GeneratedN/A
Account properties*StringFieldsetRequired. Enter the information to create a connection to the database.N/AN/A
HostnameString/Expressions

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

Multiexcerpt include macro
nameExpEnabled
pageREST Put

Info

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.


N/A
  • oratestdb2.cwztruwzzvnq.us-east-1.rds.amazonaws.com

  • 190.159.0.124

Port NumbernumberString/Expressions

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

Multiexcerpt include macro
nameExpEnabled
pageREST Put

15211521
Database nameString/Expressions

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

Multiexcerpt include macro
nameExpEnabled
pageREST Put

N/AMYDB
Custom JDBC URLString/Expressions

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

Multiexcerpt include macro
nameExpEnabled
pageREST Put

N/AN/A
UsernameString/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.

Multiexcerpt include macro
nameExpEnabled
pageREST Put

N/ATECTONIC
PasswordString/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.

Multiexcerpt include macro
nameExpEnabled
pageREST Put

N/AN/A
JDBC JARsStringFieldset

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

N/AN/A
JDBC DriverdriverString


Multiexcerpt macro
hiddenfalse
nameOracle JDBC Driver Upgrade -Behavior Change
fallbackfalse

The Oracle JDBC Driver is migrated from ORAJDBC6 (11.2.0.4 version) to OJDBC10 JAR (19.20.0.0 version). However, you can specify a custom JBDC driver to use. Click the Database  icon to upload an existing JAR file from the SLDB. If this property is left blank, a default JDBC driver is loaded.

falseBehavior Change

This JDBC driver upgrade has resulted in specific behavior changes within the Snap Pack. These changes include errors, status codes, and success and failure messages. The latest JDBC driver upgrade is backward-compatible.  



Note

When you use the relative path for the JDBC JAR file in accounts across different projects, the pipelines fail with the JAR FILE NOT FOUND error. Therefore, you must use the absolute path for the JDBC JAR file to run your pipelines successfully.


Warning

Only v11.2.0.4.0 of a JDBC driver supports user-defined types.


N/AProject Spaces/my_diagnostic_space/my_diagnostic /sqljdbc4-2.0.jar
JDBC Driver ClassJDBC driver class*StringRequired. The name of the JBDC driver to use.oracle.jdbc.OracleDriveroracle.jdbc.OracleDriver
Database specifier type*StringDropdown 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 nameService name
SSL/ TCPSStringCheckbox

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

Authentication method



Dropdown List

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

  • User ID and Password

  • Kerberos

    Note

    • Kerberos authentication for Oracle supports both Windows and Linux-based databases and also supports Service account and User impersonation Kerberos authentication.

    • When the authentication method is Kerberos, for service account, you must leave the Username and Password fields empty and add the below property to the URL Properties:

      oracle.net.kerberos5_cc_name = <Path to cache file>


User ID and PasswordKerberos

Kerberos config path


String/Expression

Appears when the Authentication method is Kerberos. 

Specify the path to the Kerberos configuration file.


Note

Kerberos authentication for Oracle supports both Windows and Linux-based databases and also supports Service account and User impersonation Kerberos authentication.


N/A/opt/app/oracle/dbhome/network/admin/krb5.conf
Advanced propertiesN/ASpecify advanced properties to connect to the database.N/AN/A
Auto commitStringCheckbox/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.
SelectedSelected
Batch size*Integer/Expressions

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*Integer/Expressions

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*Integer/ExpressionsRequired. Set the maximum number of connections that a pool must maintain at a time.5050
Max life timelifetime (minutes)*Integer/ExpressionsRequired. 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 Timeouttimeout (minutes)*Integer/ExpressionsRequired. 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.55
Checkout timeout (milliseconds)*Integer/Expressions

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

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.


1000010000
URL PropertiespropertiesN/ASpecify input regarding URL properties.N/AN/A
URL property nameString/ExpressionsName for the URL property.N/ABatch_Refresh_Time
URL property valueNString/AExpressionsValue for the URL property.N/A10

...