cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
ABGnu771
Level I

How to connect SQL database?

Hi Team ,

 

    Seeking guidance to connect SQL database server .

 

Regards,

Ravi

3 REPLIES 3
jthi
Super User

Re: How to connect SQL database?

Have you tried with JMP Query Builder?

jthi_1-1760008986819.png

 

-Jarmo
P_Bartell
Level VIII

Re: How to connect SQL database?

I agree with @jthi 's recommendation to use Query Builder...you can make the connection and execute the query all within the Query Builder platform. Here's a link to the JMP documentation with details: Connect to SQL database 

Ressel
Level VII

Re: How to connect SQL database?

  1. Install ODBC (not higher than 3.04.1008 for JMP18)
  2. Create DSN
  3. Something @jthi has been teaching:
ODBC = "ODBC:DSN=your_DSN_name";

sql_str = "SELECT * FROM ...";

obj = New SQL Query(
	Connection( ODBC ),
	Custom SQL( sql_str ),
	Query Name( "query name" )
);
dt = obj << Run;  // << Run Foreground(); 

 

Recommended Articles