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. If you are connecting to SharePoint Online, set the SharePointEdition to SHAREPOINTONLINE along with the User and Password connection string properties.įor more details on connecting to SharePoint Online, see the 'Getting Started' chapter of the help documentation The User and Password properties, under the Authentication section, must be set to valid SharePoint userĬredentials when using SharePoint On-Premise. This allows you to query any lists and other SharePoint entities defined for the site or sub-site. Set the URL property to the base SharePoint site or to a sub-site. 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 and manipulate SharePoint data from the JMP Query Builder.Īccess SharePoint Data as an ODBC Data Source This article shows how to access SharePoint data into a report and create data visualization. The SharePoint 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 SharePoint API, ensuring that your analysis reflects any changes to the data. You can use the CData ODBC Driver for SharePoint to integrate live data into your statistical analysis with SAS JMP.

Sas jmp upload data