Opcenter Intelligence Direct Connection¶

Opcenter Intelligence Direct Connection is a specialized data connectivity solution, enabling direct real-time data integration between manufacturing systems and business intelligence platforms.

To publish a data source for Opcenter Intelligence entities, follow these steps:

1. Open the "Insights Hub Business Intelligence" application.

2. To create a new datasource, select "New" and click "Published Data Source" from the dropdown menu.

3. Select "Connectors" and click "Microsoft SQL Server".

4. Enter the details in the "General" tab and for information about Initial SQL, refer to Run Initial SQL.

   Note

   Only the "Microsoft SQL Server" connector is supported from the list.

5. Enter the details in "General" tab and for information about Initial SQL, refer to Run Initial SQL.

   • Enter the Server as received from customer support.
   • Enter the Database.

   • In Authentication section, select "Use a specific username and password" and enter the details.

     Info

     In order to get username and password, contact support team.

   • Click "Sign In".

   

6. To edit the datasource, refer to Tableau.

7. To publish the data source, click "Publish As".

8. Enter the "Name" and enable the checkbox of "Embed credentials".

   

9. Click "Publish".