To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task.ĭuring CDC, NCLOB data types are supported only in tables that include a primary key. Before we begin, we need a SQL Server instance running on RDS first: Download the Microsoft JDBC driver as we need that to connect to the server.
LOB columns for Amazon RDS for SQL Server tables are updated in the target even for UPDATE statements that did not change the value of the LOB column in Amazon RDS for SQL Server.ĭuring CDC, CLOB data types are supported only in tables that include a primary key.įor more information, see LOB support in Task Settings/ Metadata. To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task.
Next, you have to add a dataset to the data source. You should now see the data source listed in the Report Data folder. SQL server and Qlik Replicate data types Amazon RDS for SQL server data types Data Initial CatalogAdventureWorks After filling the connection string, click on the 'Credentials' tab, and then select the Windows authentication method: Click 'OK'.