Versions Compared

Key

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

Use the Oracle Snap Pack to connect to your Oracle database and achieve read and write access to its objects. 

Use Snaps in this Snap Pack to:

  • Get a list of tables in a database.
  • Lookup records in the target table and returns a selected set of fields.
  • Fetch data from a database.
  • Execute SQL statements to delete, update, merge or insert data within a specified table.
  • Execute a stored procedure.

Supported Versions

This Snap Pack by default uses the Oracle 11i JDBC driver. This driver supports versions 11i and 12c. Other versions may work, but that will be down to the compatibility of the Oracle JDBC driver.

This Snap Pack is tested against Oracle 11.2.0.4.0.


Panel
bgColor#ebf7e1
borderStylesolid

In this Section

Child pages (Children Display)
alltrue
depth2



Excerpt

Snap Pack History

Panel
borderStylenone


Expand
titleClick to view/expand

4.18 (snapsmrc523)

  • No updates made.

4.17 Patch db/oracle7459

  • Fixed an issue with the Oracle Stored Procedure Snap wherein the Pipeline execution fails with an error when the input data type is CLOB.

4.17 Patch ALL7402

  • Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17 (snapsmrc515)

  • Fixed an issue with the Oracle Execute Snap, wherein the Snap incorrectly sends data to the output if the Pass through field is enabled.
  • Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16 Patch MULTIPLE7123

  • Added two new properties, Number of retries and Retry interval, to Delete, Insert, Select, Execute, Merge, and Update Snaps that enables you to handle retry attempts during a connection failure.

4.16 Patch db/oracle6919

  • Added a new property, Session parameters, in the Oracle Insert Snap to enable the use of National Language Support (NLS) parameters.

4.16 Patch db/oracle6824

  • Fixed an issue with the Lookup Snap passing data simultaneously to output and error views when some values contained spaces at the end.

4.16 (snapsmrc508)

  • No updates made. Automatic rebuild with a platform release.

4.15 Patch db/oracle6534

  • Improved performance in Pipelines that contain child Pipelines.

4.15 Patch db/oracle6417

  • Fixed an issue with data types conversion. All fields with byte, short, int, or long data types will be converted to BigInteger after fetching.

4.15 Patch db/oracle6284

  • Replaced the existing Max idle time and Idle connection test period properties with Max life time and Idle Timeout properties respectively, in the Account configuration. The new properties fix the connection release issues that were occurring due to default/restricted DB Account settings.

4.15 (snapsmrc500)

  • No updates made. Automatic rebuild with a platform release.

4.14 (snapsmrc490)

  • No updates made. Automatic rebuild with a platform release.

4.13 Patch db/oracle5192

  • Fixed the Oracle Bulk Load Snap that stores special characters incorrectly in the target table.
  • Fixed the Oracle Bulk Load Snap that throws a NullPointerException error when the input letter case does not match with that of the Oracle table.

4.13 (snapsmrc486)

  • No updates made. Automatic rebuild with a platform release.

4.12 Patch oracle4862

  • Fixed an issue in the Oracle Bulk Load Snap that fails to execute the SQLLDR (SQL Loader) command, while also enhancing the support for the TCPS protocol.

4.12 Patch db/oracle4721

  • Added a property, "SSL/TCPS" for Oracle Account.

4.12 Patch MULTIPLE4744

  • Enabled expression for Delete Condition in Oracle Delete Snap. 

4.12 (snapsmrc480)

  • No updates made. Automatic rebuild with a platform release.

4.11 Patch db/oracle4369

  • Enhanced the Oracle Bulk Load Snap to accept date-type values in the format "yyyy-mm-dd".

4.11 (snapsmrc465)

  • No updates made. Automatic rebuild with a platform release.

4.10 Patch oracle3633

  • Fixed BULK LOAD so it adds the thread name to the name of the temporary directory. This allows multiple BULK LOAD Snaps within a single pipeline.

4.10 (snapsmrc414)

  • Added Auto commit property to the Select and Execute Snaps at the Snap level to support overriding of the Auto commit property at the Account level.

4.9.0 Patch oracle3188

  • Fixed the issue that "NaN" check was done to unexpected data types like varchar

4.9.0 Patch oracle3096

  • Fixed a class casting issue for custom data types(BLOB, CLOB, NCLOB, etc) when custom Oracle JDBC driver is used

4.9.0 Patch oracle3071

  • Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap

4.9.0 (snapsmrc405)

  • No updates made. Automatic rebuild with a platform release.

4.8.0 Patch oracle2905

  • Fix for SQL*Loader interpreting white-space only data as null values.

4.8.0 Patch oracle2756

  • Potential fix for JDBC deadlock issue.

