0 Comments

Access the MSSQL database from PostgreSQL using TDS Foreign Data Wrapper (TDS_FDW) 0 (0)

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 […]

 438 Total Views

0 Comments

Steps to create a Database Link from Oracle to MSSQL Server 0 (0)

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 […]

 615 Total Views

0 Comments

Steps to Setup Database Link in PostgreSQL 4 (1)

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 […]

 2,568 Total Views,  6 Views Today

0 Comments

Steps to create a Database Link from Oracle to PostgreSQL 0 (0)

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 […]

 2,364 Total Views,  6 Views Today

0 Comments

Steps to create a Database Link from Oracle to MySQL 0 (0)

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 […]

 1,857 Total Views,  8 Views Today