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 Occurred:' + 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.
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, 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.