In a repository you can access various data sources via ODBC drivers installed on the workstation. The repository object ODBC data source 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.
To create a ODBC data source in object navigator, do the following:
The Create > Table context menu item.
The New Object > Table item in the Create group on the Home tab.
A table creation wizard opens after executing one of the operations. On the Basic Properties page determine object name and identifier. On the Object Type page select the created object type in the list - ODBC Data Source:
After selecting object type, determine page settings:
ODBC Data Source. Determines the source or ODBC driver, based on which a new source should be created.
Settings. Determines parameters of data provider connection.
NOTE. It is available to create and work with ODBC data source only in the desktop application.
To view data, select the corresponding object in the object navigator and execute one of the operations:
Double-click with the main mouse button.
Select the Open context menu item.
Select the View item on the Home ribbon tab.
A dialog box with data opens. Description of this dialog box and principles of working are described in 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.
See also: