topic Re: Different file group for SQL SERVER target tables in Qlik Replicate

Different file group for SQL SERVER target tables

amitw — Tue, 23 Jul 2024 05:58:29 GMT

Hi,

We have developed a Full + CDC task with SAP ODP endpoint as source and SQL SERVER as target.

We have requirement where we need to create the SQL SERVER target tables into a different file group than the default one QLIK Replicate is currently creating in.

I see there is an option for creating replicate internal tables in different file group in advanced settings on the endpoint.

Is there any internal parameters or workaround to create the data tables in different file group as well?

Thanks,

Amit

Re: Different file group for SQL SERVER target tables

SachinB — Tue, 23 Jul 2024 11:20:52 GMT

Hello @amitw ,

Thanks for contacting Qlik Community forum.

Filegroup for Replicate internal tables : This option is available only for internal Control Tables will be created in the specified filegroup.

I don't see how this can currently be done in Replicate, ie how to control that the tables created will be written to a specific filegroup on the target.

To do this you would need to alter the create table statement that replicate runs and add the ON keyword + the filegroups name to it.

1. Provider syntax in the advanced setting -> internal parameters for the target endpoint, is a json file that holds the internal sql statements that replicate uses with each endpoint based on its type, if you can change the create statement table there and add the file group to it you might be able to pull this off.

But the thing about this option is that i wouldn't advise this, why?

a. It can mess up the replicate server if you don't edit the file correctly or do a mistake.
b. This change will be saved for all tasks using this endpoint

But other than these assumptions, i don't really think there is currently an option to control to which filegroup on the target database does the table go to.

For feature requests:

https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

My advice would be to post an idea for this

Regards,

Sachin B

Re: Different file group for SQL SERVER target tables

Dana_Baldwin — Tue, 23 Jul 2024 17:20:50 GMT

Hi @amitw

As noted above, there currently isn't a way to do that from within Qlik Replicate. You would need to manually create the tables on the target before running the task, and change the task settings to either "do nothing" or "truncate target tables" for your full load settings (from the default of "drop and create target tables).

Thanks,

Dana

Re: Different file group for SQL SERVER target tables

amitw — Wed, 24 Jul 2024 09:54:35 GMT

Thanks @SachinB @Dana_Baldwin for your prompt response!