Working with Data Sources

You can use the same data source for multiple entities, or each entity can be associated with a different data source. This allows DORIS to extract data from a variety of data repositories and then deliver the processed data to the target in a uniform way.

A data source is one of the following formats:

  • MAPS
  • Oracle (Banner)
  • SQL Server
  • CSV file

The system administrator is generally responsible for setting up the data source configurations, but anyone with data source permission can create and edit a data source.

Check the Status of a Data Source

To determine if the data source you want to use is available, use the Data Sources link at the top of the page to display the status page. From this page you can also Edit a Data Source and Add a New Data Source.

Page that lists each configured data source, its type and status, and when it was last run or modified.

  • Available means that the data source is connected and communicating with DORIS.
  • Processed means that the data source is connected and data has been uploaded successfully.
  • Processing means that the data is currently being uploaded and analyzed.
  • Unavailable means that the data source is not communicating with DORIS and data cannot be extracted from it at the moment. This may be due to a network error, a configuration error, or other causes.

Edit a Data Source

The Edit link to the right of each data source listed on the status page displays a page for configuration of the data source connection.

MAPS, Oracle (Banner), and SQL Server Data Sources

Name is the data source name that is displayed on the status page and used during selection of the data source for an entity.

Source Type specifies the format of the data.

Hostname, Port and SID provide the connection information.

Username and Password provide the credentials for an account authorized to use the data source.

CSV File Data Sources

File Upload allows you to browse to the CSV file that contains the data to be used for the data source. Browse to the file and then select Upload File.

Add a New Data Source

Select the Add New button from the Data Source status page to add a new data source.

Enter the name, source type, and file or connection information. These fields are described above for editing a data source.

The Test Connection button allows you to make sure the data source is configured properly and communicating with DORIS. Select Create when you are done.

Page used to configure a new data source.

 

See also: