Password: The password of your Oracle Cloud service account.User: The username of your Oracle Cloud service account.Typically, this will be the URL of your Oracle Cloud service. Url: The URL of the account that you want to connect to.The following connection properties are required to connect to Oracle SCM data. Information for connecting to Oracle SCM follows, along with different instructions for configuring a DSN in Windows and Linux environments (the ODBC Driver for Oracle SCM must be installed on the machine hosting the connected MicroStrategy Intelligence Server). With built-in dynamic metadata querying, you can visualize and analyze Oracle SCM data using native MicroStrategy data types.Ĭonnect to Oracle SCM as an ODBC Data Source When you issue complex SQL queries from MicroStrategy to Oracle SCM, the driver pushes supported SQL operations, like filters and aggregations, directly to Oracle SCM and utilizes the embedded SQL engine to process unsupported operations (often SQL functions and JOIN operations) client-side. The CData ODBC Driver offers unmatched performance for interacting with live Oracle SCM data in MicroStrategy due to optimized data processing built into the driver. In this article, we walk through creating a database instance for Oracle SCM in MicroStrategy Developer and creating a Warehouse Catalog based on Oracle SCM data. When you pair MicroStrategy with the CData ODBC Driver for Oracle SCM, you gain database-like access to live Oracle SCM data from MicroStrategy, expanding your reporting and analytics capabilities. MicroStrategy is an analytics and mobility platform that enables data-driven innovation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |