Data Source Types and Usages

A data source In File Access Manager is a table containing data from various sources, including internal File Access Manager reports, for use in various system locations. An Administrator can join data sources to form a superset of data, which follows the same logic as a “left join” in an RDBMS database.

Caution: For some data source types, the files should be located on the same server where the IIS is running. To run reports on these data types, the Reporting service has to be installed on the same server as well. Please check in the description of the relevant type below.

Available Data Sources

SQL Server Database

Access to SQL server database

Flat File

Query a delimited file

Excel

Read data from an MS Excel document

User Exit

Run a user script to return data

Active Directory

Access to the Active Directory

The files should be located on the same server as the IIS. In order to run reports, the Reporting service should be installed on the same server as well.

LDAP

Query LDAP for object types and properties

ODBC

Access to any ODCB source (such as, DB2 and AS400)

The files should be located on the same server as the IIS. In order to run reports, the Reporting service should be installed on the same server as well.

Oracle Database

Access to an Oracle database

Static Table

Define an ad-hoc source by creating and populating a table on screen

The files should be located on the same server as the IIS. In order to run reports, the Reporting service should be installed on the same server as well.

XML

Analyze and import data from XML

The files should be located on the same server as the IIS. In order to run reports, the Reporting service should be installed on the same server as well.