CODEWITHSUNDEEP
sql-server-2008postgresql
kinkajou
kinkajou

Reputation: 3728

Creating database link in posgresSQL to connect to SQL Server 2008

Are there any way to connect PostgreSQL to SQL Server? I found this link http://pgfoundry.org/projects/dblink-tds/ but are there other ways?

Upvotes: 5

Views: 12178

Answers (3)

kinkajou
kinkajou

Reputation: 3728

I would best suggest to design ETL process in Pentaho or Talend and separate data integration and data storage layer. It's easier to manage then making db link.

Upvotes: 1

user330315
user330315

Reputation:

You could try a foreign data wrapper.

There is one for accessing Microsoft SQL Server and an ODBC based one.

http://wiki.postgresql.org/wiki/Foreign_data_wrappers

I have not used them, so I have no idea how good they are.

Upvotes: 2

Edmund
Edmund

Reputation: 10819

You might be able to do something using one of PostgreSQL's server languages, e.g. pl/pythonu. For any given query you could write a function in that language which fetches the results from the remote server, using the language's own DB access modules. So in pl/pythonu you would use a Python DB-API module for SQL Server access.

Upvotes: 2

Related Questions