Is their any feasibility to load the data fromm on premise Maria DB via SSL-based authentication to Azure Cloud, without using SHIR or Vnet

Question

Is their any feasibility to load the data fromm on premise Maria DB via SSL-based authentication to Azure Cloud, without using SHIR or Vnet

Answer 1

Hello Kiran Kumar Maddipati,

I understood that you want to load data from On-premise Maria DB to Azure Cloud without using a Virtual network or any additional network cloud resource (Can you clarify that SHIR term).

You have two options based where you initiate the communication:

• Initiating from the cloud: Here it's required that your on-premise MariaDB instance is accessible over the internet (It's risky because you will publish the port on internet I suggest in this only on time windows and extra security controls such whitelist). After that you can enable SSL connection and use an Azure services (such as Azure Database Migration Service, Azure Data Factory, Azure Logic Apps, or Azure Functions) to connect to your MariaDB instance over SSL and transfer the data. https://learn.microsoft.com/en-us/azure/data-factory/connector-mariadb https://stackoverflow.com/questions/49260440/azure-functions-get-data-from-api-and-post-it-in-a-sql-database https://techcommunity.microsoft.com/t5/azure-database-for-mysql-blog/migrating-from-azure-database-for-mariadb-to-azure-database-for/ba-p/3838455
• Initiating from On-Premise: Here It's required to write custom ETL (Extract, Transform, Load) scripts using languages like Python, Java, or any other language that supports MariaDB and Azure SDKs. You will need to use Azure SDKs or REST APIs to load data into Azure services such as Azure SQL Database, Azure Blob Storage, or Azure Data Lake https://github.com/microsoft/sql-server-samples/tree/master/samples/features/sql-bulk-load

If this information help you to address your question, please Accept the answer.

Luis