Initiating a Load Plan via Incorta Public API v2
How to kick off a load plan via API. This is a great tool for triggering workflows from external tools!
How to kick off a load plan via API. This is a great tool for triggering workflows from external tools!
To ensure that the Incorta cluster is properly sized for the data being ingested from Oracle Cloud ERP (Fusion) we need to ascertain the source data size. There is no direct way to run ad hoc SQL queries on the Oracle Cloud ERP database, unlike tradi...
This article discusses how you can use Incorta's built-in integration with MLflow to manage your machine learning lifecycle.
Use boto3 to help you load AWS S3 files incrementally.
Learn how to ingest real time Kinesis data with PySpark.
Learn how to and why you would choose to ingest data from S3 with an MV
Introduction Managing incremental data loads efficiently is crucial for keeping your data warehouse up-to-date without putting unnecessary strain on your data sources. Incorta has traditionally relied on a query-based approach using either the LAST_...
Introduction As data volumes grow, especially with the proliferation of sensors and IoT devices or long-term usage of Incorta, it's essential to manage the amount of data stored on disk effectively. Increasing data size can lead to storage issues an...
Incremental data loads in Incorta insert new records and update existing ones, but they don't automatically delete records when they're removed from the source system (like Oracle Cloud ERP). Since source systems often allow data deletion, this can ...
SymptomsDiagnosisSolution1. Read Data into Spark2. Create JSON Schema3. Parse JSON and Create a Temporary Column4. Explode Nested JSON Array5. Save the Final DataFrame Download Symptoms JSON data are provided by the source system for sharing with ...
Learn about the implications of de-activating NULL handling for your analytics.
This article elaborates the steps to convert complex Oracle SQLS or views to Incorta.
Use the Incorta OTBI Lineage dashboard to determine the mapping between Oracle tables and VOs.