The Select Database Connection dialog is displayed. In SAS JMP, click File -> Database -> Query Builder.Follow the steps below to execute some supported queries in the Query Builder: Import SQL Server Data with the Query BuilderĪfter you have created the SQL Server DSN, you can use SQL to invoke the capabilities of the SQL Server API. This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. When you configure the DSN, you may also want to set the Max Rows connection property. Database: The name of the database, as seen in the Azure portal on the SQL databases (or SQL warehouses) page.User: The name of the user authenticating to Azure.You can find this by logging into the Azure portal and navigating to 'SQL databases' (or 'SQL data warehouses') -> 'Select your database' -> 'Overview' -> 'Server name.'

You can authenticate to Azure SQL Server or Azure Data Warehouse by setting the following connection properties:

Database: The name of the SQL Server database.Ĭonnecting to Azure SQL Server and Azure Data Warehouse.

Password: The password associated with the authenticating user.

User: The username provided for authentication with SQL Server.Server: The name of the server running SQL Server.You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.Ĭonnect to Microsoft SQL Server using the following properties: This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). It also shows how to use SQL to query and manipulate SQL Server data from the JMP Query Builder.Īccess SQL Server Data as an ODBC Data Source This article shows how to access SQL Server data into a report and create data visualization. The SQL Server API supports bidirectional access. The CData ODBC Driver supports the standard SQL used by JMP in the background as you design reports. The driver proxies your queries directly to the SQL Server API, ensuring that your analysis reflects any changes to the data. You can use the CData ODBC Driver for SQL Server to integrate live data into your statistical analysis with SAS JMP.

Sas jmp ebay