Solved

Linked server functionality in MySQL or PostgreSQL?

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL programmer starter 25 65
Windows Universal App 22 63
Read top line from CSV file 14 59
How does this modal work? 3 34
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
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 a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

751 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