• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 721
  • Last Modified:

Linked server functionality in MySQL or PostgreSQL?

Does MySQL and/or PostgreSQL have the concept of Linked Servers like MSSQL ?
I need to make an odbc connection from a MySQL (or PostgreSQL) database to a NetSuite database and I'd love to be able to do it as a linked server like MSSQL.  
(NetSuite has an ODBC driver available).
Otherwise I assume I will have to write some code to sit between the NetSuite database and the MySQL/PostgreSQL database?

Thanks, Kevin.
0
kevinvw1
Asked:
kevinvw1
  • 2
3 Solutions
 
RiteshShahCommented:
If you have SQL Server than you can make two linked server one for mysql and another one for postgresql and use it from MS SQL Server. but as per my knowledge there is no facility in MySQL and in PostgreSQL to linked to each other.
0
 
earth man2Commented:
You can code C functions that can be called via database stored functions to access data in the NetSuite sos repository.
0
 
earth man2Commented:
this is already coded see PostgreSQL source tree

contrib/dblink
0
 
sreindl04Commented:
From development point of view it's file to not know where the data is located (aka using transparent dblinks). The problem ist that even high end databases (i.e. Oracle) are not able to optimize sqls over database links as the metadata available for the tables referenced remotely is very limited...

We used oracle and postgresql dblinks in several projects (yes, control/dblink) is fine but we came back to develop remote links by ourself to control performance on sql statements.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now