Solved

Linked server functionality in MySQL or PostgreSQL?

Posted on 2009-04-03
4
622 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# Error - Add Failed 12 78
What is Thread.Sleep? 5 45
Not showing page correctly 3 29
Whether to use true/false, yes/no or 0/1 11 51
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

929 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now