4. bat. Database requests from either the MicroStrategy metadata or the data warehouse; SQL generation; Analytical Engine processing (subtotals, cross tabulation, analytic functions). Cube details, projects, folders or events in the json request can be discovered by GUID or name, since MSCT will search the MicroStrategy metadata for the objects it needs to complete the request and find any missing data; Logging of all json request messages, updated versions of requests and status of requests that are executed;. Click Next. KB441192: Configuration Wizard fails when configuring the MicroStrategy Intelligence Server 10. ini file. Warehouse Catalog. x does not return full c… Metadata partition mapping is the mapping of partitions where the mapping of partitions is performed and maintained in the project metadata by the application, in this case, MicroStrategy. This GUID is created at the time of Metadata creation, and is unique to each metadata. x-10. Edit the line within the function that takes your login input. yaml. 2. The following steps describe how to delete Data Source Names (DSN) on a Unix machine in MicroStrategy 9. Select Display Managed Objects. From the Metadata drop-down list, specify the language in which to display the. In MicroStrategy Developer, the project source appears in the Folder List with an icon that varies depending on the type of connection it represents. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Click on OK to save the preferences. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The Object Telemetry dossier contains a great deal of subscripton information. for Superclass and search for 'ProjectsTransform'. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. 2 hours ago · Find centralized, trusted content and collaborate around the technologies you use most. With your own customized SQL statements, you can retrieve data from various data sources that are relational databases as long as the database instances for. Tap on the photo and go to the share icon in the bottom-left corner of the screen. Upgrade this test environment to validate the upgrade before using in your production environment. In order to track each delivery being process on the MicroStrategy Intelligence Server, users can track the entries on ‘. Createa new metadata shell. All schema objects, application objects, configuration objects, and project settings are stored in the MicroStrategy metadata. The metadata also stores the definitions of all objects created with MicroStrategy Developer and Web such as templates, reports, metrics, facts, and so on. This approach makes it easier for you to specify a flexible partitioning. Reload the login page. sh file when the home and install paths are differentFor steps to complete various configurations tasks with the Configuration Wizard, see the sections listed below: Once you reach the Summary page for a configuration, click Save. x metadatas that may prevent MicroStrategy 9. In the MicroStrategy 9. xml file in the "Program Files (x86)Common FilesMicroStrategy" folder on a machine with MicroStrategy Developer installed and create a backup of this file, and then edit it. community. You can access existing projects, applications, data imports, and metadata—as well as collaborate and share dossier and documents with colleagues—by connecting Workstation to an environment. MicroStrategy uses the credentials provided by the user to search for and validate the user in the LDAP directory. x who want to delete a server definition but do not have access to the Configuration Wizard GUI need to use the console mode. Right-click each service and select Stop. There is a dialog that includes fields to define how to create your metadata tables and where they should be stored. MicroStrategy actions (executions, session, etc. The password can be updated in the 'Connect to Metadata Repository' window as shown in the image below. Follow steps below to achieve this: Connect the the metadata DSN from DB Query Tool. The Python script below was written for that purpose. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. The following is a standalone Java example to check the different preferences level for a given user's session. Intelligence Server uses ODBC to connect to and communicate with all database servers in the system. microstrategy. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. On the Select Components page, select the check boxes for each Intelligence Server you want to upgrade. Additional flat files will be restored to a single directory. Click "Next". Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. It is a database where the whole “skeleton” of the tool is located. Launch the Configuration wizard and choose to create repositories then select metadata. 93K KB428983: The “List_Server_Config_Properties_Outline” script in MicroStrategy Command Manager 10. The project source stores the location of the. The Backup file can only be restored to environments with the same or higher version numbers. The third most common microstrategy developer skill is templates on 5. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. Metadata repository creation error: "Not enough privileges to create the metadata tables: Cannot find trusted procedural language 'plpgsql' installed. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. For information on how to create a Configuration Wizard response file, see. 23K. Sample folders named as below:. At this point, Developer will be able to use the 2-Tier Tutorial project. , Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the, metadata. Deleting a project from the MicroStrategy metadata can be achieved by using the Delete method of the IDSSDelete interface, supported by the DSSDataSource object. Enable users to interact with personalized chat for further product discovery. The update utility, like Desktop, can use an Intelligence Server on any supported operating system interchangeably. Load Metadata Object Telemetry, resume PA consumer and Healthcheck. From the Metadata drop-down list, specify the language in which to display the. Below are the new features exclusive to. In MicroStrategy 10. On the Metadata Connection page, enter the database password to access the MicroStrategy metadata. This tool will let you create a MicroStrategy metadata, configure an Intelligence Server,. Refer to your MicroStrategy contract and any accompanying contract documentation for descriptions of the different MicroStrategy license types. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformFirst of all, in order to connect, you will need to specify on the ZappySys JSON Driver the path of the local JSON file: Configure a JSON file connection with ODBC. This chapter addresses the processes necessary to. The solution is to add the following parameter in the metadata DSN: InitializationString=SET STANDARD_CONFORMING_STRINGS TO OFF if you. Start the Oracle Data Pump Export utility by using the expdp. If the metadata server instance is shutting down unexpectedly, very likely a core file will exist in the MicroStrategy folder structure. Find an event in a city near you. Hover over the Properties column and click Open Intelligence Server Administration Portal . The mapping of this column to the Platform Analytics project. The Metadata is where all the MicroStrategy definition is stored. Restoring with MicroStrategy Backup allows you to create mirror environments to test new projects, create disaster recovery environments, migrate current MicroStrategy deployment to the cloud, and more in a same or newer MicroStrategy version. Platform Analytics uniquely identifies metadata using a combination of the following fields: metadata_guid The GUID generated by MicroStrategy when the metadata is created. All articles. Unlike major releases and service packs, hotfixes and patches are differential updates of the product, meaning that only a few of the binaries are rebuilt and re-stamped with the hotfix or patch version. By default, the mstr database. To list out all the users, perform an outer join of the attribute based on the report template. In order to get the user names, the metadata table DSSMDOBJINFO should also be referred, follow the below steps to get the user names by querying against statistics table IS_SESSION_STATS and metadata table DSSMDOBJINFO:. <None>. MicroStrategy recommends that you always create the response file through the GUI mode of the Configuration Wizard. Oracle Data Pump Export is a utility for unloading data and metadata into a set of operating system files that are called a dump file set . mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. Named User Licenses, in which the number of users with access to specific. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Follow these steps in a 3-tier. The DSN should provide a unique description of the data, for example, Payroll_Project_Metadata or Payroll_Warehouse. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Check the Validate Server Certificate checkbox. In a report using application-level partitioning (MicroStrategy metadata or warehouse partitioning), the SQL submitted to the database depends on the results of "pre-queries" that identify the partitions which are relevant to the report filter. For each project requiring database authentication: Open Project Configuration. x warehouse and statistics tables. A Server Definition Object. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. The objects stored in the metadata are reusable. 4. On the next screen do not enter any password, just click Next. Watch this video on how to upgrade the Microstrategy 10. MicroStrategy supports multiple languages, whereas Cognos provides a customizable dashboard. 825. There's a reason we're at the top of the list. To list all enabled users is the everyone group, here is sample code: import java. The value of this key is the name of the DSN that MicroStrategy Intelligence Server uses to connect to the Metadata. It also stores other types of objects that allow you to access that information. It also demonstrates what the Patch Installer is and how to download it. Type your MicroStrategy login and password for the selected Intelligence Server and click Connect. I think you will have a lot more luck querying both the metadata and data within the objects using the newer Library Rest API. Beginning in MicroStrategy 2020, there is a new feature, Unified Quoting, that can help in all of the above situations. Generate SAML Configuration Files. In MicroStrategy Developer, choose File > New > Report. For steps to create a project source, see the. Report SQL, report data, and graphs can be executed and compared in Integrity Manager to help customers verify change success. The project source is a configuration object which represents a connection to a metadata repository. Open the key named 'LOCATION'. After establishing the new DSN, open Configuration Wizard to configure a new metadata. You are then prompted to select a History List script to create the History List tables, which is described in the To Select a History List Script section within this procedure. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. Each login mode specifies a particular mechanism or authority to be used for authentication. Select the group in which to create a user. 11. Copy the JDBC driver to a folder on the local Mac machine. That you can find from your metadata. Set up the Enterprise Manager. 4. User Name: Type the user name for the user that can connect to the data source. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. There is a dialog that includes fields to define how to create your metadata tables and where they should be stored. 1. Selected. Creating the Enterprise Manager project. x, the statistics tables and warehouse creation process is all handled by Configuration Wizard via the Create Metadata, History List and Enterprise Manager Repositories option. 3. These automatic aliases are not saved into the metadata and cannot be edited in MicroStrategy Developer. Configuring and Connecting Intelligence Server: After installing and activating MicroStrategy products, you must use the MicroStrategy Configuration Wizard to configure the MicroStrategy metadata repository, statistics tables, history list tables, Intelligence Server, and project sources. Enter the User Name and Password for the database. Next to All Users, click Create a new User . This is necessary in order to properly set the Windows registry keys. All schema objects, application objects, configuration objects, and project settings are stored in the MicroStrategy metadata. 5. Using MicroStrategy Enterprise Manager 9. Published: Dec 5, 2017. " I-Server configuration error: "The metadata you selected has not been upgraded to the current version of Intelligence Server. ImpalaThe failure point is indicated in the Enterprise Manager Dataload log, mstrmigration. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. The Search Options dialog box opens. The RDBMS for the metadata and warehouse do not need to be the same. Become a More Intelligent Enterprise. To import strings from the translation database back into the metadata, select the Import Translations option from the Metadata Repository page in the wizard. From the DSN drop-down list, select the DSN used to connect to the metadata repository. This chapter addresses the processes necessary to. Runs the client in Prompted mode. Select the Statistics & Enterprise Manager Repository check box and click Next. Creating schema objects is the primary task in MicroStrategy Architect. For information on how to create a Configuration Wizard response file, see. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. Open the exported excel file in Microsoft Excel and sort the results by column 'Enabled'. microstrategy. The Intelligence Server can now be pointed to any desired Metadata by using Configuration Wizard. Open Windows Services and start MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. x using the MicroStrategy Configuration Wizard. Select Export Translations as a translation action and click Next. Different properties of a MicroStrategy metadata object that can be listed using Command Manager 9. Host Bill Safer helps you learn how to find that hidden antique or collectible that just may add cash to your life at either a yard,. This KB article describes how on Windows and Linux systems. Platform Analytics consumer performs a standardization. Introduction The MicroStrategy Metadata (MD) is usually stored in an RDBMS and contains 3 sets of tables, namely: DSSMD* tables (this set of tables that start with. Select Project Sources and click Next. Steps to enable Scheduler: Open Developer. Prompts guide you through testing your ODBC. Connect the metadata update utility to a three-tier project source pointing to the UNIX Intelligence Server. x when configuring Intelligence Server via Configuration Wizard on Windows OS to point to a metadata in PostgreSQL 9. of objects that use that table. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. Click OK. If any problems arise see section on Troubleshooting. . From the DSN drop-down list, select the DSN used to connect to the metadata repository. With the default 300 seconds time-out setting, the end user will wait 120 seconds for the request time-out first, and then log. x does not return full c…What is MicroStrategy Metadata? The Metadata is where all the MicroStrategy definition is stored. These properties are not specified in the example script provided in Command Manager. During the PostgreSQL failover process (~45 seconds), all the requests will fail. Our top marks in this year’s new category follow 3+ years of #1 ratings in the now-retired Enterprise Analytics use case. While there is no location within the MicroStrategy products Graphical Unit Interface (GUI) where a user can determine the DSN being used by MicroStrategy Intelligence Server to connect to the metadata, it is possible to determine this information by looking in the registry. Select Display Managed Objects. It provides information about peak usage, most. From the DSN drop-down list, select the DSN used to connect to the metadata repository. *; This customization is provided as a convenience to. The 'Database Name' option allows the MicroStrategy Narrowcast administrator to create the Object Repository or the Subscription Book Repository in any of the databases that exist in the database server pointed to by the Data Source Name (DSN). From the DSN drop-down list, select the DSN used to connect to the metadata repository. There's a reason we're at the top of the list. There's a reason we're at the top of the list. Along with a backup of the metadata (MD), cache files can be restored on MicroStrategy Technical Support environments to troubleshoot report or document-specific issues. 0 - 10. Connecting to the metadata in DB Query tool shows all metadata tables, but no server definition can be found in the tables. The utility is found under Program. MicroStrategyTo Execute a Script from the Command Manager Graphical Interface. Verify the components you want to upgrade and click Next . In MicroStrategy Configuration wizard on Node-1, select the required DSN to connect to the metadata, as shown below: Select to create a new server definition or choose to use the existing server definition depending on the user's requirements, as shown below: Select the required projects to be loaded on startup, as shown below: Go through. If you type Y and press Enter, all information in the existing metadata repository is overwritten when the response file is executed at a later time. Ensure a metadata backup is taken prior to performing the below actions. MSTRPwd. Additional information regarding where the enterprise manager dataload is failing can be obtained by tracing the SQL during dataload. Click OK . Browse resources on demand or contact support directly. xml file located in the WEB-INF folder of the MicroStrategy Web installation directory. This mode asks the user for information about the location of various. However, when using the Configuration Wizard via the console administrators are not presented with a list of server definitions to choose from nor is. 1 Answer. x has the capability to authenticate and import users and groups from an existing LDAP Server into the MicroStrategy Metadata. Now available for feature release—MicroStrategy 10. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. paEtlConfig: Configuration for the Telemetry Store (Platform Analytics Consumer) to perform data processing. Platform Analytics provides an out-of-the-box dossier, Subscription Analysis, which can show statistical information and usage trends for subscriptions. The DSN and Login ID are provided based on the server configuration that you did previously. SQL queries in this document have been written for MicroStrategy 9. During the data load process, Enterprise Manager gathers metadata from projects, transfers metadata and statistics information from staging tables into the Enterprise Manager repository, and converts raw data into a. Click User Manager . Collect this file along with the DUMMYMDT DSSErrors. MSTRInstallPath: By default, on cloud environments it is /opt/mstr/MicroStrategy/. x, the statistics tables and warehouse creation process is all handled by Configuration Wizard via the Create Metadata, History List and Enterprise Manager Repositories option. cube files corresponding to the cube instance ID; The complete set of *. From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. Run MicroStrategy Backup. Organizations can use Unity Catalog to securely discover, access, monitor and collaborate on files, tables, ML models, notebooks and dashboards across any data platform or cloud. It also has a more powerful and easy to use. Enter the User Name and Password for the database. Click 'Browse. Open the Warehouse Catalog under the Schema menu. The quoting patterns used are [#0], ‘#0. Steps. The cache. Runs the client in Prompted mode. When setup successfully, it is recommended to follow. The information is stored in a proprietary format. This video walks users through the process of installing and running the mstrbak tool and how to use it. specifically focusing on statistics tables for the Enterprise Manager project, but the SQL used to query for the row count can be used on metadata and history list tables as well. MicroStrategy - Architecture. To support the use of a graphical user interface for MicroStrategy tools and installing MicroStrategy products on Red Hat Enterprise Linux 6, you must install the libstdc++-4. xml) and SAML configuration files ( MstrSamlConfig. Open the key named 'LOCATION'. x. x will not exclusively show the result with user A only but the result will show all users who belong to one of groups, as illustrated below. To specify a database instance, in the Intelligence Server Configuration Editor, select the General subcategory of the Server Definition category, and, in the Database Instance drop-down list, select the database instance to use for the History List. Find MicroStrategy’s public API in Postman and make your own copy (Fork). Select the table that was created in Step #1 (or the lookup table where the Last Month column was added). MicroStrategy metadata. Intelligence Everywhere. These objects are reusable for all products. a lookup table. Security Filters. Under Desktop/Developer browsing options, choose 'Display hidden objects'. MicroStrategy Tutorial Reporting. The Object Telemetry dossier contains a great deal of subscripton information. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. The MicroStrategy Intelligence Server 9. Click Show Advanced Options. ) check box to. In general, report creation in MicroStrategy is. log and contact MicroStrategy Technical Support in this case. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. It also stores other types of objects that. In a server (three-tier) environment, Developer metadata connectivity is established through the project source. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. Proactive. Follow steps below to find out all the Freeform SQL Reports in a project in MicroStrategy Developer: Go to Tools > Options > Enable "Show 'Contains' and 'Contained by ' tabs" as shown below: Click OK > Go to "Contains" tab and select Logical Table for "Contains any object of this type" as shown below: Then go to Object Types tab and select. The number of users assigned will be compared against the. A project includes a connection to a data warehouse (specified by a database instance), a metadata repository (which holds the schema and application. The example below shows the analysis for a MySQL Metadata: SQL to find the tables in a given schema SELECT table_name FROM information_schema. If you use Windows NT/2000 or later as. Windows NT authentication: The Windows NT SID. The Save dialog box opens. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. 0. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. Stop the MicroStrategy Intelligence Server 9. This KB article describes how on Windows and Linux systems. So, You still have the opportunity to move ahead in your career in MicroStrategy. Select the Statistics & Enterprise Manager Repository check box and click Next. Metadata Doctor (MD Doctor) is a utility that detects and fixes certain physical inconsistencies in MicroStrategy 9. For instructions on using. Create a database connection that points to the DSN. 0 and above. Go to the following path: HKEY_LOCAL_MACHINE\Software\Wow6432Node\MicroStrategy\Data Sources\CastorServer . This is the same information required for report cache restoration. From the drop-down menu, choose the database instance against which the user ID should be verified. MicroStrategy is usable in both forms, web and desktop tools, whereas Cognos is a web-based reporting tool mechanism. On the metadata Connection page, enter the database password to access the MicroStrategy metadata. MicroStrategy environments prior to MicroStrategy 2020 use MySQL. MicroStrategy also supports using API calls to retrieve catalog information. xml fragment below to enable SAML Authentication mode. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. For example, users might want to create a dossier that shows all dossiers and the component datasets on dossiers. yaml. The user can also write the SQL Trace to a new log file by selecting the option from the drop down. To search for managed objects only, select Display Managed Objects Only. Database Instance. The Full option exports a snapshot of each page and each individual visualization. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. x, MDMover should be used to migrate the Metadata database between database server. The DSN and Login ID are provided based on the server configuration that you did previously. These are discussed below. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. x, the correct results were shown even if a user activity metric was on the report. Micro Strategy also supports mobile BI. Mapping columns to metadata objects. The server definition is a set of settings stored in the metadata which contain information about configuration locations, governing settings, and other system and project specific settings. The password of a metadata user with full administrative privileges (Administrator is recommended). The Scan MD tool executes tests to detect inconsistencies in the metadata. Click tab 'Display' and select 'Results to grid' in the dropdown list. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from. MicroStrategy Intelligence Server connects to several databases (at a minimum, the data warehouse and the metadata repository) to do its work. Click the folder icon to browse to and select a response file. As a reporting and analysis platform, MicroStrategy allows developers to build reports and dashboards using an integrated development tool for all capabilities. This will return the 32 - digit GUID for the metadata. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. This tech note is an explanation of how to check the size (row count) of a table in MicroStrategy 9. To set up MicroStrategy Intelligence Server. ODBC drivers translate MicroStrategy Intelligence Server requests into commands that the DBMS understands. Following is the architecture of MicroStrategy: 1. For steps to create a project source, see the. An example of such a field is an object GUID. If MicroStrategy Platform Analytics was selected in a previous installation, it is automatically selected in Select Components. On the next screen do not enter any password, just click Next. You can choose to assign DNs to MicroStrategy users explicitly. This table is used for defining some property values which will be used in certain DS tables. Change the system locale to English-US or another supported locale by running the command: ocalectl set-locale LANG=en_US. Enter the User Name and Password for the database. Use the project duplication function to duplicate only the Tutorial project to your metadata. 2 Enterprise Architecture Enterprise Architecture consists of a two to eight node highly available cluster for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. Type: Attribute Qualification; Attribute: Report Job SQL PassType Y and click Enter to create History List tables with the same ODBC DSN information entered for your metadata tables. LU_. Parallel Upgrade or Metadata Migration with Platform Analytics. Your MicroStrategy Backup is restored on your new environment. MicroStrategy Workstation puts the full capabilities of your MicroStrategy environment just a couple of clicks away. You are now positioned to run the MicroStrategy Backup client. Users can do it from MicroStrategy Desktop > Project Configuration > Statistics > General. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. Right click the database and under “Tasks” choose “Backup”. So I want to create an. Select the Include extra fields in output (precision, city, country, etc. 4. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Below is a list of the tables contained in a MicroStrategy metadata repository. Choose the database and version, click Add driver, browse to the driver setup in step one and click OK as shown below: For all JDBC. LU_Groups. The steps to create the MicroStrategy metadata are: Open the MicroStrategy Configuration Wizard ( macfgwizw. KB441856: In MicroStrategy 10. For information on how to create a Configuration Wizard response file, see. The metadata repository is a collection of tables that contain the definitions for nearly all MicroStrategy objects including database logins, server definitions, database instances and connections, reports, metrics, facts, and so on. 1. xml) and SAML configuration files ( MstrSamlConfig. exe and click Enter. bigint(20) device_id . Launch Configuration Wizard and choose to create repositories then select metadata, you will see a page includes fields to define how to create your metadata tables and where they should be stored. This is a userStand out in a crowd. Thus, while the engine attribute role option makes it more convenient to use. Response File: The MicroStrategy Configuration Wizard response file that defines how to upgrade Intelligence Server components or migrate your History List from a file-based system to a database-based system. The project default level preferences are accessed by the Web server at connection time. yaml are backed up by this tool. List of metadata repositories tables for MicroStrategy 10. In order to create an ODBC DSN in MicroStrategy Intelligence Server Universal, it is possible to use the utility mstrconnectwiz.