Connecting Tableau and Power BI to Cognos BI and TM1

Connecting Tableau and Power BI to Cognos BI and TM1

Connecting Tableau and Power BI to Cognos BI and TM1

SEE IT IN ACTION

Real-Time Access to Your Cognos and TM1 Data

DataClarity employs powerful data virtualization capabilities that empower users with easy self-service access to Cognos Packages, TM1 Cubes, and TM1 Cube Views to make live data instantly available in Tableau, Power BI, and many others.

How Data Virtualization Works? 

Cognos packages modeled in Framework Manager, and TM1 cubes and cube views modeled in Architect and Perspectives are best connected to third party BI tools using data virtualization.   Users can also discover, profile, prepare, and manage trusted virtual datasets sourced from multiple packages, cubes, cube views, and hundreds of other data source types.    Data access performance is maximized with smart query optimization and in-memory caching driven by machine learning and user customizable rules while Cognos and TM1 servers are offloaded to avoid degradation of production workloads.

Key Benefits

  • Real-time access to any data source from anywhere without movement or replication including raw and modeled data from files, databases, cubes, cloud apps, and big data
  • Users can discover, profile, prepare, create, and manage trusted virtual datasets using disparate data from multiple systems, locations, and technologies without the cost and overhead of physical data consolidation
  • Make your data instantly available for consumption in any application, business intelligence or analytics tool, such as Tableau, Power BI, DataClarity, and many more
  • Seamlessly operationalize both built-in and pre-curated R/Python machine learning and AI models deployed on third party platforms requiring real-time production data
  • Maximize performance with smart query optimization and in-memory caching driven by machine learning and user customizable rules
  • On-Premise, Cloud, Hybrid, SaaS, AWS, Azure, and Google deployable
  • Low TCO, high ROI, and rapid implementation and adoption

Key Capabilities

DataClarity Data Virtualization Architecture

Connect to Hundreds of Data Sources

DataClarity includes JDBC drivers for the following data source types:

  • Amazon Athena
  • Amazon Aurora (MySQL)
  • Amazon Aurora (PostgreSQL)
  • Amazon Redshift
  • Apache Derby
  • Apache Hive
  • Azure SQL Database
  • Azure SQL Data Warehouse
  • EXASOL
  • FirebirdSQL
  • Google Cloud SQL (MySQL)
  • Google Cloud SQL (PostgreSQL)
  • HyperSQL
  • IBM Cognos TM1 / IBM Planning Analytics cubes
  • IBM Cognos TM1 / IBM Planning Analytics cube views
  • IBM Cognos packages:

    • Relational package
    • DMR package
    • PowerCube
    • Dynamic Cube
    • TM1/PA cube
  • IBM DB2
  • Informix
  • MariaDB
  • Microsoft SQL Server
  • Microsoft SQL Server Analysis Services
  • MySQL
  • Oracle
  • PostgreSQL
  • Spreadsheets (xlsx, .xls) and other data files (.csv, .tsv, .txt and .sav)

 DataClarity may connect to the data sources below using vendor and third-party JDBC drivers:

  • ActCRM
  • Active Directory
  • Amazon DynamoDB
  • Apache HBase
  • Authorize.Net
  • Azure CosmosDB
  • Azure Data Management
  • Azure Table Storage
  • Basecamp
  • Bing Ads
  • Bing Search
  • Box
  • Cassandra
  • Couchbase
  • DoubleClick CM
  • DoubleClick FP
  • EBay
  • Elasticsearch
  • Eloqua
  • Email
  • ETrade
  • Exact Online
  • Excel Online
  • Excel Services
  • Exchange
  • Facebook
  • Financial Edge NX
  • Freshbooks
  • FTP
  • Gmail
  • Google AdWords
  • Google Analytics
  • Google BigQuery
  • Google Calendar
  • Google Contacts
  • Google Directory
  • Google Drive
  • Google Search
  • Google Spreadsheets
  • Highrise
  • HPCC
  • HubSpot
  • IBM Cloudant
  • JIRA
  • JSON
  • Kintone
  • LDAP
  • LinkedIn
  • Magento
  • MailChimp
  • Marketo
  • Microsoft Access
  • Microsoft Dynamics 365 Business Central
  • Microsoft Dynamics 365 Finance and Operations
  • Microsoft Dynamics 365 Sales
  • Mircosoft Dynamics CRM
  • Microsoft Dynamics GP
  • Microsoft Dynamics NAV
  • MongoDB
  • MSProject
  • Netezza
  • NetSuite
  • OData
  • Office365
  • OFX
  • Open Exchange Rates
  • Oracle SalesCloud
  • PayPal
  • QB POS
  • Quandl
  • QuickBooks
  • QuickBooks Online
  • Reckon
  • Redis
  • REST
  • RSS
  • Sage 50 UK
  • Sage Intacct
  • Salesforce
  • Salesforce Chatter
  • Salesforce Einstein Analytics
  • Salesforce Marketing Cloud
  • SAP Business One
  • SAP ERP
  • SAP Hybris C4C
  • SendGrid
  • ServiceNow
  • SharePoint
  • Shopify
  • Slack
  • Smartsheet
  • Snappy Data
  • SparkSQL
  • Splunk
  • Square
  • Stripe
  • Sugar CRM
  • SuiteCRM
  • SurveyMonkey
  • Teradata
  • Twilio
  • Twitter
  • xBase
  • Xero
  • XML
  • YouTube Analytics
  • YouTube Data
  • Zendesk
  • Zoho CRM

