Scan an Esri database (SDE) ¶

Enter the path to the corporate geodatabase connection file to be scanned.

Add an SDE entry point¶

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 save and create the entry point.

1. Name the entry point;
2. Enter the path to the SDE connection file. This path must be accessible to the Windows user launching the Scan service (see User account configuration).

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 matching at least one of the inclusion criteria 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 any exclusion criteria 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.

Best practices¶

It is advisable to create a folder on the server where the Isogeo service is installed to store SDE files. Then simply copy and paste the SDE files generated on ArcCatalog by the GIS administrator into this folder. For your information, SDE files are generally stored by ArcCatalog at the following path: C:\UsersNameAppDataRoamingESRI\Desktop10.6ArcCatalog\.

Generate an SDE connection file from ArcCatalog¶

1. Open ArcCatalog ;
2. Add a database connection (see figure below) ;

3. Set database connection parameters ;

   

4. The drop-down list of accessible databases is generated;

5. Select the database concerned, validate and check that the list of tables is displayed in the tree structure.
6. Next, open the connection properties to retrieve the path to the SDE file (General tab, Name)

For further information, please consult the official documentation.