4.8.0 Patch oracle2711

  • Fixed Oracle Snap Pack rendering dates that are one hour off from the date returned by database query for non-UTC Snaplexes.

4.8.0 (snapsmrc398, changed to oracle2905 on April 20, 2017)

  • Database accounts now invalidate connection pools if account properties are modified and login attempts fail.

4.7.0 Patch oracle2190

  • Fixed an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter.

4.7.0 (snapsmrc382)

  • Updated the Oracle - Stored Procedure Snap with the Pass through field. 
  • Resolved an issue in Oracle - Stored Procedure Snap that caused invalid column type failures.
  • Oracle - Bulk Load updated to handle dates the same way as Oracle - Insert. Acceptable format for timestamp strings:
    • Prior to 4.7, the only acceptable timestamp format was  "yyyy-mm-dd hh:mm:ss.SSS", such as 2016-11-07 10:55:12

    • It now also supports:

      • ISO8601 formats (plus fractional seconds) without timezone.

             "yyyy-mm-ddThh:mm:ss.SSS", (ex: 2016-11-07T10:55:12)
             "yyyymmddThhmmss.SSS", (ex: 20161107T105512)

      • ISO8601 formats with time zone. ONLY 'zulu' and 'UTC' at this time. Note that there is no space before the 'Z' but is a space before the 'UTC'.

             "yyyy-mm-ddThh:mm:ss.SSSZ"
             "yyyymmddThhmmss.SSSZ"

             "yyyy-mm-ddThh:mm:ss.SSS UTC"
             "yyyymmddThhmmss.SSS UTC"

             ex: 2016-11-07T10:55:12Z
             ex: 20161107T105512Z

             ex: 2016-11-07T10:55:12 UTC
             ex: 20161107T105512 UTC

        The ISO8601 format is used by many web services, Oracle Bulk Loader, and others.

4.6.0 Patch oracle1987

  • Resolved an issue with Oracle Stored Procedure Snap for an IN OUT NUMBER parameter taking an input value of null.

4.6.0 (snapsmrc362)

  • Resolved an issue in Oracle Select Snap that caused failures in the second output view when retrieving outputs from a table with a dot (.) character.
  • Enhanced the Oracle Select Snap to fully support SQL statements with/without expressions & SQL bind variables.
  • Extended support for Oracle Thin Dynamic accounts.

4.5.1 (oracle1583)

  • Updated the Bulk Load Snap with a new field, Use direct path load, to enhance bulk loading performance.
  • Resolved an issue with Oracle Select Snap failing if the table name included a dot (.) character.

4.5 (snapsmrc344)

  • Resolved an issue in Oracle Insert Snap to ensure that a string value, when inserted in a date column, is not converted to Null in Oracle database.
  • Resolved an issue in Oracle Stored Procedure Snap that occurred while loading stored procedure name field's suggestions.

4.4.1

  • Oracle Select: Resolved an issue with database access error occurring while iterating over table name result set when using an uploaded driver with a different version than the bundled driver.
  • Resolved an issue with Oracle Stored Procedure Snap not accepting CLOB data.
  • Made improvements to JDBC auto-commit consistency.

4.3.2

  • Resolved an issue with Oracle Select not reading table names: Database access error occurred while iterating over table name result set.
  • Resolved an issue with Oracle Bulk load failure: String index out of range: -1.

4.3.1

  • Resolved a database access error occurring while iterating over table name result set with the Oracle Select Snap.

4.3.0

  • Table List Snap: A new option, Compute table graph, now lets you determine whether or not to generate dependents data into the output.
  • Oracle Bulk Load
    • Resolved an issue with a pipeline never completing.
    • Resolved an issue with pipeline statistics, bulk load summary statistics not matching and bulk load summary was confusing.
    • Maximum error count field added to set the maximum number of rows which can fail before the bulk load operation is stopped.
    • Mixed-case matching option removed.
    • Added error messaging to handle BLOB type data trying to be loaded to an Oracle table when not supported.
    • Resolved an issue with the record separator of the input file not being processed correctly.
    • Improved error messages for when data types do not match.
  • Oracle Stored Procedure: All accessible objects are now visible during design.

4.2.2

  • NEW! Oracle Bulk Load Snap
  • Oracle Execute Snap: Columns now appear in the order of the select query.
  • Addressed a memory issue in Oracle Stored Procedure Snap.
  • Ignore empty result added to Execute and Select Snaps. The option will not write any document to the output view for select statements producing no results.

