Mapping SQL Server View as source for replicate server

[JAfonso]

Hello,

when I try to select Tables/views in a task from an Sql server source I only see tables and can´t see a view that was created.

Can anyone advise?

[Dineshan · Accepted solution]

Hello @JAfonso,

You will see views only on full load task. You will see the option to select views when you choose table selection.

Thank you,

Dinesh

[SwathiPulagam · Accepted solution]

Hi @JAfonso ,

Turn on just the Full Load option, then click on Table selection, and you should be able to see the views.

Thanks,

Swathi

[JAfonso]

Hi guys. thank you for the fast answers.

My issue is the following we have a huge table with Change Processing working on it.

We had the need to do a full load but it is taking forever since it dies frequently dur to timeouts.

My idea was to create a view only with the records of the source table from 2023 (the older ones are not subject to change) and do a full load. After that I would reset the source back to the big table and Change processing would take over 

For the older records I would simply do insert to target  select from source.

Can this work?

Thanks.

[SwathiPulagam]

Hi @JAfonso ,

Using Passthru filter option you can load 2023 data and this option is available during Full Load. Once the Full Load is completed you can enable CDC to process.

Below is the link for your reference:

https://community.qlik.com/t5/Official-Support-Articles/Filter-for-last-90-days-of-data-in-Qlik-Repl...

Thanks,

Swathi

[JAfonso]

Hi @SwathiPulagam , thank you for the advise. I am giving it another try  as is and if it fails again I will do as advised. Thanks and regards

[SwathiPulagam]

Sure @JAfonso .

Please keep us posted with your results.

Thanks,

Swathi

[JAfonso]

I dont have passthrough enabled. If I enable it all other tasks and tables will work fine as before?

[Dana_Baldwin]

Hi @JAfonso 

Yes, that is correct - it only affects tasks that have a pass through filter defined.

Thanks,

Dana

[SwathiPulagam]

@JAfonso  Passthrough filter will be enabled on the server level and if you want to use that specific filter then you can use it in a specific task\table. Not all other tasks\tables that are not going to use this filter not affected.

Thanks,

Swathi