Data & Schemas Knowledgebase
A solid data foundation leads to analytics. Build that foundation here.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Move Data from Dev/Test to Prod

Introduction It is a best practice to test configuration in the development/test environment(s) before moving it to production.  In some cases, production data is loaded into the Dev/Test environments for validation purposes as well.  This article di...

migrate.jpg

Create an ODBC Connection to Incorta

Applies to: Any Incorta version On-Prem/Cloud Question: How to configure an ODBC connection?Unable to connect to Incorta using ODBC Overview: Any program that uses Open Database Connectivity (ODBC) to connect to a remote database needs a way to iden...

Noureldin_0-1658354132173.png Noureldin_1-1658354159123.png Noureldin_2-1658354181612.png Noureldin_3-1658354215841.png

Multi-Source Table Design

Struggling to wrangle data from multiple sources? Learn about how and when to combine similar data points from disparate sources with three different approaches using the Incorta Platform.

Screen Shot 2022-08-16 at 8.12.06 PM.png Screen Shot 2022-08-16 at 8.13.11 PM.png Screen Shot 2022-08-16 at 9.04.54 PM.png Dashboard.gif
LukeG by Employee
  • 519 Views
  • 0 comments
  • 2 kudos

Variables

Read this article to review variable types in Incorta, when you use them, and best practices around using variables.

variables.jpg
VinayR by Employee Alumni
  • 239 Views
  • 0 comments
  • 0 kudos

ML with IRIS data set using Incorta

This article shows how to use a classification Machine Learning (ML) algorithm on the Iris Flower data set. It first creates a model based on a training data set and then scores the the test data set and gives the prediction of the flower based on th...

amit_kothari_0-1648226442596.png

Handling Deletes

There are a number of strategies that can be implemented depending on the size of your data and whether the deleted records can be easily identified.

delete.jpg
dylanwan by Employee
  • 394 Views
  • 0 comments
  • 0 kudos

Connecting to Data

Introduction Incorta has a wide variety of external data source connectors. A connector specifies how Incorta can connect to an external system or application , ingest data and publish to destinations.  Incorta includes many out-of-the-box connector...

Screen Shot 2022-03-03 at 3.17.26 PM.png
RichC by Employee
  • 294 Views
  • 0 comments
  • 1 kudos

Data Load Strategy

Introduction This article discusses the procedures and best practices for Data Load Strategy. What you should know before reading this article We recommend that you be familiar with these Incorta concepts before exploring this topic further.  Importi...

Screen Shot 2022-03-03 at 3.22.21 PM.png
RichC by Employee
  • 695 Views
  • 0 comments
  • 0 kudos

Snapshotting Data

Introduction If you need to create point in time reporting in Incorta, you may need to implement a snapshotting strategy.  Often the source application itself will track changes to its data and thus you can get a full historical view of changes to d...

snapshot.jpg
Tristan by Employee
  • 392 Views
  • 0 comments
  • 1 kudos

Near Real Time Reporting

Introduction Incorta is not a real-time data platform, however given its unique approach that allows customers to leave data “in-shape”, paired with its speed when it comes to extracting and preparing data, it can support very frequent data refreshe...

spark.jpg
Tristan by Employee
  • 333 Views
  • 0 comments
  • 0 kudos
Best Practices Index
Best Practices

Just here to browse knowledge? This might help!