DataDirect Cloud® provides freedom of choice for developers to access a wide range of data sources from their favorite programming language, such as Python.
It’s exciting to see developers instantly connect to data sources and deliver unique innovation to these business applications. In response, a developer evangelist on my team, Saikrishna Teja Bobba, created the following tutorial to help get more data flowing through open standards and into the developer's code. This connectivity is available on both Windows and Linux, but the steps are a little different depending on your OS. I’ve split the tutorial into sections based on this, so once you have completed the common steps feel free to skip ahead to the section for your OS.
Opening the DataDirect Cloud Dashboard
Choose your Data Source
Create a Salesforce Data Source
Before going any further, please note that we support the following Linux distributions:
If you are using a supported Linux distribution and have already completed the steps listed in the “Getting Started” section, you can proceed as follows:
This will install it in default directory /opt/Progress/DataDirect/Cloud_for_ODBC_20/
[ODBC Data Sources]
MySalesforce=DataDirect Cloud 2.0
Description=DataDirect Cloud 2.0
sources = pyodbc.dataSources()
dsns = sources.keys()
sl = 
i = 1
for dsn in dsns:
sl.append( str(i) + '. %s' % (dsn))
for row in cursor.tables():
def executeSelectQuery(cursor, cnxn):
query = raw_input('Enter the SELECT Query:')
rows = cursor.fetchall()
for row in rows:
def executeUpdateQuery(cursor, cnxn):
query = raw_input('Enter the UPDATE/DELETE Query:')
print('Select DSN you wish to connect:')
dsn_num = raw_input()
loginID = raw_input('Enter Data Direct UserName:')
password = getpass.getpass('Enter Data Direct Password:')
print('Attempting to Connect....')
cnxn = pyodbc.connect('DSN='+str(dsn[int(dsn_num)- 1])+';UID='+loginID+';PWD='+password+'', autocommit=True)
cursor = cnxn.cursor()
print(' 1. List all Tables')
print(' 2. Execute SELECT Query')
print(' 3. Execute UPDATE/DELETE Query')
print(' 4. Exit')
action = raw_input('Select your action:')
if(action == '1'):
elif(action == '2'):
elif(action == '3'):
elif(action == '4'):
print('Exception Occured:' + str(sys.exc_info()))
if __name__ == '__main__':
dsn = show_odbc()
Selecting a DSN
Provide DataDirect Cloud login details
Choose an action once connected
The process for connecting in a Windows environment makes use of the ODBC Data Source Administrator GUI. Before you begin, make sure you have completed the steps in the “Getting Started” section above. After you’ve done that, proceed as follows:
Click "Add" in the ODBC Data Source Administrator
Create the new data source in the next window.
Set up driver based on details from the DataDirect Cloud setup.
Though I chose to work in Python, similar steps can be followed with a language of your own choosing. Hopefully, this shows just how easy it is to establish a connection to any cloud data source using DataDirect Cloud and our ODBC/JDBC drivers.
Go ahead and grab a free trial of DataDirect Cloud and try it yourself! If you have any questions or run into any trouble, don’t hesitate to leave a comment below and we will help you out any way we can. Also, keep your eyes peeled for more posts from Saikrishna and myself, as we plan to share more exciting connectivity tricks in the future.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.