question

Haripr-0200 avatar image
0 Votes"
Haripr-0200 asked MartinJaffer-MSFT commented

Ingest data from Sqlite DB into Azure data explorer

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
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Haripr-0200 did my suggestion help you? If it solved your issue, please mark as accepted answer, otherwise let me know how I may better assist.

0 Votes 0 ·

@Haripr-0200 if you found your own solution, please share it here with the community.

0 Votes 0 ·

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered

Hello @Haripr-0200 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://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-sqlite-db-to-azure-sql-serverless-offline-tutorial
https://docs.microsoft.com/en-us/azure/data-explorer/data-factory-integration

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.