Bringing Postgers tables to HANA

[Former Member]

HI All

   We are trying to bring Postgres data to HANA , we are looking for several ways to do it, intially  we thouhgt of using BODS, but BODS does not seem to support postgres database , Request your ideas .

Thanks

Santosh Varada

[lucas_oliveira]

Hi Santosh,

I guess you could also use Data Services to extract/transform/load tables from postgres into HANA.

Regards,

Lucas

[rama_shankar3]

Is postgres DB ODBC or JDBC complaint? if so, you should be able to use BODS. If not, flat file export and import to HANA is your alternate options.

[Former Member]

Hi,

You could look at using ODBC, more on that here;

http://scn.sap.com/thread/1714880

Another option would be to export flat files out and import the flat files.