A data warehouse stores the data that users of the system must analyze to track and respond to business trends, and to facilitate forecasting and planning efforts. A data source name DSN is the name for a pointer used by a client application to find and connect to a data source. This requirement is true even if both databases are accessed through the same DBMS. ODBC is a standard method of communicating with database servers. Click the System DSN tab.
|Date Added:||21 October 2010|
|File Size:||39.13 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
MicroStrategy documentation comments or suggestions Product enhancement suggestions.
Drivers and Connectors
It can be stored in different relational DBMSs. Within this folder, double-click the odbcad Although it is possible to use a non-certified driver, it is strongly recommended that you contact your database vendor to obtain a certified driver if the selected driver is not certified as valid. For MicroStrategy environments, a connection string is commonly provided by a database instance see Creating a database instance. MicroStrategy-branded drivers are installed in C: Importing data from a database by typing a query.
A connection string usually includes a DSN, as well as the user ID and password required to log in to the database server.
Configuring ODBC parameters with
A DSN is the name for a pointer that is used by a client application in this case MicroStrategy to find and connect to a database. A data source is the database accessed by a driver. However, the exact information varies depending on the type of database server.
You must log on to the machine using a Windows user account with administrative privileges. A data source name DSN is the name for a pointer used by a client application to find and connect to a data source.
Derived attributes Grouping attribute values in a dashboard Replacing attribute elements with an element group Grouping attribute elements with a calculation to create dobc new element Consolidating unused elements into a group Renaming, rearranging, and removing groups Limiting the Data Displayed in a Dashboard: You can connect directly to a variety of data sources during the data import process.
To import data from a database or with a custom query a Freeform scriptyou establish communication between MicroStrategy and your data source.
A list displays all the existing mjcrostrategy data sources and their associated drivers. If your data source is a type that does not support direct connections during the data import process, you must create a DSN data source name for your data source.
The information to enter varies depending on the database platform that you selected. A connection string stores the information required to connect to a database server.
Select the desired driver and click Continue. The exact information varies depending on the type of database server. Specifically, Mircostrategy connects to and transfers data to and from data sources within relational databases.
MicroStrategy ODBC Driver for MongoDB for Windows and Linux
Connecting to a Data Source to Import Data. After you create a DSN, you can connect to the data source and import your data.
For steps, see Building your first dashboard. Microstratefy requirement is true even if both databases are accessed through the same DBMS. For a list of data sources that require a DSN, see the online readme.
Enter the information in the appropriate fields to create a data source for the selected database driver. When setting up your MicroStrategy microstrxtegy, you must create a separate connection to the data warehouse and metadata repository.
ODBC is a standard method of communicating with database servers. Log in to the machine as an administrator.
Derived metrics Adding a derived metric to a dashboard Creating a derived metric by combining the values of metrics Creating a derived metric by selecting the aggregation function Creating a derived metric from an attribute Creating a new derived metric from scratch Changing the aggregation and subtotal behavior for a derived metric Providing statistical analysis from R analytics Editing or deleting derived metrics in a dashboard Creating an attribute based on existing objects: The Create Micrsotrategy Data Source dialog box opens.
Metadata can reside on the same server as the data warehouse or on a different server. Refer to your third-party documentation for the locations of ODBC support and driver files.