CData Software - Knowledge Base
Recent Articles
-
Connecting Moonlit Workflow with Google Analytics via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Analytics in real time.
-
Visualize Reckon in Tableau
The CData ODBC driver for Reckon enables you integrate Reckon into Tableau dashboards.
-
Microsoft Dataverse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft Dataverse facts in real time.
-
Create Power BI Reports on Real-Time Coinbase
Use the CData ODBC Driver for Coinbase to visualize Coinbase in Power BI Desktop.
-
Connect to SAP Hybris C4C from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Hybris C4C to connect to SAP Hybris C4C from Web applications running on WebLogic.
-
Automated Continuous Sage 300 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sage 300 replication to Snowflake.
-
Automated Continuous SAP HANA XS Advanced Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to IBM DB2.
-
How to Access Jira Assets Using Entity Framework
This article shows how to access Jira Assets using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Dropbox Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dropbox facts in real time.
-
Build Semantic Layer Views for Outreach.io in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Outreach.io.
-
How to import SAP HANA XS Advanced into Apache Solr
Use the CData Software JDBC Driver for SAP HANA XS Advanced in Data Import Handler and create an automated import of SAP HANA XS Advanced to Apache Solr Enterprise Search platform.
-
Build Oracle-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Database.
-
Connect to CSV in Aqua Data Studio
Access CSV/TSV Files from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Impala-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Impala.
-
How to Connect to Live NetSuite in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your NetSuite CRM & ERP for you.
-
Migrating data from Sage 300 to Google BigQuery using CData SSIS Components.
Easily push Sage 300 to Google BigQuery using the CData SSIS Tasks for Sage 300 and Google BigQuery.
-
Connect and Query Live Azure Synapse Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse into Databricks
-
A PostgreSQL Interface for Twitter using the CData ODBC Driver
Use the SQL Gateway and Twitter ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live SAP Ariba Procurement into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Ariba Procurement and integrate live SAP Ariba Procurement into apps built in Microsoft Power Apps.
-
Redis Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Redis through CData Connect AI using different applications and tools.
-
Query Freshdesk using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Freshdesk entities in PHP by modeling them as objects.
-
How to Build an ETL App for LDAP Objects in Python with CData
Create ETL applications and real-time data pipelines for LDAP in Python with petl.
-
Edit and Search HubSpot External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of HubSpot to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create HubSpot objects that you can access from apps and the dashboard.
-
Connect to SQL Server in Ruby
Connect to Microsoft SQL Server in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Redis from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Redis for you.
-
Migrating data from Twitter Ads to Snowflake using CData SSIS Components.
Easily push Twitter Ads to Snowflake using the CData SSIS Tasks for Twitter Ads and Snowflake.
-
Connect to SAP Ariba Source in SpagoBI
Create reports featuring live SAP Ariba Source in SpagoBI Studio. Host SAP Ariba Source reports on SpagoBI Server.
-
Create Data Visualizations in Cognos BI with Google Calendar
Access Google Calendar as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Snapchat Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to AlloyDB.
-
Getting Started with the CData SSIS Components for Jira
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jira.
-
A PostgreSQL Interface for Adobe Target using the CData ODBC Driver
Use the SQL Gateway and Adobe Target ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Excel Add-In for Workday
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Workday.
-
Publish Reports with SuiteCRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SuiteCRM.
-
Getting Started with the CData Excel Add-In for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for IBM Cloud Object Storage.
-
Connect to Klaviyo in the Denodo Platform
Use CData driver technologies to create a virtual data source for Klaviyo in the Denodo Virtual DataPort Administrator.
-
Migrating data from SAP Concur to Databricks using CData SSIS Components.
Easily push SAP Concur to Databricks using the CData SSIS Tasks for SAP Concur and Databricks.
-
Automate Shippo Replication to Couchbase
Use CData Sync to Customize and automate Shippo replication to Couchbase.
-
Object-Relational Mapping (ORM) with GraphQL Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to GraphQL into a Java-based ORM framework, Hibernate.
-
Migrating data from Box to Databricks using CData SSIS Components.
Easily push Box to Databricks using the CData SSIS Tasks for Box and Databricks.
-
Create Datasets from MYOB AccountRight in Domo Workbench and Build Visualizations of MYOB AccountRight in Domo
Use the CData Software ODBC Driver for MYOB AccountRight to create datasets from MYOB AccountRight in Domo Workbench and then build visualizations in the Domo service.
-
Create Data Visualizations Based On Avalara AvaTax in Mode
Use CData Connect AI to connect to Avalara AvaTax from Mode and build visualizations using live
-
Create Informatica Mappings From/To a JDBC Data Source for Sybase
Create Sybase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Salesforce Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce replication to Oracle.
-
Work with Live HubSpot in Power Query
Use CData Connect AI to connect to HubSpot and work with live HubSpot in Microsoft Power Query.
-
Automated Continuous Avro Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Avro replication to Google BigQuery.
-
Integrating Dataiku with SAP Ariba Procurement via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Ariba Procurement.
-
Build WooCommerce-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to WooCommerce from Zoho Analytics and import live WooCommerce.
-
Use the CData Software ODBC Driver for MYOB AccountRight in MicroStrategy
Connect to MYOB AccountRight in MicroStrategy Developer using the CData Software ODBC Driver for MYOB AccountRight.
-
Process & Analyze Oracle HCM Cloud in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle HCM Cloud .
-
Integrate Jira Assets in the Pentaho Report Designer
Publish reports based on Jira Assets in the Pentaho BI tool.
-
Connect to JSON Services from a Connection Pool in JBoss
Integrate JSON into Java servlets: Use the Management Console in JBoss to install the JSON JDBC Driver.
-
How to Use a Microsoft Access Database to Update SAP HANA in Real Time
Update SAP HANA data by creating a linked table in Microsoft Access with the CData SAP HANA ODBC Driver.
-
Integrating Elasticsearch in Talend Cloud Data Management Platform
-