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. APISecret: Set this to the Secret key from the API settings page.APIKey: Set this to the API key from the API settings page.On the API Settings page, note the API Key and API Secret.Click on the settings icon in the upper right corner.Use the BASIC Authentication standard to connect. 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).
#JMP GRAPH BUILDER BACKGROUND COLOR HOW TO#
It also shows how to use SQL to query ShipStation data from the JMP Query Builder.Īccess ShipStation Data as an ODBC Data Source This article shows how to access ShipStation 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 ShipStation API, ensuring that your analysis reflects any changes to the data. You can use the CData ODBC Driver for ShipStation to integrate live data into your statistical analysis with SAS JMP.
0 kommentar(er)
