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.
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.