Configure Oracle Accounts

Overview

You can configure your accounts in SnapLogic using the Designer or Manager. You can create an Oracle Account to connect Oracle Snaps with Oracle database instances.

Snap-account compatibility

The Snaps in the Oracle Snap Pack work with different accounts per the following table:

Snaps Oracle Thin Account Oracle Thin Dynamic Account
Oracle - Bulk Load Tick Icon Tick Icon
Oracle - Delete Tick Icon Tick Icon
Oracle - Execute Tick Icon Tick Icon
Oracle - Insert Tick Icon Tick Icon
Oracle - Lookup Tick Icon Tick Icon
Oracle - Merge Tick Icon Tick Icon
Oracle - Parallel Load Tick Icon Tick Icon
Oracle - Select Tick Icon Tick Icon
Oracle - Stored Procedure Tick Icon Tick Icon
Oracle - Table List Tick Icon Tick Icon
Oracle - Update Tick Icon Tick Icon

Account encryption

Standard Encryption If you are using Standard Encryption, follow the High sensitivity settings under Enhanced Encryption.
Enhanced Encryption If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected for this account:
  • High: Password.
  • Medium + High: Username, Password.
  • Low + Medium + High: All account fields.