January 24, 2020
Skyvia Connect allows you to easily expose MySQL data via OData service — RESTful API for quick, real-time data access and manipulation. OData is a widely accepted open standard built on HTTP, ATOM/XML and JSON, intended for data access over the Internet with no firewall configuration.
With Skyvia you do not need to build web API manually. Instead of building RESTful API with Node.js and MySQL, you can simply create an OData endpoint for quick data access.
Skyvia Connect is a universal cloud-based solution, which requires no coding, no technical skills. You do not need to develop MySQL restful web service, care about security, hosting and domain, obtain respective certificates, deploy, administer or maintain it. Our cloud-based solution will do it for you.
You can use it to expose any kind of data in a fast and convenient way – both from cloud and on-premise servers. To connect to on-premise servers, use our new Agent application developed by Skyvia team exactly for these needs.
Agent is a secure tunnel application developed to connect your Skyvia account to local, on-premise databases with ease and comfort and to establish secure communication bypassing firewall.
Try its functions by installing Agent application to your PC and creating MySQL connection you want to work with. Follow our easy step-by-step tutorial on how to do it in Skyvia.
To create an agent, perform the following steps:
Click +NEW in the top menu and select Agent from the list on the left.
When the Agent editor page opens, click Download.exe to download an Agent application
When you do it, the Skyvia Agent window pops up. Click the INSTALL button. By default, agent will be installed to C:\Program Files (x86)\Skyvia Agent.
If you have done everything correctly, on the Agent editor page you will see Connected sign and green light next to it.
To create a connection, perform the following steps:
Select Connection from the list on the left. The Select Connector page will open.
When the Connection editor page opens, select Agent under Connection Mode and fill in all the required parameters.
To create MySQL OData endpoint, perform the following steps:
Click +NEW in the top menu and click on OData Endpoint under Connect.
On the Endpoint editor page, drag-n-drop tables you need and manage connections between them.
When you have already created the endpoint, you can copy its URL from the Overview tab and use it for different purposes as well as in your OData consumer applications. You may also test the endpoint URL in the browser.
Having made a request in the browser, you will receive a response containing entity sets. In our example, we have received a response with 5 entity sets in JSON format — products, orders, orderdetails, productcategories and companies.
To receive all companies and see their properties, like CompanyID, CompanyName, Web, Email, Address, City, Region, Country, etc., we add the corresponding name of the entity set, companies, in the URL bar and check the displayed data.
You may use the endpoint URL in any other OData consumer applications, such as Excel or Salesforce Connect, etc. You determine it yourself based on your business needs and actual demand.
We welcome you to try OData REST API for MySQL and enjoy full functionality of our platform. Give us your feedback and share your thoughts!