Ingest data from Sqlite DB into Azure data explorer

Hari_pr 1 Reputation point
2021-04-19T13:45:07.747+00:00

What is the recommended way to ingest data from sqlite db into Azure data explorer.

If this is not straight forward, are there other alternatives like a Postgre SQL on Azure or SQL server on Azure which might be easier to do.

The objective is to set up a recurring ingestion process into Azure data explorer cluster from a database

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
502 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MartinJaffer-MSFT 26,051 Reputation points
    2021-04-19T22:32:16.33+00:00

    Hello @Hari_pr and welcome to Microsoft Q&A.

    I found some docs / tutorials relevant to your case. By combining the two below, I believe you can move SQLite -> Data Factory -> Data Explorer . Or to whichever you prefer.

    https://video2.skills-academy.com/en-us/azure/azure-sql/database/migrate-sqlite-db-to-azure-sql-serverless-offline-tutorial
    https://video2.skills-academy.com/en-us/azure/data-explorer/data-factory-integration

    0 comments No comments