Azure Function using Python to move data from SFDC to SMI

Question

All,

I am looking for an alternative to ADF for moving data from SFDC to SQL MI. Preferably using Az Functions using python and some kind of framework around it to track the data loads. Can someone please point me to the resources which can guide me along the path. Source - SFDC ; Target - SQL Managed Instance. Thank you!

Answer 1

Please clarify what SFDC is

and remember that each shortcut with 3-4 char might have 10 or more different uses

according to google SFDC can be SalesForceDotCom, which is a cloud-based customer relationship management (CRM) software.

If this what you mean then what we need to know is what the type of database or database server this app use as your request is not related to the app but to the data in the database

---

UPDATE

According to this site, it seems like the database which is used by SFDC is Oracle

https://www.quora.com/What-database-does-Salesforce-use

Therefore, your basic question is about migrating data from Oracle to Azure SQL Database using Azure Function using Python

Not something that I will try to do as there are much better solution to migrate the data but a simple solution: (1) connect your Oracle database from the Azure Function using Python and Read the data using queries from the Oracle and (3) then sue the Azure function to write the data to the Azure SQL.

These can help for each step:

1. https://learn.microsoft.com/azure/azure-functions/create-first-function-vs-code-python?pivots=python-mode-configuration&WT.mc_id=DP-MVP-5001699
2. https://databasefaqs.com/fetch-data-from-oracle-database-in-python/
3. https://learn.microsoft.com/sql/machine-learning/data-exploration/python-dataframe-sql-server?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699