ODBC Data Source

In a repository you can access various data sources via ODBC drivers installed on the workstation. The ODBC Data Source repository object is used to get access. This object enables the user to set up connection and get data. Data is displayed as a table and can be used to create multidimensional structures of repository data.

Creating an ODBC Data Source

Creating an ODBC data source and work with it are available only in the desktop application.

To create the ODBC data source in the object navigator:

Execute one of the operations:

Select the Create > Table context menu item.
Click the New Object button in the Create group on the Home ribbon tab and select the Table item.

Select a type of object to be created on the Object Type page.

After executing the operations in the ODBC data source wizard determine settings on the pages:

Basic Properties. It is used to set object name, identifier and comment
Parameters. List of parameters is created.
ODBC Data Source. The source or the ODBC driver, based on which a new source should be created, is determined.
Settings. Determines parameters of data provider connection.

Working with an ODBC Data Sources

To view data, select the corresponding object in the object navigator and execute one of the operations:

Select the Open item in the object's context menu.
Double-click the object.
Press the ENTER key.
Select the View item on the Home ribbon tab in the desktop application.

After executing one of the operations the corresponding data object opens. For details about principles of work with a data set see the Working with Data Set section.

NOTE. If the file with data (text file, Microsoft Excel file, and so on) is connected by means of ODBC driver, working with records is made only in the read mode. Adding, deleting, changing of records is not supported.