Qlik (Attunity) Compose and Replicate for DWH

[akime9]

Anyone here with some experience using Qlik/Attunity Compose and Replicate for building and maintaining a Data warehouse (on MS SQL)?

We are looking into these products for a data warehouse project that we want to built on MS SQL Server with tabular cube on top (mainly for reporting in Power BI). Have had a pilot with the products and they seem pretty good for this purpose. But it is impossible to judge in full how these will function and the ups and downs...

So wanted to hear if anyone in here is using them and what your experience is.

Thanks! 😉

[ciyovi9781]

Graphic illustrating the steps involved in agile data warehouse automation and how Qlik Compose supports the process 
www homedepot com survey

[sundar33w]

When the automation process runs, it runs perfectly fine and generates the Excel file, but occasionally I get a 502 Error from Add Row to Table process.

[SushilKumar]

Hello Team,

Thanks for reaching out to Qlik Community. The issue you put here require Some analysis, hence request you to raise a Support case along with below information. 

Please send the appropriate log from the below location

   a.Server logs: <product_dir>\data\logs\compose.log

   b.ETL task logs and workflow logs:

<product_dir>\data\projects\<project_name>\logs\etl_task\<task_name>\<instance_number>.log

<product_dir>\data\projects\<project_name>\logs\workflow\<workflow_name>\<instance_number>.log

1. c. Agent log:<Product_dir >\java\data\logs\compose_agent.log

Reagrds,

Sushil Kumar

[sureshkumar]

Hello,

Please refer the below article

Data warehouse project tutorial #Data warehouse project tutorial | Qlik Compose Help

Regards,

Suresh