Create a data connection - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

You can create a data connection with the sample Excel file PUMPS_500OrigC from the sample data located on Smart Community. For more information, see Find sample data on Smart Community.

  1. Log onto the the software as a Data CaptureAdministrator.

  2. Click Data Capture Administration > Data Reader Patterns.

  3. In the Data Reader Patterns module, click Data Connections.

  4. In the Data Connections page, click Add Data Connection .

  5. In the Create Data Connection window, enter the following information

    1. Name - Type a name for the data connection. For example, you can name it as Xls_PumpList.

    2. Domain - Type the domain name that you want to create in product database to store the domain tags. For example, you can type the domain name as XlsPumps.

    3. Connection Type - Select Excel from the database list.

    4. Provider Name - Type the provider name for the database (the default value is Microsoft.ACE.OLEDB.12.0).

  6. Click OK > Save to save the data connection details in the database.

  • You can also create data connections for any of the databases such as Oracle, SQL, MS Access, and Custom.

  • To edit an existing data connection, click edit data connection .

  • To delete one or more existing data connections from the list, click delete data connection.