Create a data source using DSN - Intergraph Smart Isometrics - Help - Hexagon PPM

Intergraph Smart Isometrics Help

Language
English
Product
Intergraph Smart Isometrics
Search by Category
Help
SmartPlant Foundation / SDx Version
10
I-Configure Version
6.0(2016)
Isogen Version
13.0(2016)
Smart Isometrics Version
7.0(2019)
Spoolgen Version
9.0(2019)

In the example below, an external link has been set up to the sample spreadsheet (GetExternalData.xls) delivered with the Tutorial project.

For information about creating the Tutorial project to access the sample data, see the I-Configure Help.

  1. In the Control Panel, double-click Administrative Tools, and then double-click Data Sources (ODBC).

  2. On the User DSN tab of the ODBC Data Source Administrator dialog box, click Excel files in the User Data Sources list, and then click Add.

    The type of data that is linked depends on the ODBC database drivers currently installed on the computer. Drivers for Access, Excel, SQL Server and Oracle databases are commonly available.

  3. Click Microsoft Excel Driver (.xls) on the Create New Data Source page, and then click Finish.

    Create New Data Source

  4. In the ODBC Microsoft Excel Setup dialog box, type a name for the external data source in the Data Source Name box. For example, type Project1.

  5. Click Select Workbook. Navigate to GetExternalData.xls, and then click OK.

    When you create the Tutorial project, the sample GetExternalData.xls file is delivered to the following location:

    • In Smart Isometrics: [Installation Folder]:\SampleIsoDir\SPITutorial\\Data\Get External Data

    • In Spoolgen: [Installation Folder]\SampleIsoDir\S5Tutorial\\Data\Get External Data

  6. Click OK in the ODBC Microsoft Excel Setup dialog box.

    ODBC MS Excel Setup

    The new data source appears in the User Data Sources list.

    Project 1 Data Source