Skip to content

Database Management System (DBMS)

Specify the database connection parameters and the instances/schemas to be scanned.

Features and details

  • dBMS are independent of the operating system;
  • flat" or "file" databases are considered to be files (e.g. Esri FileGDB);
  • tables without geometry are not taken into account;
  • a table visible from several connection chains is not duplicated.

Add an entry point to a database

To create a "Database" entry point :

  1. In the "Scan FME" menu, create a new entry point by clicking on "+ Create";
  2. Select the "Databases (PostGIS, Oracle, SQL Server)" type;
  3. Complete the entry point fields, divided into four sections:
    • Information
    • Metadata
    • Data inclusion
    • Data exclusion ;
  4. Save and create the entry point.

Information

General entry point information. The fields in this section must be completed in order to register and create the entry point.

  1. Name the entry point;
  2. Enter database connection parameters.

Metadata

In the "Metadata" section, you can select the labels to be associated with all the records in the entry point. The fields in this section are optional.

NOTE: Metadata selected in the entry point will be added to all records in the entry point, even if added after the first scan.

Select metadata from the following list to associate with metadata records:

New metadata is added automatically during a scan.

Data inclusion

The "Data Inclusion" section allows you to select the entry point data to be scanned. Only data corresponding to the inclusion criterion will be scanned. The fields in this section are optional.

Fill in the three fields as required:

  • Schematics: Add the schematic(s) to be included;
  • Data : Add the data to be included. The data name must be in the following format: schema.table_name.

For all three inclusion types, it is possible to import a list from a CSV file (see Appendix on CSV file format). It is also possible to delete the contents of each list separately.

Data exclusion

The "Data exclusion" section allows you to select the entry point data to be ignored by the scan. Only data corresponding to the exclusion criterion will be scanned. The fields in this section are optional.

Fill in the three fields as required:

  • Schematics: Add schematic(s) to exclude;
  • Data : Add the data to be excluded. The data name must be in the following format: schema.table_name.

For all three types of exclusion, it is possible to import a list from a CSV file (see Appendix on CSV file format). It is also possible to delete the contents of each list separately.

Parameters required by database type

Field PostGIS Oracle SQL Server
Name X X X
Type X X X
Server X X X
Port X
Identifier X X X
Password X X X
Database name X X

Specific case of Oracle databases

For Oracle databases, you don't need to enter the database port and name. On the other hand, in the Server field, you can specify either the server host (ip or domain), or the name of the instance configured in the tnsnames.ora file, depending on the configuration of your environment. Be careful not to switch from one to the other by modifying the Server field. This can lead to duplicate entries, as Scan does not consider the same database to be involved.