Support/certification question on SSIS 2019 and Oracle connector

Question

Based on Microsoft doc (oracle-connector), it looks like the connector for 2019 is compatible with Oracle DB versions 10-19c.

However, when looking at the connector needed for use with SQL server 2016, it states 10, 11 and 12c versions.

Can anyone clarify that the Oracle connector used with SQL server 2019 integration services is supported with both 12c and 19c?

Thanks in advance!

Answer 1

Hi @SarahC ,

Welcome to Microsoft Q&A!

According the document, it's supported. But there has a limitation that views are not listed under Oracle source Name of the table or the view. As work-around, use the SQL command and do a select * from view, or set view name to property [Oracle Source].[TableName] in Advanced Editor. Please refer to Microsoft Connector for Oracle is released for SQL Server 2019 Preview to get more information. By the way, does there have any errors when you make a connection?

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @SarahC ,

First of all, the SSIS Microsoft Connector for Oracle requires SSIS 2019.

Supported Oracle versions:

• Oracle 10.x
• Oracle 11.x
• Oracle 12c
• Oracle 18c (without Windows Authentication support)
• Oracle 19c (without Windows Authentication support)

It is documented here: oracle-connector Oracle versions support

Oracle client is not required for Microsoft Connector for Oracle database in SQL Server 2019.