Comprehensive solution for crafting and managing sophisticated digital experiences
Build engaging websites with intuitive web content management
Leverage a complete UI toolbox for web, mobile and desktop development
Build, protect and deploy apps across any platform and mobile device
Build mobile apps for iOS, Android and Windows Phone
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Automate UI, load and performance testing for web, desktop and mobile
Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud
Optimize data integration with high-performance connectivity
Automate decision processes with a no-code business rules engine
Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation.
Globally scale websites with innovative content management and infrastructure approaches
Content-focused web and mobile solution for empowering marketers
Faster, tailored mobile experiences for any device and data source
UX and app modernization to powerfully navigate today's digital landscape
Fuel agility with ever-ready applications, built in the cloud
A hot trend we’re seeing is out-of-box connectivity to REST APIs to Business Intelligence and Data Warehousing infrastructure. For example, there’s a thread on SAP’s community site to connect Lumira Data Discovery and Visualization tool to SuccessFactors RESTful API.
The developer evangelism team at DataDirect always get really excited about any challenge to expose data through industry standards (see Python SaaS tutorial). This time, the goal was to develop a custom connector for REST data sources using DataDirect® OpenAccess SDK®. OpenAccess SDK opens up a world of possibilities as a platform for quickly developing custom connectors for any REST API. In this case, Saikrishna Teja Bobba – Developer Evangelist, developed a connector that would expose data from Meetup.com with Microsoft’s SQL Server Integration Services (SSIS) and Tableau for data analytics.
It’s easy to build an ODBC driver for any REST Service using OpenAccess SDK. To start, download and install OpenAccess SDK from the Progress driver download form (choose “custom connectivity” from the data category drop-down). Once complete, the client and server can be deployed as a single tier for ease of distribution. Documentation is available to help you through the installation process.
Contents of the ‘Rest Generator’ folder
<?xml version="1.0" encoding="UTF-8"?>
<column name="id" dataType="-9" userData=""/>
<column name="name" dataType="-9" userData=""/>
<column name="headcount" dataType="4" userData=""/>
<column name="distance" dataType="-9" userData=""/>
<column name="visibility" dataType="-9" userData=""/>
<column name="waitlist_count" dataType="4" userData=""/>
<column name="description" dataType="-9" />
<column name="event_url" dataType="-9" userData=""/>
<column name="maybe_rsvp_count" dataType="4" userData=""/>
<column name="yes_rsvp_count" dataType="4" userData=""/>
<column name="status" dataType="-9" userData=""/>
<column name="zip" dataType="4" userData=""/>
<column name="country" dataType="-9" userData=""/>
<column name="city" dataType="-9" userData=""/>
<column name="duration" dataType="-9" userData=""/>
<column name="how_to_find_us" dataType="-9" userData=""/>
<column name="created" dataType="11" userData=""/>
<column name="time" dataType="11" userData=""/>
<column name="updated" dataType="11" userData=""/>
<column name="state" dataType="-9" userData=""/>
<stat nonUnique="0" indexName="IDXMEETUPID" indexType="1" seqInIndex="1" columnName="id" cardinality="-1" pages="-1" filterConditions="" />
<pkfk pkColumnName="id" keySeq="1" updateRule="-1" deleteRule="-1" pkName="PKMEETUPID" />
Files generated by the schema definition
Enabling logging for troubleshooting
Viewing Meetup.com data in Interactive SQL
Connection settings in Tableau
Visualization of people interested in various technology based Meetups in California
Adding a connection in SSIS
Configuring connection in SSIS
Now you have everything you need to build your own ODBC, JDBC, ADO.NET and OLEDB data connectors, go ahead and download DataDirect OpenAccess SDK and get started!
Reach out to us online with any questions you may have, or leave us a message in the comments section below.
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 © 2016, 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 or appropriate markings.