Solved

Linked server functionality in MySQL or PostgreSQL?

Posted on 2009-04-03
4
650 Views
Last Modified: 2012-05-06
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
Comment
Question by:kevinvw1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 150 total points
ID: 24066204
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
 
LVL 22

Expert Comment

by:earth man2
ID: 24066521
You can code C functions that can be called via database stored functions to access data in the NetSuite sos repository.
0
 
LVL 22

Accepted Solution

by:
earth man2 earned 200 total points
ID: 24066879
this is already coded see PostgreSQL source tree

contrib/dblink
0
 
LVL 3

Assisted Solution

by:sreindl04
sreindl04 earned 150 total points
ID: 24069032
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

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question