topic Re: How to Share a Project with DB Query in Discussions

How to Share a Project with DB Query

TomZhang — Fri, 16 Aug 2024 06:51:11 GMT

If my data comes from SQL Server with a SQL query, I need to create ODBC connection in my PC in advance. what if I want to share this data analysis to my colleague or put this project in JMP Live for others to access?

It just raises error like can't login.

Re: How to Share a Project with DB Query

jthi — Fri, 16 Aug 2024 07:13:35 GMT

Should other users be able to update the data?
Which JMP version are you using?
How is your company handling usernames/passwords for database connections?

Re: How to Share a Project with DB Query

TomZhang — Sun, 18 Aug 2024 10:54:16 GMT

Should other users be able to update the data?

Yes, everyone who access the project can update the data or the data can be updated daily.

Which JMP version are you using?

Latest version, our company just deployed JMP LIVE.

How is your company handling usernames/passwords for database connections?

It is read only username and password, so it is shared by engineers and quality team.

Re: How to Share a Project with DB Query

jthi — Sun, 18 Aug 2024 11:10:25 GMT

You can create a data connector, package that and then distribute that https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/connect-to-a-database-using-data-connectors.shtml . Also I think in JMP Live you can manage who are able to update/refresh the data https://www.jmp.com/support/help/en/18.1/jmplive/jmplive.shtml#1848059