Features > ODS Pipeline

ODS Pipeline

Create Operational Data Store in Clicks.
Track the versions at record level.
Handle Delta process at Source or Target.
Acquire any Source Systems.

ODS Pipeline Architecture - Streamlined Data Processing and Integration

Core Features

Build ODS from any DB or Flat Files or APIs

Enterprise Acquisitions

Bulk or Incremental processing

Easy selection of attributes

Add Filters to the Source

Auto selection of Primary Key fields

Auto identification of Audit fields

ODS – Track Versions or No version

Delta logic at Source and Target

Run Stats report

Job History

Schedule ODS Pipeline

3 Simple Configurations

ODS Pipeline

  • Connect

    Configure Connections

    • Create Source – Database Connection (On-prem or Cloud) / provide the Flat File Storage location (On-prem or Cloud) / Enterprise Application connection
    • Create Target Database Connection

    01

    image-1
  • 02

    image-1

    Design

    Configure Attributes & Filters

    • Select the tables to be acquired
    • Pick the attributes from the tables (optional)
    • Pick the attributes that have to be filtered (optional)
    • Change the Primary Keys of table (optional)
    • Pick the Audit trial fields
  • Integrate

    Build CDC Pipeline

    • Link Source and Target connections
    • Execute the process
    • Schedule the process (optional)

    03

    image-1

3 Simple Configurations

1. Connect

Configure Connections
  • Create Source – Database Connection (On-prem or Cloud) / provide the Flat File Storage location (On-prem or Cloud) / Enterprise Application connection
  • Create Target Database Connection

2. Design

Configure Attributes & Filters
  • Select the tables to be acquired
  • Pick the attributes from the tables (optional)
  • Pick the attributes that have to be filtered (optional)
  • Change the Primary Keys of table (optional)
  • Pick the Audit trial fields

3. Integrate

Build CDC Pipeline
  • Link Source and Target connections
  • Execute the process
  • Schedule the process (optional)

Benefits

ROI

Shrink the project timeline and provide value to the business quickly

Enterprise Acquisitions

Build ODS from Enterprise applications like Salesforce

Ease of Use

Build ODS in few clicks

Source – Track with or without Versions

Easily Configurable option to track version or without version of Source

Build ODS Using ODS Pipeline - DataFinz

A tried and tested, time-saving solution – ODS Pipeline DataFinz is a No Code Data integration platform that provides an operational data store in just a few clicks, with no need for programming or complex low level configuration. We simplify the set up process by automating most of the steps, so all you have to do is click a few buttons! You’re done! This saves in lots of time spent on coding, provides great value to the business quickly

ODS Pipeline is easy to use, it’s scalable and it can build ODS from leading Enterprise applications like Salesforce, Postgres, Oracle, Snowflake. It also comes with a dashboard that lets you take control of your data.

It supports version tracking and scheduled job execution, as well as running job statistics.

How do I get started?

It’s easier than you think! All you need to do is sign up for a free trial and follow our simple set of instructions. After that, it’s just a matter of following the simple instructions and screencasts we provide.

Demo: 

Here is a demo of how easily is to integrate different enterprise applications – Postgres / Oracle / Salesforce to Snowflake Using DataFinz ODS Pipeline.