How to Share a Project with DB QueryIf 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.
Automation and ScriptingData AccessRe: How to Share a Project with DB Query- 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- 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 QueryYou 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
