After you configure data source names for the Data Source database and OLAP Metadata Catalog database, you can connect to databases from Integration Services. 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 .
If you plan to use flat (text) files as data source, you must set up data source names for those files. See Configuring Data Source Names on Windows SystemsConfiguring Data Source Names on UNIX Systems.
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 Troubleshooting ODBC and Connections.