Interactive Reporting - What is a Data Source

This explains connectivity of the Interactive Reporting Desktop Client (Hyperion) and databases.

Note: Interactive Reporting, including both the IR Workspace (web) and the Studio Desktop client, will be decommissioned on March 1st, 2019. Neither the web nor the desktop software will be available or supported after this date.

UW-Madison affiliates can find more information on alternative tools on the Office of Data Management and Analytics Services website.

Other UW System affiliates can find additional information, as well as a list of support contacts, on the UWBI Support website.

What is a data source?

A data source is data and the connection information needed to access that data. Examples of data sources are Oracle RDBMS, Microsoft Access, Microsoft SQL Server, a spreadsheet, and a text file. Examples of connection information include server location, database name, logon ID, password, and various ODBC driver options that describe how to connect to the data source.

In the ODBC architecture, an application (such as the Interactive Reporting Desktop Client or MS Access) connects to the ODBC Driver Manager, which in turn uses a specific ODBC driver (for example, Microsoft SQL ODBC driver or Oracle ODBC driver) to connect to a data source.*

To connect to these data sources, the following must be done:

  • Install the appropriate ODBC driver on the computer that contains the data source.
  • Define a data source name (DSN) by using either the ODBC Data Source Administrator to store the connection information in the Microsoft Windows registry or in a DSN file (or use a connect string in Visual Basic code to pass the connection information directly to the ODBC Driver Manager).
  • When using the Interactive Reporting query tool SQLNet will be used to set-up an .oce to established a connection to the data source.

Machine Data Sources

Machine data sources store connection information in the Windows Registry on a specific computer with a user-defined name. You can use machine data sources only on the computer they are defined on. There are two types of machine data sources — user and system. User data sources can be used only by the current user and are visible only to that user. System data sources can be used by all users on a computer and are visible to all users on the computer and system-wide services, such as Microsoft Windows NT services. A machine data source is especially useful when you want to provide added security, because only users who are logged on can view a machine data source and it cannot be copied by a remote user to another computer.

File Data Sources

File data sources (also called DSN files) store connection information in a text file, not the Windows registry, and are generally more flexible to use than machine data sources. For example you can copy a file data source to any computer with the correct ODBC driver so that your application can rely on consistent and accurate connection information to all the computers it uses. Or you can place the file data source on a single server, share it between many computers on the network, and easily maintain the connection information in one location.

* An ODBC data source (Data and information needed to access that data from programs and databases that support the Open Database Connectivity protocol), for example, a database and the server on which it resides, is accessed through an ODBC driver (Open Database Connectivity is a standard method of sharing data between databases and programs. ODBC drivers use the standard Structured Query Language (SQL) to gain access to external data.). InfoAccess is an ODBC database.

Keywords:Interactive Reporting Client ODBC data sources desktop Hyperion SQLNet MS Access Interactive Reporting Oracle database driver   Doc ID:7743
Owner:Tim L.Group:Interactive Reporting Madison
Created:2008-05-05 19:00 CDTUpdated:2018-12-06 16:10 CDT
Sites:DoIT Help Desk, Interactive Reporting Madison
Feedback:  0   4