With active data management, you’ll gain access to advanced. The Scan MD tool executes tests to detect inconsistencies in the metadata. Tap on the photo and go to the share icon in the bottom-left corner of the screen. You can map columns to: Managed object attributes and metrics: Managed objects are created on the fly and only exist in the context of Freeform SQL. This table is used to store. The value of this key is the name of the DSN that MicroStrategy Intelligence Server uses to connect to the Metadata. The metadata is a central repository, which stores all the objects used by it. The project default level preferences are accessed by the Web server at connection time. There's a reason we're at the top of the list. Option 2: Upgrade using MicroStrategy MDUpdateUtil Tool. <!--. x, select 'Preferences'. Follow these steps in a 3-tier. Click Show Advanced Options. Go to the 'Schema Objects' folder. Open the odbc. MSTRInstallPath: By default, on cloud environments it is /opt/mstr/MicroStrategy/. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. 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. x - 9. From the DSN drop-down list, select the DSN used to connect to the metadata repository. x and later. You do not have to define users for every project you create in a single metadata repository. For a progress Postgre driver: InitializationString=SET SEARCH_PATH to 'test'. <. bigint(20) connection_time. Launch the Configuration wizard and choose to create repositories then select metadata. Click Next. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingDatabricks took a pioneering approach with Unity Catalog by releasing the industry's only unified solution for data and AI governance across clouds and data platforms. and run another dependency search and so on. Click the folder icon to browse to and select a response file. paEtlConfig: Configuration for the Telemetry Store (Platform Analytics Consumer) to perform data processing. ForaLinuxinstallationandWindowscustominstallation,onlytheselectedcomponents' correspondingwarehouseisinstalledinMicroStrategyRepository. To search for managed objects only, select Display Managed Objects Only. This video shows basic steps of MD upgrade process. This chapter addresses the processes necessary to. 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:. Generate SAML Configuration Files. 5. Specifically, ODBC connects to. If in some extreme scenarios, the deadlock still occurs after the. This opens a Quick View of the Intelligent Cube information and usage statistics. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. 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. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. 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. So I want to create an. Note: MicroStrategy metadata will be created in the metadata2019 database in MySQL Server. In the bottom section, under Destination note the location of. Disable Unified Quoting Behavior in Query Optimization. Go to Database Instances > Authentication > Metadata. Last updated: Apr 12, 2019. Set Data Retrieval Mode to the setting Allow Native API at the report level: 2. The destination project must be of the same or greater metadata version as the source project. At this point, Developer will be able to use the 2-Tier Tutorial project. 4. Even if the Administrator user, re creates the folders with the same exact name, some of the out of the box objects might not work the same wayThis video will help you get started using the MicroStrategy REST API. MicroStrategy metadata is a repository that stores MicroStrategy object definitions and information about your data warehouse. The following steps generate the application metadata ( SPMetadata. Required permissions. KB442629: How to check topic data in Linux for MicroStrategy Platform Analytics 11. x, create a new report with the following definition: Attributes . The Object Telemetry dossier contains a great deal of subscripton information. The NCS Authentication dialog box opens. The project source is a configuration object which represents a connection to a metadata repository. x level and not on the cluster level. Connecting to the metadata in DB Query tool shows all metadata tables, but no server definition can be found in the tables. MicroStrategy actions (executions, session, etc. User Name: Enter the user name for the user that can connect to the data. A database connection supports connecting to data sources through the use of DSNs, as well as through DSNless. How to Update the Database User Password. Refer to the following MicroStrategy Knowledge. 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. MicroStrategy manages the mapping between the logical table and the physical tables. ODBC is a standard method of communicating with database servers. Also see additional information regarding Object GUIDs, please see the below Technotes: To check the Data Source Name (DSN) in use by the MicroStrategy Intelligence Server, users must perform the steps outlined below on the Intelligence Server machine: In MicroSoft Windows follow the menu options - Start > Run > type 'Regedit' and click on 'Enter' to open the registry editor. Before running ScanMD, a database backup of the metadata must be made. The Snowflake API call we used, for example, get Tables (null, null,. Attempting to access /MicroStrategy or /MicroStrategyMobile should redirect the user to first authenticate. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformScan MD. Collect this file along with the DUMMYMDT DSSErrors. In this document, you will find a database function “MSTRUID” used in multiple places. Related articles from the Community: Knowledge Base: Troubleshooting Metadata Upgrade Issues; Knowledge Base: How to upgrade. Verify the components you want to upgrade and click Next . The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. The Scan MD tool executes tests to detect inconsistencies in the metadata. When this utility is run with no arguments, it launches a graphical application for creating and managing DSNs. Change the password of the account. Click on OK to save the preferences. VIEWS view. MicroStrategyTo Execute a Script from the Command Manager Graphical Interface. 3 Metadata and Statistics tables implemented in Microsoft SQL Server. A database table used to uniquely identify attribute elements. Change the system locale to English-US or another supported locale by running the command: ocalectl set-locale LANG=en_US. Starting in MicroStrategy 2019 it is possible for administrators to track the state and usage of subscriptions through Platform Analytics. x products from functioning correctly. You can choose to assign DNs to MicroStrategy users explicitly. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. . To access the configuration page, you need admin privileges. To add or modify a given object translation, currently existing translation needs to be exported first. The DSN should provide a unique description of the data, for example, Payroll_Project_Metadata or Payroll_Warehouse. Create a DSN named "MS Access Shell" for Microsoft Access database with MicroStrategy Connectivity Wizard. The MicroStrategy REST API is an Application programming interface that lets developers quickly extract subsets of pre-processed data in JSON format. Forexample,ifyoudon’tC. Click Next. MicroStrategy manages the mapping between the logical table and the physical tables. Click Next. The following sample code shows how to search for "My Reports" folder inside MicroStrategy. Thus, while the engine attribute role option makes it more convenient to use. Choose the. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. ), it is the IP address of the machine from which the session was created. x metadatas that may prevent MicroStrategy 9. Select Configure Intelligence Server, and click Next. You can create the metadata repository in the database location of your choice. On the General tab, type the following information:The PAConsumerConfig file consists of the following parts: paParentConfig: Common configurations for the Telemetry Server (Kafka) and Telemetry Manager (Zookeeper) across TopicsGroups. x metadata Number of Views 2. I know which tables to query because I googled it and I found this blog entry, but I don't know. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. Click the folder icon to browse to and select a response file. They are the bridge between MicroStrategy reporting environment and data warehouse. From the Metadata drop-down list, specify the language in which to display the. On the Metadata Connection page, type the DSN, database login, and database password to access the MicroStrategy metadata. With a backup of the metadata in place, proposed fixes should only be accepted if the full impact of the fix is understood. Users of MicroStrategy Web can also connect to data sources using database connections. 3%. For instructions on using. Number of Views 2. The Import feature in MicroStrategy Developer looks in the metadata for metrics that match that name. If necessary, enter the database you wish to use for this Narrowcast Server. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. This KB article describes how on Windows and Linux systems. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x, MDMover should be used to migrate the Metadata database between database server. This Knowledge Base article describes a known issue in MicroStrategy 10. Runs the client in Prompted mode. The search will provide you a list. Required Status to Perform Action. The TABLES and TABLE_OPTIONS views also contain high-level information about views. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. This table is used to store binary data like image/video. 54K KB35860: MicroStrategy Object Manager is unable to migrate subscriptions from one environment to another. Enter the connection information for the SQL Server and click Finish. The metadata repository is a collection of tables that contain the definitions for nearly all MicroStrategy objects including database logins, server definitions, database instances. Additional information regarding where the enterprise manager dataload is failing can be obtained by tracing the SQL during dataload. 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. a. Platform Analytics is a telemetry tool that supports telemetry capture from multiple MicroStrategy deployments simultaneously. The following information assists you in setting up ODBC between Intelligence Server and your metadata database and data warehouse. Choose MicroStrategy ODBC Driver for Microsoft SQL Server. Click Next. Open the key named 'LOCATION'. Open the MicroStrategy Configuration Wizard. NOTE: For Windows, refer to the MicroStrategy KB article - KB428146: How to determine which DSN is being used by the Intelligence Server on a 64-bit Windows machine. So I want to create an embedded query to know which last objects were modified by an user and that sort of things. 93K KB428983: The “List_Server_Config_Properties_Outline” script in MicroStrategy Command Manager 10. The DSN and Login ID are provided based on the server configuration that you did previously. Next to All Users, click Create a new User . Use the MicroStrategy Metadata Update Utility to recover the MicroStrategy System Prompt object. MicroStrategy - Architecture. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. The utility is found under Program. 0 - 10. Follow steps below to achieve this: Connect the the metadata DSN from DB Query Tool. 신뢰할 수 있는 AI를 빠르게 확장시키세요. Note: MicroStrategy metadata will be created in the metadata2019 database in MySQL Server. Use the project duplication function to duplicate only the Tutorial project to your metadata. Create an upgrade test environment by duplicating your production environment and production metadata. Visit the data visualization and data dashboard galleries for inspiration. x. In the Platform Analytics directory, located in C:\Program Files (x86)\MicroStrategy\Platform Analytics\, open the bin folder. Manage and Verify Your Licenses. 4-XX. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. 842 views. You link this imported data to define attributes and metrics. If you are in compliance, a message appears. If you're looking for MicroStrategy Interview Questions for Experienced or Freshers, you are in the right place. 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. If a matching user is found, the project. 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. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. import com. Double-click a project source name (PSN). x. Selected. This mode asks the user for information about the location of various. After you find the microstrategy. MicroStrategy remains ranked #1 in Portfolio Capabilities in the 2023 edition of the BARC Score. xml file located in the WEB-INF folder of the MicroStrategy Web installation directory. 825. Select the database instance. The mapping of this column to the Platform Analytics project. MicroStrategy Integrity Manager is an automated report comparison tool. , Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the, metadata. for Superclass and search for 'ProjectsTransform'. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. 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. Starting Oracle Data Pump Export. The following steps generate the application metadata ( SPMetadata. By default, this file is located in C:Program FilesCommon FilesMicroStrategy as indicated in Step 1 e) If users would like to transfer the file to another machine or send it via e-mail, they should make sure to compress the file with WinZip or a similar tool as. Definition. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. Object Layer. Open the exported excel file in Microsoft Excel and sort the results by column 'Enabled'. Proactive. To view this field, the Intelligent Cube must be published at least once. 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. 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 . Go to the component 'Database Classes' and dispatcher 'SQL Trace'. This project contains out-of-the-box reports to demonstrate the various features of MicroStrategy ONE. Always upgrade the Intelligence Server before upgrading client applications such as MicroStrategy Web, Mobile, Library, and Developer. Deleting a project from the MicroStrategy metadata can be achieved by using the Delete method of the IDSSDelete interface, supported by the DSSDataSource object. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. 1. Once a security filter is created for. log file. In some cases, users may want to see the direct object dependencies of objects in the MicroStrategy metadata. User Name: Enter the user name for the user that can connect to the data source. From the DSN drop-down list, select the DSN for your statistics and Enterprise Manager repositories. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend >and integrate the MicroStrategy business intelligence functionality into other applications. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. From the DSN drop-down list, select the DSN used to connect to the metadata repository. All schema objects, application objects, configuration objects, and project settings are stored in the MicroStrategy metadata. For details for creating a backup of your metadata, see KB441138. The number of users assigned will be compared against the. Note: This setting has to be check for every MicroStrategy project logging statistics. A Project Source could be defined as a direct or indirect access point to the metadata. <None>. This is a userStand out in a crowd. Createa new metadata shell. 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. On the Summary page, review the upgrade choices and click. To set up MicroStrategy Intelligence Server. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 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:. Usually assigned by administrators, security filters control what warehouse data users can see within MicroStrategy. MicroStrategy Tutorial Reporting. Under some circumstances, certain unused managed objects are not deleted after performing ‘delete unused managed objects’ in MicroStrategy Developer 9. So, You still have the opportunity to move ahead in your career in MicroStrategy. Change the system language for the machine. On the Freeform Sources tab, select Create Query Builder report. To query the. Under Collections, click on the the “…” next to. Click OK . /mstrcfgwiz. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. The MicroStrategy metadata contains all the information needed for a MicroStrategy project to function, including data warehouse connection information, project settings and MicroStrategy object definitions. After you install an ODBC driver, you can define one or more data sources for it. The Scan MD tool searches for logical errors and fixes them within the platform object structure. To help you determine the time limit, use Enterprise Manager to find out the average and maximum report execution times for your system. Creating schema objects is the primary task in MicroStrategy Architect. The third most common microstrategy developer skill is templates on 5. LU_Users. MicroStrategy recommends that you always create the response file through the GUI mode of the Configuration Wizard. Database Instance. The queries can be modified syntactically for other databases. This attribute is not directly related to the 'Report' attribute so that if 'Report' and 'Schedule' are placed on a report template by themselves, they will not be joined in a meaningful way. It supports for all new and updated features in MicroStrategy. 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. Select the group in which to create a user. In the Source drop-down list, select Google. However, when adding some arguments, as indicated in this document, the same utility can be used to. yaml. *; This customization is provided as a convenience to. KB441192: Configuration Wizard fails when configuring the MicroStrategy Intelligence Server 10. Schema objects are logical objects that relate application. metadata_connection_string The connection string Intelligence server uses to connect to the metadata database. The DSN and Login ID are provided based on the server configuration that you did previously. x and newer, the default maximum number of concurrent connections that MicroStrategy Intelligence Server can make to the metadata, is 0x0fffffff. The update utility, like Desktop, can use an Intelligence Server on any supported operating system interchangeably. This is a Microsoft Access file called "EM_Proj_MD. Run the file mstr-repo-ondemand-dba-operations. As a reporting and analysis platform, MicroStrategy allows developers to build reports and dashboards using an integrated development tool for all capabilities. There's a reason we're at the top of the list. x to 9. microstrategy. Set Encryption Method = “1-SSL”. cube files corresponding to the cube instance ID; The complete set of *. Open the Warehouse Catalog under the Schema menu. In the Navigation pane, click Users and Groups. 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. x to PostgreSQL 9. The Save dialog box opens. Locate the web. 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. To access documentation resources on Windows. For a Linux DSN. Overview of Freeform SQL reports. In MicroStrategy, a security filter is a filter object that is used to narrow down the result set that users or groups can view when they execute reports or browse elements. However, in the cases where there is an existing MicroStrategy user structure and fewer users, a simpler strategy would be to link. These properties are not specified in the example script provided in Command Manager. Define the statistics and enterprise warehouse database. /mstrcfgwiz. 2. a relationship table. MSTRPwd. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Connect the metadata update utility to a three-tier project source pointing to the UNIX Intelligence Server. Following is the architecture of MicroStrategy: 1. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. This document describes how to configure MicroStrategy ASP Web to support SAML using Shibboleth Service Provider for IIS. You are now positioned to run the MicroStrategy Backup client. Select Metadata, History List and Statistics Repository Tables and click Next. In warehouse partition mapping, a table in the warehouse associates attribute elements with the table names of the individual partitions. Load Metadata Object Telemetry, resume PA consumer and Healthcheck. Configure Metadata Connection. Click Configure Intelligence Server. ImpalaThe failure point is indicated in the Enterprise Manager Dataload log, mstrmigration. 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. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from. UTF-8 . Select the objects to be modified. x. Ensure a metadata backup is taken prior to performing the below actions. Learn how to use an external REST client to run MSTR related REST requests. Find the folder 'Version Update History' and collect a screenshot of showing all the entries within that folder. Learn more about Collectives. For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. ; In the Project Source Name field, type a name for the project source. Select Export Translations as a translation action and click Next. The information is stored in a proprietary format. Follow these guidelines when you search by a. DSN: Select the data source name for your metadata repository. This KB article describes how on Windows and Linux systems. 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. " I-Server configuration error: "The metadata you selected has not been upgraded to the current version of Intelligence Server. In MicroStrategy Developer, choose File > New > Report. x, the correct results were shown even if a user activity metric was on the report. /mstrcfgwiz. Security Filters. x and 10. TO LEARN MORE: To Learn More about Enterprise Manager, please see Chapter 17 in the System Administrator's Guide. Enumeration; import. The preferences are stored in memory. Designed with automatic alerts, Insights is powered by machine learning (ML) models to analyze data behind the scenes and surface key trends, outliers, or anomalies. Published: Dec 5, 2017. And by this, I mean all objects: Attributes, tables, names, users, states, object information, etc. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. MicroStrategy metadata is a repository that stores MicroStrategy object definitions and information about your data warehouse. The basic information for subscriptions such as ID, name, schedule, recipient, etc. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. Create a database connection that points to the DSN. comCreate a DSN using the steps below: Launch the MicroStrategy Connectivity Wizard. This video walks users through the process of installing and running the mstrbak tool and how to use it. Operations cannot be performed from a newer metadata to an older one. For more information, see KB43491. MicroStrategy supports multiple languages, whereas Cognos provides a customizable dashboard. x and 11. The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one), Intelligence Server (tier two), and Developer (tier three). 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. In Command Manager, the list of enabled users in the metadata is returned by the following command: LIST LOGIN, ENABLED FOR USERS IN GROUP "Everyone"; This can also be done using MicroStrategy Web SDK 10. The recipient_id column is recorded along with job executions in MicroStrategy. Go to the following path: HKEY_LOCAL_MACHINE\Software\Wow6432Node\MicroStrategy\Data Sources\CastorServer . From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. 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. Right-click the event and select Trigger . The Full option exports a snapshot of each page and each individual visualization. Going to the basics, below is the basic outline of the MicroStrategy. 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. x? In some cases it may be helpful or necessary to examine the raw entries for subscriptions that are stored in the MicroStrategy Metadata in order to determine if an issue is being caused by erroneous entries in the Metadata tables. Select the group in which to create a user. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. The information is stored in a proprietary format within a relational database. In order to track each delivery being process on the MicroStrategy Intelligence Server, users can track the entries on ‘. x-10. Find the folder 'Version Update History' and collect a screenshot of showing all the entries within that folder. Once a table is moved from left to right, its definition is saved in. Ensure telemetry service is enabled by running below query in Command Manager: LIST ALL PROPERTIES FOR SERVER CONFIGURATION;Click Next. Select the object that will replace the dependee, the object type must be the same. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. Go to Project access, to give Public/Guest basic access to the project. The RDBMS for the metadata and warehouse do not need to be the same.