Real-Time Access to Your Cognos and TM1 Data

DataClarity employs powerful data virtualization capabilities that empower users with easy self-service access to Cognos Packages, TM1 Cubes, and TM1 Cube Views to make live data instantly available in Tableau, Power BI, and many others.

How Data Virtualization Works?

Cognos packages modeled in Framework Manager, and TM1 cubes and cube views modeled in Architect and Perspectives are best connected to third party BI tools using data virtualization. Users can also discover, profile, prepare, and manage trusted virtual datasets sourced from multiple packages, cubes, cube views, and hundreds of other data source types. Data access performance is maximized with smart query optimization and in-memory caching driven by machine learning and user customizable rules while Cognos and TM1 servers are offloaded to avoid degradation of production workloads.

Key Benefits

  • Real-time access to any data source from anywhere without movement or replication including raw and modeled data from files, databases, cubes, cloud apps, and big data
  • Users can discover, profile, prepare, create, and manage trusted virtual datasets using disparate data from multiple systems, locations, and technologies without the cost and overhead of physical data consolidation
  • Make your data instantly available for consumption in any application, business intelligence or analytics tool, such as Tableau, Power BI, DataClarity, and many more
  • Seamlessly operationalize both built-in and pre-curated R/Python machine learning and AI models deployed on third party platforms requiring real-time production data
  • Maximize performance with smart query optimization and in-memory caching driven by machine learning and user customizable rules
  • On-Premise, Cloud, Hybrid, SaaS, AWS, Azure, and Google deployable
  • Low TCO, high ROI, and rapid implementation and adoption

Key Capabilities

DataClarity Data Virtualization Architecture

Connect to Hundreds of Data Sources

