SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Greenplum Data Warehouse Administration and SQL Development tutorials, guides and code samples, tools and downloads for SQL Database Professionals

Create Greenplum ODBC Data Source

In this guide, system administrators can find the steps to create System Data Source DSN entry of Greenplum ODBC connection using DataDirect ODBC driver for Greenplum. Application programmers and data platform administrators like SQL Server database administrators, data virtualization tool developers and reporting tool front-end developers can access to Greenplum databases using system DSN created by ODBC driver.

How to and where to download DataDirect ODBC Driver for Pivotal Greenplum is shared on tutorial Download and Install ODBC Driver for Pivotal Greenplum Database for administrators and developers. If you have not yet installed the Greenplum ODBC driver, please refer to mentioned guide.

I assume that you downloaded Greenplum ODBC driver provided by DataDirect and installed it successfully.
To start creation of ODBC data source creation, first of all, launch ODBC Administrator application with an administrative account.

launch ODBC Administrator

When the ODBC Data Source Administrator screen is displayed, switch to System DSN tab.
We are ready to create a new ODBC data source, so click on "Add" button.

On "Create New Data Source" dialog screen, choose the DataDirect 7.1 Greenplum Wire Protocol ODBC driver and press Finish to continue.

create New Data Source for Greenplum database using ODBC driver

On next screen, the ODBC database connection parameter values will be provided for the target Pivotal Greenplum data warehouse database.

Data Source Name: Type a descriptive name to your DSN entry
Description: Give brief information about the target Greenplum database
Host Name: IP address of the target Pivotal Greenplum database
Port Number: The default port number for Greenplum databases is 5432
Database Name: The database name on Greenplum Data Warehouse that this ODBC connection is created to connect

ODBC Greenplum driver setup details

Press "Test Connect" button to check if the Greenplum ODBC connection is correctly defined.
This screen will request you a valid database username and the password of the user that has authentication to connect to the target Greenplum database.

test Greenplum database ODBC connection

Press OK to test connection
If Greenplum database connection is successfull, you will see following success message "Connection established".

successfull Greenplum database connection

It is recommended to set the "Max Long Varchar Size" to 8192 on "Advanced" tab of the DSN entry.

advanced settings for Greenplum ODBC driver

Click on Apply and OK buttons to complete ODBC Data Source creation for Greenplum database.

When you return to ODBC Data Source Administrator screen, you will see the latest Greenplum data source on the System DSN data sources list.

Pivotal Greenplum data source in System DSN

Click OK to close the screen.

Now Greenplum ODBC data source can be used to create connection to the target Greenplum database.
In SQL Server tutorial Connect Greenplum Database using Linked Server on SQL Server, I share the steps of accessing to a Greenplum database by creating Linked Server on SQL Server instances for database administators.

Greenplum DWH

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.