Access the MSSQL database from PostgreSQL using TDS Foreign Data Wrapper (TDS_FDW) The Tabular Data Source (TDS) Foreign Data Wrapper (TDS_FDW) is a Postgres extension that allows you to access data that resides on an MSSQL database from Postgres Server. TDS_FDW depends on a database access library called FreeTDS. FreeTDS is a set of libraries […]
Steps to create a Database Link from Oracle to MSSQL Server Nowadays many companies are using a mix of RDBMS systems, for example, some instances are running on Oracle and other instances are running on MSSQL Server, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow us to query data from non-Oracle databases using SQL. In the previous two […]
Steps to Setup Database Link in PostgreSQL Database Link in PostgreSQL enables a database user to access a table present on a different PostgreSQL cluster. It provides a functionality in PostgreSQL similar to that of DB Link in Oracle, Linked Server in SQL Server and Federated Table in MySQL. In previous post we saw How to […]
Steps to create a Database Link from Oracle to PostgreSQL Nowadays many companies are using a mix of RDBMS system for example, some instances are running on Oracle and other instances are running on PostgreSQL, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow us […]
Steps to create a Database Link from Oracle to MySQL Nowadays many companies are using a mix of RDBMS system for example, some instances are running on Oracle and other instances are running on MySQL, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow us to query data from non-Oracle databases using SQL. In this blog post we will see How to […]
Recent Comments