DataClarity includes JDBC drivers for the following data source types:

  • Amazon Athena
  • Amazon Aurora (MySQL)
  • Amazon Aurora (PostgreSQL)
  • Amazon Redshift
  • Apache Derby
  • Apache Hive
  • Azure SQL Database
  • Azure SQL Data Warehouse
  • EXASOL
  • FirebirdSQL
  • Google Cloud SQL (MySQL)
  • Google Cloud SQL (PostgreSQL)
  • HyperSQL
  • IBM Cognos TM1 / IBM Planning Analytics cubes
  • IBM Cognos TM1 / IBM Planning Analytics cube views
  • IBM Cognos packages:

    • Relational package
    • DMR package
    • PowerCube
    • Dynamic Cube
    • TM1/PA cube
  • IBM DB2
  • Informix
  • MariaDB
  • Microsoft SQL Server
  • Microsoft SQL Server Analysis Services
  • MySQL
  • Oracle
  • PostgreSQL
  • Spreadsheets (xlsx, .xls) and other data files (.csv, .tsv, .txt and .sav)

 DataClarity may connect to the data sources below using vendor and third-party JDBC drivers:

  • ActCRM
  • Active Directory
  • Amazon DynamoDB
  • Apache HBase
  • Authorize.Net
  • Azure CosmosDB
  • Azure Data Management
  • Azure Table Storage
  • Basecamp
  • Bing Ads
  • Bing Search
  • Box
  • Cassandra
  • Couchbase
  • DoubleClick CM
  • DoubleClick FP
  • EBay
  • Elasticsearch
  • Eloqua
  • Email
  • ETrade
  • Exact Online
  • Excel Online
  • Excel Services
  • Exchange
  • Facebook
  • Financial Edge NX
  • Freshbooks
  • FTP
  • Gmail
  • Google AdWords
  • Google Analytics
  • Google BigQuery
  • Google Calendar
  • Google Contacts
  • Google Directory
  • Google Drive
  • Google Search
  • Google Spreadsheets
  • Highrise
  • HPCC
  • HubSpot
  • IBM Cloudant
  • JIRA
  • JSON
  • Kintone
  • LDAP
  • LinkedIn
  • Magento
  • MailChimp
  • Marketo
  • Microsoft Access
  • Microsoft Dynamics 365 Business Central
  • Microsoft Dynamics 365 Finance and Operations
  • Microsoft Dynamics 365 Sales
  • Mircosoft Dynamics CRM
  • Microsoft Dynamics GP
  • Microsoft Dynamics NAV
  • MongoDB
  • MSProject
  • Netezza
  • NetSuite
  • OData
  • Office365
  • OFX
  • Open Exchange Rates
  • Oracle SalesCloud
  • PayPal
  • QB POS
  • Quandl
  • QuickBooks
  • QuickBooks Online
  • Reckon
  • Redis
  • REST
  • RSS
  • Sage 50 UK
  • Sage Intacct
  • Salesforce
  • Salesforce Chatter
  • Salesforce Einstein Analytics
  • Salesforce Marketing Cloud
  • SAP Business One
  • SAP ERP
  • SAP Hybris C4C
  • SendGrid
  • ServiceNow
  • SharePoint
  • Shopify
  • Slack
  • Smartsheet
  • Snappy Data
  • SparkSQL
  • Splunk
  • Square
  • Stripe
  • Sugar CRM
  • SuiteCRM
  • SurveyMonkey
  • Teradata
  • Twilio
  • Twitter
  • xBase
  • Xero
  • XML
  • YouTube Analytics
  • YouTube Data
  • Zendesk
  • Zoho CRM

Contact us

If you want more information about our products and solutions simply fill out the form

[[[["field14","contains","@gmail"],["field14","contains","@yahoo"],["field14","contains","@hotmail"],["field14","contains","@googlemail"],["field14","contains","@outlook"],["field14","contains","@aol"],["field14","contains","@aim"],["field14","contains","@yandex"],["field14","contains","@inbox"],["field14","contains","@protonmail"],["field14","contains","@zoho"],["field14","contains","@icloud"],["field14","contains","@mail"],["field14","contains","@gmx"],["field14","contains","@fastmail"],["field14","contains","@hush"]],[["show_fields","field15"],["hide_fields","field21"]],"or"]]
1
Please complete all fields
First Name
no-icon
Last Name
no-icon
Company
no-icon

Please provide a valid email address from your business or organization. Thank you.

Briefly describe your requirement
0 /
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right