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?
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.
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).
