Data Integration

Data Sourcing, Integration, Preprocessing, Scheduling

Integration to source systems, API calls, scheduling, and data models

Introduction

The Intellifold platform provides the following functionality to source data:

(1) Direct load from database (Postgres, MS SQL, Oracle SQL)
(2) Retrieve data from a data warehouse such as Snowflake or RedShift
(3) Use existing application APIs to perform scheduled loads
(4) Dedicated application extraction programs or Python scripts
(5) Manual load of CSV or text files to be stored in the database

Data Connectors

The Data Integration module offers different methods for sourcing data from source applications, databases or data warehouses. Data connectors are available for common ERP and CRM systems and custom scripting or available application APIs can also be leveraged.

Data Integration

With a data connection established data can be sourced and configured for use by the data model.

Data Model

The Data Model is what gets loaded into the Solution. This may contain a range of different tables that are joined together.

(1) Activity or Event table: contains the events with time stamps for the relevant process activities.
(2) Cases table: contains the aspect tracked. This can be an order, invoice, claim, student, patient, customer, incident, complaint, product, etc.
(3) KPI tables: contains additional data from analysis performed in the database. This is optional as many analyses can be performed directly in the solution.
(4) Other tables: further information such as user details, reference information, or additional data related to the KPIs.

Data Scheduling

Data loads and pre-processing of data queries can be scheduled. While some data might be refreshed overnight, there might be KPIs that only need to be executed on a weekly on monthly bases. The functionality provides a range of functionality to automate data sourcing, processing, and data model load.

Sign up for a free trial!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form. Please complete fields and try again...