An ArcGIS Connection is used when you want to add GIS data from an additional data source in your report.

Specify the name of the connection and click on Build...

 

Choose a workspace type and the path to the data source. Following setup types are available:

•PGDB (Personal Geodatabase / *.mdb)

•FGDB (File Geodatabase / *.gdb)

•SDE (ArcSDE Database)

 

If you use the Workspace type define the data source to the desired type.

 

If you use SDE as workspace type, you have to select the path where the .SDE file is stored. By default, the SDE file is stored under C:\Users\BenutzerXXX\AppData\Roaming\ESRI\Desktop10.x\ArcCatalog.

 

Test the connection by pressing the button Test Connection. The Connection String for the ArcGIS connection is created. The connection string shows, that an ESRI GeoDB OleDB driver is used for the data request.

 

 

The next step is to add the tables and feature classes from your ArcGIS data source.

 

Choose your ArcGIS connection as new data source.

 

The select data window only lists the geodatabase tables. The feature classes are not listed. The feature classes have to be queried first. For this, click on Query New.

 

Specify the name of the new data source and insert the SQL statement in the query text window. For the select statement you have to know the feature class name (e.g. hfl for houses: Feature Class Name Hfl). If you want to have all feature class columns available in the data source, the SQL expression must look like this: Select * from Hfl.

After you have specified the expression, click the button Retrieve Columns to get the queried columns of the feature class.

 

BLOB fields and geometry fields (SHAPE, Shape_Length, Shape_Area) are filtered. If you want to query these fields, an error message is thrown.

 

After confirming the dialog, the data source can be selected among the queries. Select the query to add it as a data source.