Suggest an Idea

[zwatkinscovermymeds]

A majority of my task in Qlik Replicate consist of a PostgreSQL source replicating to a SQL Server target. If my PostgreSQL source has a boolean data type, replicate converts that to a varchar(5) and I am having to manually go into my target SQL Server databases and convert all the varchar(5) columns to bit. SQL Server then is able to do an implicit conversion when it receives a true/false from Qlik Replicate and convert the value to 1/0. I currently have ~80 task where I am having to do this manual conversion. 

My understanding is that PostgreSQL and SQL Server are mature endpoints for Qlik/Attunity, so I don't understand why I am having to do this manual conversion. Am I the only one with this issue? How has this not been solved already?

[Huey]

I agree.  This should be added.

[seanhawkes]

as a customer this looks very interesting and something I could make use of.  Please add

[karrasan]

I strongly agree and should be added

[Huey]

bump

[zwatkinscovermymeds]

This is still an issues. I would love to see this addressed in the next update 🙂 

[marina_marshak]

Thank you for all your feedback, this item is now on our roadmap.

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.