topic Re: How to connect SQL database? in Discussions

How to connect SQL database?

ABGnu771 — Thu, 09 Oct 2025 11:16:15 GMT

Hi Team ,

Seeking guidance to connect SQL database server .

Regards,

Ravi

Re: How to connect SQL database?

jthi — Thu, 09 Oct 2025 11:23:16 GMT

Have you tried with JMP Query Builder?

Re: How to connect SQL database?

P_Bartell — Thu, 09 Oct 2025 13:47:32 GMT

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?

Ressel — Thu, 09 Oct 2025 14:35:37 GMT

Install ODBC (not higher than 3.04.1008 for JMP18)
Create DSN
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();