topic Re: Replication SQL D to Amozon Redshift in Qlik Replicate

Replication SQL D to Amozon Redshift

ajay1998 — Fri, 07 Feb 2020 12:18:16 GMT

Hi Team,

we have on-Prem SQL DB (whole Database ) need to Replicate to Redshift. Please let me know the step and is Attunity can replicate without any manual changed in DDL .

will automatically create table in Redshift ?

Thanks

Ajay Gupta

Re: Replication SQL D to Amozon Redshift

Madhavi_Konda — Fri, 07 Feb 2020 17:21:47 GMT

Hi Ajay,
Yes. You can use Attunity Replicate to replicate the data from SQL DB to Amazon Redshift.

You can achieve the following using Attunity Replicate:
Schema generation and data type mapping
Full load of source database tables
Incremental load of changes made to source tables
Application of DDL changes made to the source tables.
Synchronization between full load and CDC processes.
Manual control is also available if needed.

Thanks,
Madhavi

Re: Replication SQL D to Amozon Redshift

ajay1998 — Sat, 08 Feb 2020 16:20:05 GMT

Hi Madhavi,

Thanks for help.

need clarification on 2 point

Application of DDL changes made to the source tables. not getting , could please explain in details.

Schema generation and data type mapping---- this will generate automatically or need to do manual data type changes in mapping

Thanks

Ajay

9899059037

Re: Replication SQL D to Amozon Redshift

Madhavi_Konda — Mon, 10 Feb 2020 02:24:33 GMT

Hi Ajay,
Application of DDL changes made to the source tables->Any kind of ddls you do at source will be automatically applied to the target.

Schema generation and data type mapping->You don't need to do anything manual. These will be generated automatically. What I was trying to say was you can adjust the datatypes for the target manually. This option is available and you can ignore if you son't want it.

Thanks,
Madhavi