Skip to end of banner
Go to start of banner

Oracle Thin Dynamic Account

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

In this article

Overview

Use this account type to connect Oracle Snaps with datasources that use Oracle Thin Dynamic accounts. This account deals with the dynamically calculated values. You can specify the account properties as expressions referencing pipeline parameters. The values for dynamic accounts are not stored; hence, use them when requested.

Troubleshooting

  • None.

Account Settings



Use the Create Account window\Settings tab to create Oracle Thin Dynamic accounts:

Parameter NameData TypeDescriptionDefault ValueExample
LabelStringRequired. The name for the account. Preferably, update the account name if your project includes more than one account of the same type.N/AOracle123DB
Account propertiesStringRequired. Enter the information to create a connection to the database.N/AN/A
HostnameStringRequired. The server address to which the application must connect.N/Aoratestdb2.cwztruwzzvnq.us-east-1.rds.amazonaws.com
Port NumberStringRequired. The database server's port number to which the application must connect.15211521
Database nameStringRequired. The database name to which the application must connect.N/AMYDB
UsernameStringThe 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/ATECTONIC
PasswordStringThe 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 JARsString

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

N/AN/A
JDBC DriverString

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.

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

N/AN/A
JDBC Driver ClassStringRequired. The name of the JBDC driver to use.oracle.jdbc.OracleDriveroracle.jdbc.OracleDriver
Database specifier typeString

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/ TCPSString

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 propertiesN/ASpecify advanced properties to connect to the database.N/AN/A
Auto commitString

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 sizeInteger

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

Select queries are not batched.

Using a large batch size could use up the JDBC placeholder limit of 2100.

50100
Fetch sizeInteger

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

Large values could cause the server to run out of memory.

100100
Max pool sizeIntegerRequired. Set the maximum number of connections that a pool must maintain at a time.5050
Max life timeIntegerRequired. 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 TimeoutIntegerRequired. 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 timeoutInteger

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
URL PropertiesN/ASpecify input regarding URL properties.N/AN/A
URL property nameStringName for the URL property.N/ABatch refresh time in seconds
URL property valueN/AValue for the URL property.N/A10

Prerequisites

  • None.

Limitations

  • None.
  • No labels

Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.