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(at)thomas-guettler(dot)de <mailto:guettliml(at)thomas-guettler(dot)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