August 7, 2015 (2015.25/4.2.1)

  • Oracle connection errors now route to error view.
  • Output fields table property added to Select Snap.
  • Resolved an issue in Execute and Select Snaps where the output document was the same as the input document if the query produces no data. When there is no result from the SELECT query, the input document will be passed through to the output view as a value to the 'original' key. The new property Pass through with true default.

June 27, 2015 (2015.22)

  • Oracle Merge: SQL operation failed with an "IO Error: Connection reset, error code: 17002, SQL state: 08006 connection failure".
  • JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.

June 6, 2015 (2015.20)

  • Oracle Lookup failed in preview if DATE column was used for Lookup conditions
  • Dynamic DB queries now supported in the Execute Snap.
  • The SQL statement property now can be set as an expression property. When it is an expression, it will be evaluated with each input document and one SQL statement per each input document will be executed.
  • Known issue: When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
  • With the SQL statement property set as an expression, the Snap can be exposed to SQL injection. Please use this feature with caution.
  • Oracle Insert: When a string value is entered into a date col, its successfully inserting into db with null
  • Oracle Stored Procedure: parameter type list was not populating even if a procedure had custom types defined.

May 15, 2015

  • Oracle Execute error - no more documents will be written to SLFS
  • Oracle Execute Snap failing with maximum number of documents reached
  • Oracle Select Snap - Early dates are corrupted when reading data
  • Oracle select- with date data type does not return Time(hh:mm:ss)
  • Oracle Stored Procedure fails with error- Reason: invalid name pattern: TECTONIC.null
  • Oracle Stored Procedure - fails with - "invalid name pattern: TECTONIC.strarray32 " when type name given in lower case

May 2, 2015

  • Oracle: enhancements in dealing with DATE type fields
  • Oracle Lookup: Pass-though on no lookup match property added to allow you to pass the input document through to the output view when there is no lookup matching.

March 2015

  • Select: Resolved a null pointer exception and a failure with Suggest for Output fields and Lookup Column name properties with a synonym as a table name.
  • Stored Procedure: Resolved issues where downstream Snaps were unable to execute when connected to an Oracle Stored Procedure not using the OUT parameter.
  • Lookup: Resolved an issue with Output fields and Lookup Column name properties when a synonym was used as a table name.

January 2015

  • Oracle Account: The settings Acquire increment and Retry Attempts were removed.

December 20, 2014

  • Oracle Snap Pack: Lookup, Table list, Stored Procedure, Select Snaps added

October 18, 2014

  • The version number of the default Oracle JDBC driver (shared/ojdbc-6.1.jar) is now 11.2.0.4.
  • Fixed the following defects:
    • Oracle Stored Procedure: suggest method for parameter index throws -Suggestion value cannot be empty for property: customTypeParameterIndex
    • Oracle Stored Procedure: Parameter index suggest throws "invalid path" when no schema nor procedure is selected

    • Oracle Stored Procedure: If there is no type defined in Schema, suggest throwing Suggestion value cannot be empty for property: customTypeParameterType

    • Oracle Stored Procedure: When custom type created in different schema, its not populating through Snap
    • Oracle Select- Order by property as parameter fails
    • Oracle Stored Procedure: Parameter type list- Can we make it in an order
    • Oracle Snaps- When in account given a username which dont have privileges to access other schema, upon suggest all schema 's are populating
    • Oracle Stored Procedure: NPE
    • Oracle Stored Procedure: invalid name pattern: TECTONIC.STR_ARRAY_32_$
    • Oracle Stored Procedure: Procedure name mismatch error - suggest from parameter type when no package selected
    • Oracle Stored Procedure: When in a schema if there are no types defined, showing null in type and index value
    • Oracle Merge: error: "SQL operation failed"
    • Oracle merge condition when expression is enabled, input schema in not getting populated
    • Oracle Merge with expression more than 2 columns not working.getting Invalid identifier
    • Oracle Merge: When expression enable- Fails with Failure: Could not evaluate expression:
    • Oracle Stored Procedure: Failure: Failed to execute callable statement. Cause: invalid name pattern: TECTONIC.null

Fall 2014 September 20, 2014

  • Oracle - Stored Procedure: Support for suggesting schema/package and procedure names.

August 2014

  • Oracle Stored Procedure updated to support custom types.

June 30, 2014

  • Resolved the following issues:
    • Having a Constant value point to Lookup column name in Oracle Lookup Snap fails with error.
    • Oracle Select Snap - the value of the column data type 'timestamp with local time zone' should be read as Joda local date time

May 2014

  • NEW! Oracle Lookup Snap

November 2013

  • Oracle Snap Pack expanded with Stored Procedure

Initial Release (June 2013)

  • Initial release of this Snap Pack. Read/Write support for Oracle.





...