Create a new external data filter connection - Intergraph Smart Construction - 2019 (7.0) - Help - Hexagon PPM

Intergraph Smart Construction Help (2019)

Language
English
Product
Intergraph Smart Construction
Search by Category
Help
Smart Construction Version
2019(7.0)
SmartPlant Foundation / SDx Version
10

In order to create an external data filter, you must set up a connection object to communicate with the external data source.

Verify the correct data source provider is installed on the server when you configure the external filters.

  1. Log on to SmartPlant Foundation Desktop Client as an administrator.

  2. Click Smart Construction > New > Administration > External Data Filter Connection to open the New External Data Filter Connection form.

  3. On the New External Data Filter Connection form, type a name for an external data filter connection in the Name box.

  4. Type a description for the external data filter connection in the Description box (optional).

  5. Enter an OLEDB data source for the external data connection in the Connection string box.

    An OLEDB connection string specifies the data source type (provider), data source location, and credentials. Formats for data connections vary, depending on the tool used to create the connection. The following example is an OLEDB connection created using Microsoft Access 2010:

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\temp\externalfilters\GateValveStatus2010_x64.xlsx;Extended Properties="Excel 12.0;HDR=Yes;"

  6. Click Apply or Finish to save the external data filter connection information.