Define an external data source - Intergraph Smart Isometrics - Help - Hexagon PPM

SmartPlant Isometrics Help

PPMProduct
Intergraph Smart Isometrics
PPMCategory_custom
Help
SPFVersion_custom
7.1 (2018 R1)
Version_IConfig
5.1(2014R1)
Version_ISOGEN
12.1(2014R1)
Version_SPIso
6.1(2014R1)
Version_SPSplgn
8.1(2014R1)

The Get External Data function supports a large range of external data sources by using the DSN (Data Source Name) and UDL (Universal Data Link) options. You can use any data source with an OLEDB or ODBC driver, which includes all commercially available database systems, from SQL Server and Oracle to MySQL and DB2. The basic requirement is that data is held in tables and can be accessed using SQL statements.

One of the most common data sources is an Excel spreadsheet. Because a spreadsheet is not a true database, there are special considerations when using Excel spreadsheets as a data source.

  • Data must be contiguous with no blank rows or columns.

  • There must be a single header row, containing field names.

  • Field names must be alpha numeric.

  • Each table must be given a user-defined name (for use in SQL statements).

  • If a column contains a mixture of numbers and strings, SQL statements can return unexpected values. This is because the first few rows of data are used to determine the contents of the column. For example, if the first 10 rows contain numbers, the whole column is treated as if it contains numbers. In this situation, the software may return strings as zero or blank.