Replacing OData Connection After SharePoint Migration Without Losing Joins and Queries

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:

1. Open the Analysis

   Open the Spotfire analysis containing the OData connection that needs to be updated.

2. Access Data Connection Properties

   Go to the Data menu and select Data Connection Properties.

3. Select the OData Connection

   In the Data Connection Properties dialog, select the OData connection you want to replace.

4. Navigate to the Settings Tab

   Click on the Settings tab.

5. Replace the Connection

   Look for the Replace option and click on it.

6. Choose the New OData Connection

   Select the new OData connection that points to your SharePoint Online environment.

7. 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.