Re: Replicate Tables from SAP (DB2/HANA) to PostgreSQL

Am 20.09.2018 um 04:19 schrieb bricklen:
> 
> 
> On Tue, Sep 18, 2018 at 11:31 PM Thomas Güttler <guettliml@thomas-guettler.de <mailto:guettliml@thomas-guettler.de>>
wrote:
> 
>     Hi,
> 
>     is it possible to replicate some tables from SAP to PostgreSQL?
>     At the moment there are two underlaying database systems.
>     Some run DB2 and some run SAP-HANA.
>     In my case it would be nice, if it would be possible to replicate
>     only some rows, not all.
> 
>     The replication should be unidirectional. The data in PostgreSQL
>     is only needed for reading, not for inserts/updates.
> 
> 
> My team is about to start a proof-of-concept doing the same thing, except it's a large MSSQL to PG11 replication 
> process. The tool we are evaluating is from https://www.hvr-software.com/solutions/database-replication/, and the
demos
 
> looked pretty good (at least, for our use-case). You didn't mention if you're looking for free or paid software; HVR
is
 
> not free so that may or may not fit your needs.

if it is commercial, then it depends on the price. I like open source software. But my goal is to make the customer 
happy, not me :-)

Regards,
   Thomas Güttler


-- 
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines