This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
d_barnett
d_barnett
Level IV

API Access to AWS Database

Sep 17, 2018 09:32 AM (2766 views)

I’m trying to access a database using the new API request feature in JMP ( I’m using 14.1) and I’m having trouble understanding what is required to connect to the database.

 

I’m trying to access amazon cloud ( AWS) at the following location

 

deawdoraisap001.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.com

username is dbarnett

password is Password_123 ( obviously it isn’t this so it’s just an example)

 

Could you let me know what the jsl script is that would allow me access to this database please ( if it is actually possible)? I’ve read and tried the examples but I’m still confused as to what is needed.

 

Regards


David Barnett

1 REPLY 1
briancorcoran
Staff briancorcoran
Staff

Re: API Access to AWS Database

Sep 17, 2018 02:34 PM (2744 views)  |  Posted in reply to message from d_barnett 09-17-2018

If you have a database like postgreSQL or MySQL, it may be possible to access it through an ODBC driver.  This would allow you to use the full range of Query Builder or Open Database features within JMP.  For the server setting within the ODBC driver, you would typically provide the endpoint within AWS, and perhaps the port (postgreSQL defaults to 5432).  

 

Brian Corcoran

JMP Development

0 Kudos