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: 
Choose Language Hide Translation Bar
fxf
fxf
Level I

Database connection setup for a JMP project where the html will run in another network

Created: Jan 5, 2021 06:37 AM  |  Last Modified: Jun 10, 2023 07:24 PM (700 views)

Dear all,

 

Something I would like to explore but I am not understanding very well is how I could handle the database connection configuration when moving the JMP published html between networks.

 

It is tricky because I use JMP in a network and I want to setup and deploy the web page to work in another network. So I don’t have access to the production server connection/configuration while using JMP.

 

Can I change the connection string later in the html files?

 

Thanks for the help!

0 Kudos
3 REPLIES 3
briancorcoran
Staff briancorcoran
Staff

Re: Database connection setup for a JMP project where the html will run in another network

Jan 5, 2021 07:57 AM (694 views)  |  Posted in reply to message from fxf 01-05-2021

Hi fxf,

 

I would need more information to understand your issue.  JMP HTML5 output does not embed any database information in the report.  That is, it does not have knowledge to refresh itself. The data is embedded within the report, and is not changed.

 

On the other hand, Query Builder output does contain connection information.  It is possible, if careful, to change connection strings in the script for the Query to connect on a production server.  It is also possible, if you have the same ODBC DSN name and connection information on the two systems, to use the output as is.

 

Finally, HTML5 output to JMP Live is another matter entirely.  But, I'm not getting from your note that you are using JMP Live.

 

Could you provide more information as to  your workflow?

 

Thanks,

 

Brian Corcoran

JMP Development

fxf
fxf
Level I

Re: Database connection setup for a JMP project where the html will run in another network

Jan 5, 2021 08:30 AM (688 views)  |  Posted in reply to message from briancorcoran 01-05-2021

Thanks Brian.

 

I have the standard JMP.

 

I understand from your comment that the published html file does not refresh or update the data from the database.

 

If that is correct then I guess I will not be able to do a dashboard as intended.

So my only option would be using JMP live? I will look for more information on it.

 

Thanks

 

fxf

0 Kudos
briancorcoran
Staff briancorcoran
Staff

Re: Database connection setup for a JMP project where the html will run in another network

Jan 5, 2021 08:40 AM (685 views)  |  Posted in reply to message from fxf 01-05-2021

Hi fxf,

 

For JMP Live, you would publish new data from a JMP client to an existing report.  You would not republish the report, but JMP Live would recalculate the graphic and statistics on the website.  We are looking at the possibility of doing a server-side data refresh for a future version.

 

Brian