Real-Time extraction from PostgreSQL to BW 7.50 powered by HANA

[andreas-s]

Hi

is there a way for a real-time / near real-time extraction from PostgreSQL to BW 7.50 powered by HANA?

Data Services and UD Connect, which we could use, do not support RDA in case of Postgres.

Is Webservice an option? What else could be a solution, is SLT an option? SDI/SDA is difficult due to licence costs...

Thanks

Andreas

[DebjitSingha]

Hello as_76,

Here are my explanations-

is there a way for a real-time / near real-time extraction from PostgreSQL to BW 7.50 powered by HANA?Only option is SDI.

Data Services and UD Connect, which we could use, do not support RDA in case of Postgres. Correct UD connect is for ETL purpose only.

Is Webservice an option? Its an option for ETL again.

What else could be a solution, is SLT an option? SLT uses the database connect functionality of the underlying SAP NetWeaver ABAP server. Only supported on below mentioned non-SAP DB's-

• SAP HANA (SAP HANA 1 SP 03 and higher / SAP HANA 2 any version)
• SAP MaxDB
• SAP ASE (Sybase)
• DB2 for z/OS (DB2)
• DB2 for iSeries (DB4)
• DB2 for Linux, UNIX and Windows / DB2 UDB (DB6)
• Microsoft SQL Server
• Oracle

1605140 - SAP Landscape Transformation Replication Server (SLT)

SDI/SDA is difficult due to license costs... Yes, they comes with license cost, unless they are already included with your existing HANA license agreement.

Hope this helps. Let us know if you have any query around this topic.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

Debjit