This requirement is true even if both databases are accessed through the same DBMS. When setting up your MicroStrategy environment, you must create a separate connection to the data warehouse and metadata repository. A database server can contain multiple logical databases or data sources. Data source is another term for a logical database within a database server. A data source, identified by a data source name, is the database or file accessed by a driver. A client application uses a database driver and a driver manager to make a connection to the data source. ODBC permits maximum interoperability-an application can access data in diverse DBMSs through a single framework. Specifically, ODBC connects to and transfers data to and from data sources within relational databases. Intelligence Server uses ODBC to connect to and communicate with all database servers in the system. ODBC is a standard method of communicating with database servers. The following information assists you in setting up ODBC between Intelligence Server and your metadata database and data warehouse. Configuring and Connecting Intelligence Server » Communicating with databases » Setting up ODBC Setting up ODBC
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |