|
Product |
Version |
| Spotfire |
All Supported Versions |
Keywords:
OData connection, SharePoint 2013, SharePoint Online, migration, data connection properties, replace connection, Spotfire OData Connector
Introduction: This article provides a solution for users who need to update their OData connection in Spotfire after migrating from SharePoint 2013 to SharePoint Online while preserving existing joins and queries.
Solution:
-
Open the Analysis
Open the Spotfire analysis containing the OData connection that needs to be updated.
-
Access Data Connection Properties
Go to the Data menu and select Data Connection Properties.
-
Select the OData Connection
In the Data Connection Properties dialog, select the OData connection you want to replace.
-
Navigate to the Settings Tab
Click on the Settings tab.
-
Replace the Connection
Look for the Replace option and click on it.
-
Choose the New OData Connection
Select the new OData connection that points to your SharePoint Online environment.
-
Confirm the Replacement
Confirm the replacement to update the connection.
Key Points:
- This method allows you to update the connection without replacing the entire data table.
- Existing joins and queries associated with the data table will be preserved.
- The Spotfire OData Connector is not deprecated and can still be used with SharePoint Online.
- Ensure that the new OData connection is properly configured to access your SharePoint Online environment.
Benefits:
- Maintains data model integrity.
- Reduces the need for extensive rebuilding of dashboards and analyses.
- Allows for a smoother transition from SharePoint 2013 to SharePoint Online.
Note: Always test the updated connection in a development environment before applying changes to production analyses.
Additional Documentation:
- For further assistance or guidance on specific use cases, contact Revvity Signals Support.
- Refer to the Spotfire User Guide for detailed instructions on managing data connections.
Limitations:
- Ensure that the new OData connection has the same structure (e.g., column names, data types) as the original connection to avoid errors in existing analyses.
External Resources:
- Documentation: Documentation for Spotfire and OData connections.