-
Get data in MS SQL from Omnis 11 multiple database
Good day to all.
Curent set-up-> Windows 10, Multi-users AVD in Azure, where users connect to use “their” office Omnis Library, so all Omnis *.DF* are located in separate directories on that computer.
My “technical” profile-> Microsoft Network/System/Azure administrator with some MSSQL knowledge, tasked to prepare, test, then documents the steps and passed the formula to the SQL DBA’s afterward 😄
I need to look into getting the information (just read really) inside the Omnis DBs into Microsoft SQL so that it can be “massaged” and added to other application that are MSSQL based.
I understand that there is ODBC connectivity possible, but my dilemma is the direction of ODBC, i.e. should it be the MSSQL contacting the *.DF*, or “special” LDB pushing” the information?
Is there any other consideration that will be needed (allowed ports between MSSQL and the location of the Omnis DBs?
Thank you all in advance for any help, tips, trick, web links you may provide me with.
Serge Ayotte
-
3 Replies
-
Hi Serge,
Only the Omnis application can write into the Omnis datafile. So you would need to write a little Omnis app that reads data from the MS SQL Server and writes it back to the Omnis datafile.
Best,
Andreas
-
Serge,
re-reading your post. You might be able to read from an Omnis datafile via ODBC. However tables inside the Omnis datafile must be accessible. So the Omnis developer would need to give access.
Best,
Andreas
-
Thank you Andreas for your reply, but as you mention indeed, I want to READ the Omnis DB, not write in them 😁
I have admin account that should have access to all tables, but just unsure how to connect TO the DB’s of Omnis
Serge
-
-
Log in to reply.
