![]() 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 |