external data connector to mysql on aws

  • 1
  • Question
  • Updated 2 years ago
  • Answered
If I have a mysql database on aws.  Can I connect to a mysql database?  Is there a tutorial to connect to the mysql database?
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
The external data connection functionality is too fresh to have substantial documentation yet.  Its on our list, but we don't have anything yet.  But basic steps: 

1. Ensure that the database has REST API endpoints established (that conform to REST best practices) or an OData connector.  This is work that won't happen in Skuid. 
2. Identify and implement your authentication mechanism. 
3. Create a model service and set up authenticastion in the Skuid "Connect" tab.  
4. Create a model that calls your rest service. 

Honestly the tough part is in Step 1 and 2.  And those pieces are not going to have anything to do with Skuid or Salesforce. 
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
To expose MySQL databases as OData:

The simplest way, if you don't want to setup an OData connector yourself, would be to use a cloud-based solution such as Progress DataDirect Cloud, see this article for an example. (The article describes connecting using Lightning Connect, but there's no need for that, it will work with just Skuid)

http://westbrook.co.uk/odata-lightning-connect-real-time-erp-data-in-salesforce/

Here is an example of using Java EE to expose a MySQL database as OData:

http://stackoverflow.com/questions/16990252/how-to-expose-a-mysql-database-as-odata

And here are two projects that use PHP to expose MySQL databases as OData:

http://sourceforge.net/projects/mysqlodata/
https://odatamysqlphpconnect.codeplex.com/

Amazon REST APIs for Amazon Relational Database Services, including MySQL:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/RESTReference.html
Photo of rocketc

rocketc

  • 722 Points 500 badge 2x thumb
I set-up an Odata connection between a SQL database hosted with Azure and Skuid last night using Progress DataDirect Cloud product....and create a few cool skuid BI pages....easy to do. 

I also found a few products from CData (http://www.cdata.com/cloud/) they provide "Cloud Drivers" that allow you to create OData connections....
Photo of Sergei Kharchenko

Sergei Kharchenko

  • 70 Points
One more service to expose MySQL database via Odata REST API - Skyvia Connect.
Photo of Nishanth Kadiyala

Nishanth Kadiyala

  • 10 Points
DataDirect Cloud supports MySQL running on AWS https://www.progress.com/odata/mysql and https://www.progress.com/odata/mysql-community-edition have more information on this.

If you would like to understand these solutions in general, please visit: https://www.progress.com/cloud-and-hybrid-data-integration
(Edited)