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.

Connect

Access live data in Cognos and TM1 and hundreds of other data source types on-premise or cloud

Prepare

Create business-friendly, unified, extensible and reusable virtual views and data services

Publish

Consume cached datasets in real-time using Tableau, Power BI, and many other tools and applications

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

Real-Time
Data Access

Access, query, and consume your Cognos BI/Analytics, and TM1/Planning Analytics data live, and view changes in real-time – without having to move it physically.

Any Visualization, BI and Analytics Tools

Make Cognos and TM1 data instantly available and analyze it using your favorite visualization, BI, and analytic tools such as Tableau, Power BI, Qlik, and more.

Self-Service
Web Interface

Combine data from any Cognos Package, TM1 Cube or Cube View into reusable, business-friendly virtual datasets using a modern drag-and-drop interface.

Accurate Data Aggregation

Get accurate aggregated and summary data through the live query engine and leverage the existing custom aggregation or external rollup calculations already defined in your Cognos and TM1 models.

AI-driven Automatic Data Caching

Leverage fast query optimization and scalable cluster in-memory caching driven by machine learning and customizable rules tailored for your data, applications, and users.

Cross-database Joins and Operations

Blend Cognos and TM1 data with hundreds of different data sources and types without the cost and overhead of physical data consolidation.

Custom Filters and Calculations

Create custom filters and advanced calculations across disparate data sources to perform complex data manipulation and analysis.

Cognos and TM1 Function Translation

Supports all standard and user-defined SQL functions,  including date/time, mathematical, and string manipulation.

Buit-in Data Science Acceleration

Fast track advanced analytics and R/Python models into production with business data using built-in and integrated open data science platforms.

Share and Manage Virtual Data Sets

Share and manage trusted virtual data sets from disparate sources and systems for an accurate and single version of the truth.

Seamless Security and Governance

Inherit the existing user data security settings defined in your Cognos BI/Analytics and TM1/Planning Analytics environment, and not lose control to your data.

Unprecedented Flexibility

Create direct access to data views and file extracts using a multidimensional graphical interface – no need for scripting or complex logic for dealing with hierarchies.

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.

Connect

Access live data in Cognos and TM1 and hundreds of other data source types on-premise or cloud

Prepare

Create business-friendly, unified, extensible and reusable virtual views and data services

Publish

Consume cached datasets in real-time using Tableau, Power BI, and many other tools and applications

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

Real-Time
Data Access

Access, query, and consume your Cognos BI/Analytics, and TM1/Planning Analytics data live, and view changes in real-time – without having to move it physically.

Any Visualization, BI and Analytics Tools

Make Cognos and TM1 data instantly available and analyze it using your favorite visualization, BI, and analytic tools such as Tableau, Power BI, Qlik, and more.

Self-Service
Web Interface

Combine data from any Cognos Package, TM1 Cube or Cube View into reusable, business-friendly virtual datasets using a modern drag-and-drop interface.

Accurate Data Aggregation

Get accurate aggregated and summary data through the live query engine and leverage the existing custom aggregation or external rollup calculations already defined in your Cognos and TM1 models.

AI-driven Automatic Data Caching

Leverage fast query optimization and scalable cluster in-memory caching driven by machine learning and customizable rules tailored for your data, applications, and users.

Cross-database Joins and Operations

Blend Cognos and TM1 data with hundreds of different data sources and types without the cost and overhead of physical data consolidation.

Custom Filters and Calculations

Create custom filters and advanced calculations across disparate data sources to perform complex data manipulation and analysis.

Cognos and TM1 Function Translation

Supports all standard and user-defined SQL functions,  including date/time, mathematical, and string manipulation.

Buit-in Data Science Acceleration

Fast track advanced analytics and R/Python models into production with business data using built-in and integrated open data science platforms.

Share and Manage Virtual Data Sets

Share and manage trusted virtual data sets from disparate sources and systems for an accurate and single version of the truth.

Seamless Security and Governance

Inherit the existing user data security settings defined in your Cognos BI/Analytics and TM1/Planning Analytics environment, and not lose control to your data.

Unprecedented Flexibility

Create direct access to data views and file extracts using a multidimensional graphical interface – no need for scripting or complex logic for dealing with hierarchies.

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
Job Function
Country

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

IBM Product Owned
Analytic Tool Currently in Use
Briefly describe your requirement
0 /
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right