How to connect SQL database?

[#1]

Hi Team ,

    Seeking guidance to connect SQL database server .

Regards,

Ravi

[#2]

Have you tried with JMP Query Builder?

[#3]

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 

[#4]

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