Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Build, protect and deploy apps across any platform and mobile device
Automate decision processes with a no-code business rules engine
A complete cloud platform for an app or your entire digital business
Deploy automated machine learning to accurately predict machine failures with technology optimized for Industrial IoT.
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
If you work with data regularly, DataDirect Cloud's REST API can make your life easier. Use it to easily manage your resources and automate underlying operations based on user inputs.
Progress® DataDirect Cloud® is already a powerful solution for data connectivity, even before we get to the REST API. If you need to connect to data that’s sitting in cloud, or data sources installed on premise behind a firewall, DataDirect Cloud has you covered. Our service supports 23 different data sources, including cloud sources (like Salesforce.com, Google Analytics), relational databases (like SQL Server, IBM DB2) and Big Data sources (like Amazon Redshift, Apache Hadoop Hive).
Apart from that it also offers a REST API service. This manages DataDirect Cloud service resources in addition to the existing website, enabling you to manage your resources programmatically. To demonstrate the use of the REST API, the following article shows how we can leverage DataDirect Cloud’s REST API to develop an SAP Lumira Data Access extension that can fetch data from 23 different data sources.
OdbcConnection connect = new OdbcConnection("DSN=" + <DSN Name in ODBC Administrator> + ";Uid=" + <DataDirect Cloud UserName> + ";Pwd=" + <DataDirect Cloud Password> + ";DB=" + <User defined Data source name in DataDirect Cloud that you intend to connect to> + "");
//Configuring such that first line of data that you print has column names
//print Column Names separated by comma
//print each row where columns are separated by comma
Now that you've seen how the DataDirect Cloud REST API can make your life easier, what are you waiting for? Take advantage of this API to manage your resources and automate underlying operations based on user inputs. Of course, this is on top of the already amazing DataDirect Cloud connectivity services. Try out Progress DataDirect Cloud today and if you have any issues while working with it, please leave a comment below and we'll be happy to help you, or feel free to reach out to sales support.
Keep on the lookout for more posts by Saikrishna and myself, as we plan on sharing more exciting tricks and tutorials 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.