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)