March 27, 2022 at 11:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 28, 2022 at 7:11 pm
Help me to better understand your question. What is the external database? That will dictate what driver you may use.
March 28, 2022 at 9:16 pm
Thanks for the response. The odbc source is an intersystems cache database
Since there's no ODBC driver support available in Azure (to my knowledge), you cannot directly import from the Intersystems database.
This is best solved from the source side. Write an app local to the Intersystems database, write the required tables to the Azure SQL database directly into a staging area, then in Azure SQL perform a merge operation from the staged tables to the target tables.
Another way to solve this if the database is not too large is read the Azure tables to a staging area in Intersystems, delete records in staging that are missing from Intersystems, then push the staging tables back to the Azure SQL.
March 29, 2022 at 11:16 pm
@reluctantphilosopher thanks for the answer. I'll try to implement solution on the source side
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply