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 :
- In the "Scan FME" menu, create a new entry point by clicking on "+ Create";
- Select the "Databases (PostGIS, Oracle, SQL Server)" type;
- Complete the entry point fields, divided into four sections:
- Information
- Metadata
- Data inclusion
- Data exclusion ;
- 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.
- Name the entry point;
- 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:
- Catalogs: Working group catalogs;
- Themes: Themes assigned to the working group;
- INSPIRE themes: INSPIRE themes ;
- Keywords : The list of keywords assigned to at least one OR record from the workgroup's shortlist.
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.