Product documentation to get the most out of your solution.
The Intellifold platform provides the following functionality to source data:
(1) direct upload 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 performed scheduled loads
(4) data integrations using application programs or Python scripts
(5) manual load of CSV or text files which will be stored in the database
The Data Integration module offers different methods for sourcing data from source applications, databases or data warehouses. Common connectors are available and custom scripting or available application APIs can also be leveraged.
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 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.
