Oracle

Oracle offers a variety of enterprise software solutions, including ERP, CRM, and SCM software, and is particularly known for its database management systems.

Key Features of the Oracle Snap Pack

Use the Oracle Snap Pack to connect to your Oracle database and achieve read and write access to its objects. After you install this Snap, SnapLogic will analyze all the objects in your Oracle database and create metadata for them. Hence you will not need to perform any additional programming or configuration within Oracle.

The Snap Pack comes with building blocks that enable dozens of functions on your source data. Among the building blocks are readers and generators, such as the CSVRead, XMLRead, and DBRead functions. For every type of reader/generator, a writer building block is also included. Building blocks include operators, such as aggregate, database lookup, filter, join, merge sorter, splitter, and type converter. Also important to note:

  • Predefined building blocks are easy to extend for customization needs
  • Data access is controlled by the Oracle credentials
  • Implements the basic Oracle application security
  • Requires no additional configuration within Oracle after installation
  • No Web Services or additional programming required to access Oracle data after installation

The included library of building blocks can be categorized by function, as follows:

  • Readers and Generators
    • Atom RSS Read
    • CsvRead
    • DateDimension
    • DBRead
    • FixedWidthRead
    • HtmlRead
    • RssRead
    • XmlRead
  • Writers
    • Atom RSS Write
    • CsvWrite
    • DBWrite
    • FixedWidthWrite
    • Http Put/Post
    • RssWrite
    • XmlWrite
  • Operators
    • Aggregate
    • Compute
    • Constants
    • Date Operations
    • DB Lookup
    • Filter
    • Format Fields
    • Html Formatter
    • Join
    • Join – Outer Join
    • Math Operations
    • Merge Sorter
    • Mixer
    • Regex
    • Sequence
    • Sort
    • Splitter
    • String Operations
    • Type Converter
  • Special Purpose
    • DB Table Wizard
    • Execute Resource

Learn more about how Snaps work with the SnapLogic Enterprise Integration Cloud here.

Looking for more integrations?

Back to Snaps

Related Snaps

Quickly connect apps, data, and devices

Start Free Trial
Contact Us Free Trial