Does anyone have experience connecting DataServices to a PostgreSQL database?

[richard_west]

I'm researching to possibility of moving some, if not all, of our databases from SQL Server to PostgreSQL.

Does Data Services support connecting to PostgreSQL? I assume this would need to be done through an ODBC connection since it does not appear that Data Services has a native Postgres connection type.

Would going through an ODBC connection have a negative impact on performance? Any other feedback or advice would be welcomed.

Thanks,

Richard

[former_member187605 · Accepted solution]

Your only option would be connrecting with the PostgreSQL ODBC driver indeed . There's no native interface from DS to PostgreSQL. And you'll have to live with  the poor ODBC performance, too.

[former_member182007]

Rich - Per my understanding there is no PostgreSQL & BODS connection
available as of now.

Best !

Deep