906765_en-US

liliconcom

How to connect SQL database?

Hi Team ,

 

    Seeking guidance to connect SQL database server .

 

Regards,

Ravi

Quality and Process EngineeringRe: How to connect SQL database?

Have you tried with JMP Query Builder?

 

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 

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();