Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.

Selecting Views inside a Replicate task

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Shai_E
Support
Support

Selecting Views inside a Replicate task

Last Update:

Mar 1, 2022 4:53:21 AM

Updated By:

Shai_E

Created date:

Mar 1, 2022 4:53:21 AM

I see the following question pop up from time to time:

"Why can i not select views in my Replicate task?"

There can be two reason as to why you are not seeing view selection in "table selection" inside of a Replicate task:

  1. The source endpoint does not support views.
    Here is a list of endpoints that support view selection:

    Teradata (with an exception, see second point)
    Amazon Redshift (with an exception, see second point)
    PostgreSQL
    MySQL
    SAP Sybase ASE
    IBM DB2 for LUW
    IBM DB2 for z/OS
    Oracle
    Microsoft SQL Server
    ODBC with CDC (with an exception, see second point)
    ODBC

  2. Task is no selected for Full load only mode, Replication of views is supported in Full Load Only tasks, except when replicating from the following sources:

    Amazon Redshift
    Teradata
    ODBC with CDC
Contributors
Version history
Last update:
‎2022-03-01 04:53 AM
Updated by: