nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

17 OCT 2022 SE Monthly :: JMP Live 17 and accessing data from a refresh script with Dieter and Alex

chuck_boiler

Hi SE’s,

The featured content and speakers for the October 2022 Monthly meeting were:

Alex and Dieter shared what to keep in mind when accessing data from a refresh script in JMP Live. They also showed a good way to demo the new data refresh using devlive17. The details on the connection script are here:

https://jmpdiscovery.atlassian.net/wiki/spaces/JMPPRODMGMT/pages/15237947/Data+Refresh+Scripts

Details on the JMP Live 17 Demo Instance connecting via ODBC:

Username: jmpSE

Password: jmpdemo1

Server name: jmpdemo.ckpyug0kokan.us-east-1.rds.amazonaws.com

port 5432

The recording is here:

SE Monthly Meeting-20221017_100155-Meeting Recording.mp4

Thanks all!

Chuck, Mary, Nick

Accepted answers

Jordan_Hiller

Update: Alex helped me with the ODBC driver, it's working for me now. Here are the steps if you wish to connect to this demo database from JMP 17 (at least from Windows).

1) Download and install ODBC driver from here: https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_13_02_0000-x64.zip .

2) Launch the ODBC manager from windows, it's called ODBC Data Sources (64-bit). Add a new User DSN and select the "PostgresSQL Unicode(x64)" driver.

3) Fill out the configuration as follows:

Data Source: <choose your own name here>

Database: datademo

Server: jmpdemo.ckpyug0kokan.us-east-1.rds.amazonaws.com

Port: 5432

User Name: jmpSE

Password: jmpdemo1

Leave all other fields at their defaults, and click "Save"

That ought to do it.

I'll try to put together a JMP Live refresh demo to share.

All comments

Phil_Kay

Thanks! This was really useful and seems very important for how we are going to work with customers to help them understand the value of JMP Live. I think there was a comment about needing an "idiot" guide for how to do some of this stuff. This idiot would also find that useful.

Jordan_Hiller

@dieterpisot , @Alex_Lippincott , I need a little help configuring the ODBC connection from desktop JMP 17 to the demo database.

I downloaded this ODBC driver: https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_13_02_0000-x64.zip . Guessing this is the correct one from the ODBC connection string in the refresh script you shared. Can you confirm this is correct?

Then from JMP 17, I choose File > New Database Query, and click on the "New Connection..." button. I create a new User DSN with this driver:

Then I'm taken to a configuration screen. I tried the following from the info you provided:

When I click "Test", I get:

Help???

Jordan_Hiller

Update: Alex helped me with the ODBC driver, it's working for me now. Here are the steps if you wish to connect to this demo database from JMP 17 (at least from Windows).

1) Download and install ODBC driver from here: https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_13_02_0000-x64.zip .

2) Launch the ODBC manager from windows, it's called ODBC Data Sources (64-bit). Add a new User DSN and select the "PostgresSQL Unicode(x64)" driver.

3) Fill out the configuration as follows:

Data Source: <choose your own name here>

Database: datademo

Server: jmpdemo.ckpyug0kokan.us-east-1.rds.amazonaws.com

Port: 5432

User Name: jmpSE

Password: jmpdemo1

Leave all other fields at their defaults, and click "Save"

That ought to do it.

I'll try to put together a JMP Live refresh demo to share.

Jordan_Hiller

I made a quickie demo for this. Details here:

https://community.jmp.com/t5/JMP-SE-Knowledge-Base/JMP-Live-17-Refresh-Demo/ta-p/563123

Peter_Hersh

Thanks Jordan super helpful setting up my new computer.