topic Re: Datamigration from on premise EDB PostgresSQL to AWS Dynamo DB in Qlik Replicate

Datamigration from on premise EDB PostgresSQL to AWS Dynamo DB

zparveen — Mon, 31 Oct 2022 14:52:20 GMT

Hi,

We are planning to migrate our On premise EDB postgresSQL database to AWS Dynamo DB. For that I was looking into Qlik, but not sure is this tool is the right fit for our POC or not.

Maybe I'm not able to find the right document that will help me with my POC. Could you please help, if Qlik supports that functionality.

Thanks,

Zareena

Re: Datamigration from on premise EDB PostgresSQL to AWS Dynamo DB

SwathiPulagam — Mon, 31 Oct 2022 16:04:37 GMT

Hi @zparveen ,

Replicate won't support the Dynamo DB. You can submit your Feature requests or ideas in this forum:

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

Thanks,

Swathi

Re: Datamigration from on premise EDB PostgresSQL to AWS Dynamo DB

john_wang — Tue, 01 Nov 2022 00:16:31 GMT

Hello @zparveen ,

As @SwathiPulagam comment, Replicate does not support the Dynamo DB directly in current release. there are 2 alternative:

1. Uses 3rd party ODBC/JDBC Drivers and Connectors to DynamoDB (it's not free)

2. Utilize Kafka as bridge between Replicate and Dynamo DB, the flow looks like: PostgreSQL --> Replicate --> Kafka --> Dynamo DB.

Hope this helps.

Regards,

John.

Re: Datamigration from on premise EDB PostgresSQL to AWS Dynamo DB

zparveen — Tue, 01 Nov 2022 16:04:20 GMT

Thanks a lot @john_wang and @SwathiPulagam for the quick response and providing me the alternative ideas.

Re: Datamigration from on premise EDB PostgresSQL to AWS Dynamo DB

zparveen — Tue, 01 Nov 2022 16:15:59 GMT

@john_wang Do you have any documentation or POC that I can refer to?

Re: Datamigration from on premise EDB PostgresSQL to AWS Dynamo DB

john_wang — Wed, 02 Nov 2022 03:55:31 GMT

Hello @zparveen ,

Please reach out to your region sales representative or pre-sales team for help, I'm afraid I have not such a documentation in hands.

Regards,
John.