Multiple Data Source Support

The Multiple data source support VLDB property allows you to choose which technique to use to support multiple data sources in a project. This VLDB property has the following options:

• Use MultiSource Option to access multiple data sources (default): MultiSource Option is used to access multiple data sources in a project.

  MicroStrategy includes an extension to Intelligence Server referred to as MultiSource Option. With this feature, you can connect a project to multiple relational data sources. This allows you to integrate all your information from various databases and other relational data sources into a single MicroStrategy project for reporting and analysis purposes. All data sources included by using the MultiSource Option are integrated as part of the same relational schema for a project.

• Use database gateway support to access multiple data sources: Database gateways are used to access multiple data sources in a project.

  You can specify a secondary database instance for a table, which is used to support database gateways. For example, in your environment you might have a gateway between two databases such as an Oracle database and a DB2 database. One of them is the primary database and the other is the secondary database. The primary database receives all SQL requests and passes them to the correct database.

Any object using a data source other than the primary data source is considered as having multiple data sources. Therefore, the Execute Report that uses multiple data sources privilege is required. This rule also applies to scenarios when the object uses data only from a non-primary data source.

For more information on both techniques for connecting to multiple data sources, see the Project Design Help.

Levels at Which You Can Set This

Database instance and project