Is it possible to create an ODBC connection to IFS Application from within Excel?
Solved
ODBC Connection
+8Best answer by Voshitha
Yes, You could use Get Data option in Data tab in Excel ribbon. Then select Get Data From Oracle.
But for this you need to have vpn connection to the database server as well as necessary database privileges and knowledge about entities in relational database system.
Also note that from IFS Cloud release onwards IFS Database could not directly accessible from outside systems.
Therefore I wouldn’t recommend directly connecting to oracle in order to retrieve data.
Best regards,
Voshitha
This topic has been closed for replies.
Yes, You could use Get Data option in Data tab in Excel ribbon. Then select Get Data From Oracle.
But for this you need to have vpn connection to the database server as well as necessary database privileges and knowledge about entities in relational database system.
Also note that from IFS Cloud release onwards IFS Database could not directly accessible from outside systems.
Therefore I wouldn’t recommend directly connecting to oracle in order to retrieve data.
Best regards,
Voshitha
+8Yes, You could use Get Data option in Data tab in Excel ribbon. Then select Get Data From Oracle.
But for this you need to have vpn connection to the database server as well as necessary database privileges and knowledge about entities in relational database system.
Also note that from IFS Cloud release onwards IFS Database could not directly accessible from outside systems.
Therefore I wouldn’t recommend directly connecting to oracle in order to retrieve data.
Best regards,
Voshitha
Thanks a lot Voshitha
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.