You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. 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 SQL Analysis Services data from the JMP Query Builder.Īccess SQL Analysis Services Data as an ODBC Data Source This article shows how to access SQL Analysis Services data into a report and create data visualization. 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 Analysis Services API, ensuring that your analysis reflects any changes to the data. You can use the CData ODBC Driver for SQL Analysis Services to integrate live data into your statistical analysis with SAS JMP.
0 kommentar(er)
