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?
Details
Main Requirement – Get some data integrated to a SQL Server database on premises
SSIS 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)