topic Re: Create Primary Key on target SQL server in Qlik Replicate

Create Primary Key on target SQL server

amitw — Sun, 28 Jul 2024 17:21:10 GMT

Hi ,

We have developed a full + CDC replicate task with SAP ODP endpoint as source and SQL server as target.

We want the keys defined on the CDS views on Replicate task to be defined as primary keys on the target tables on SQL server.

Currently the keys defined on replicate tasks are coming as NOT NULL on target SQL server .

is there any feature that will allow replicate to define primary keys on the SQL server target?

Thanks,

Amit

Re: Create Primary Key on target SQL server

john_wang — Mon, 29 Jul 2024 01:15:35 GMT

Hello @amitw ,

I guess I did not understand the doubt accurately. By default Qlik Replicate creates Primary Key with NOT NULL constraints in SQL Server target tables. For example:

CREATE TABLE [SCOTT].[KIT](
[ID] [numeric](10, 0) NOT NULL,
[NAME] [varchar](20) NULL,
CONSTRAINT [KIT_KIT_KIT_PK] PRIMARY KEY CLUSTERED
(
[ID] ASC
));

Where "ID" is the Primary Key in source side table. The above table was created by Qlik Replicate in SQL Server target database.

Would you please elaborate the question.

Thanks,

John.

Re: Create Primary Key on target SQL server

amitw — Mon, 29 Jul 2024 03:44:07 GMT

hello @john_wang ,

In our case , Replicate did not create the primary key constraint in the target database ( SQL server ).

It created the SQL server table with key column defined as NOT NULL.

The source is S4 HANA ( SAP ODP endpoint).

Thanks,

Amit

Re: Create Primary Key on target SQL server

SachinB — Mon, 29 Jul 2024 06:02:24 GMT

Hello @amitw ,

Could you please check in advance endpoint settings what you have selected under 'ABAP Core Data Services (CDS) views? : ABAP Core Data Services (CDS) views

We would also request please create a support case to check this further.

Regards,

Sachin B