We have a question regarding an SSIS connection to IFS. I am using Visual Studio 2019 - Community Edition and have established a connection to IFS using Microsoft's Oracle connector to pull some data via an SSIS package.We have IALs in IFS that are considered views and have access to them with a "read-only" user account given to us. I can see and access them in PL/SQL Developer, but I can only access tables in Visual Studio SISS package, I can't access the IAL views.Is there some type of limitation with the Oracle Connector? DetailsMain Requirement – Get some data integrated to a SQL Server database on premisesSSIS requirements and BI tools are installed.User Account – IFSINFO VS Studio Version – Can connect to the database using IFSINFO user but can’t execute a SQL query. Only some of the views are shown and none of the IAL views are shown. Question – how to make the IAL views accessible in VS? (They are accessible for the same user in PLSQL Developer)
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.