After configuration of data source names

After you configure data source names for the Data Source database and OLAP Metadata Catalog database, you can connect to the databases from DB2 OLAP Integration Server. You can then create, modify, and save OLAP models and metaoutlines. For information on viewing TBC tables, columns, OLAP models, and metaoutlines in Integration Services Console, see Viewing TBC tables and columns.

Note:
The SQL Server ODBC driver may time out during a call to an SQL Server database, particularly during a data load. If a timeout occurs, try again when the database is not busy. Increasing the driver time-out period may avoid this problem. For more information, see the ODBC documentation for the driver that you are using.

For more information on ODBC connection problems and solutions, see the Integration Services Administrator's Guide.