Qlik Replicate and Oracle Invisible Columns

[shashi_holla]

Oracle has introduced new type of column type called Invisible columns starting Database version 12. These columns are hidden when we do select * from the table but can be queried by specifically using the name. This article is to provide more details on how Qlik Replicate handle these columns.

Environment

• Qlik Replicate 

Qlik Replicate has introduced a setup in the Advanced tab of the Oracle source endpoint point connection "Support invisible columns". If we are working on Oracle invisible columns, we have to check this option. This is also documented in the user guide:

Setting advanced connection properties using Oracle LogMiner

If we have invisible columns in source Oracle and don't enable the option then we end up with a issue where Replicate tries to drop and recreate these columns every time we do a Full Load or whenever we work on the DDL for these columns.

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.