CData Software - Knowledge Base
Recent Articles
-
Use CData Connect AI to Access Dynamics 365 in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Dynamics 365 in the Power Pivot business intelligence tool.
-
A PostgreSQL Interface for Teradata (MySQL Remoting via JDBC)
Use the Remoting features of the Teradata JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Tableau CRM Analytics from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Tableau CRM Analytics for you.
-
Visualize ServiceNow from Tableau
Use the Tableau Desktop business intelligence tool to connect to ServiceNow.
-
Replicate Cassandra to Multiple Databases
Replicate Apache Cassandra to disparate databases with a point-and-click configuration.
-
Build Dashboards with Xero in Dundas BI
Create dynamic dashboards and perform analytics based on Xero Accounting in Dundas BI.
-
Automated Continuous MySQL Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MySQL replication to delimited files (CSV/TSV).
-
Google Campaign Manager 360 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Campaign Manager 360 facts in real time.
-
Automated Continuous Azure Active Directory Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Active Directory replication to OneLake in Microsoft Fabric.
-
Integrate Couchbase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Couchbase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Couchbase.
-
Create Apps from SendGrid in Qlik Sense Cloud
Use CData Connect AI to connect to SendGrid and build apps from live SendGrid in Qlik Sense Cloud.
-
Connect to Google Analytics from a Connection Pool in JBoss
Integrate Google Analytics into Java servlets: Use the Management Console in JBoss to install the Google Analytics JDBC Driver.
-
Operational Reporting on QuickBooks from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote QuickBooks Desktop.
-
Automated Continuous MongoDB Replication to Vertica
Use CData Sync for automated, continuous, customizable MongoDB replication to Vertica.
-
Easily Integrate Cvent in Lazarus Pascal IDE
Learn how to easily integrate live Cvent in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software ODBC Driver for Azure DevOps in MicroStrategy Desktop
Connect to Azure DevOps in MicroStrategy Desktop using the CData Software ODBC Driver for Azure DevOps.
-
Process & Analyze Microsoft Planner in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Planner .
-
ETL JSON in Oracle Data Integrator
This article shows how to transfer JSON into a data warehouse using Oracle Data Integrator.
-
Query PostgreSQL using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume PostgreSQL entities in PHP by modeling them as objects.
-
Create Datasets from Excel Online in Domo Workbench and Build Visualizations of Excel Online in Domo
Use the CData Software ODBC Driver for Excel Online to create datasets from Microsoft Excel Online in Domo Workbench and then build visualizations in the Domo service.
-
How to create Visio diagrams from WooCommerce
Automatically update WooCommerce with the changes you make to Visio master shapes.
-
Use CData Connect AI to Access FHIR in Microsoft Power Pivot
Use CData Connect AI to connect to live FHIR in the Power Pivot business intelligence tool.
-
How to Visualize Amazon S3 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon S3 in Python.
-
Create Twitter-Connected Dashboards in Grafana
Connect to Twitter via CData Connect AI in Grafana and create custom business dashboards with real-time access to Twitter.
-
Connect to Greenplum as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Pivotal GreenPlum.
-
Automated Continuous MarkLogic Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MarkLogic replication to Apache Kafka.
-
Edit and Search External Oracle Financials Cloud Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle Financials Cloud to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle Financials Cloud objects that you can access from apps and the dashboard.
-
Integrate with live SendGrid in Jitterbit
Use CData Connect AI to connect to and integrate live SendGrid in Jitterbit.
-
Create MailChimp Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Enable the Salesforce Pardot JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce Pardot.
-
Integrate with Workday using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Workday to a JSON file on disk.
-
Model AlloyDB Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and AlloyDB, enabling the direct import of real-time Google AlloyDB.
-
Replicate Todoist from PowerShell
Write a quick PowerShell script to query Todoist. Use connectivity to the live data to replicate Todoist to SQL Server.
-
Access Live Aha in Coginiti Pro
Connect to and query live Aha! from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Biml to Build SSIS Tasks to Replicate Google Drive to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Drive to SQL Server.
-
Connect to Reckon Accounts Hosted in SpagoBI
Create reports featuring live Reckon Accounts Hosted in SpagoBI Studio. Host Reckon Accounts Hosted reports on SpagoBI Server.
-
Access Live Databricks in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Databricks from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to publish and share Basecamp dashboards with Tableau Server
The CData ODBC driver for Basecamp enables you integrate Basecamp into Tableau dashboards.
-
Seamlessly Bring Splunk into Retool Using CData Connect AI
Integrate Splunk data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live LinkedIn Ads in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn Ads from your Google Sheets.
-
Replicate Sugar CRM in Heroku for Use in Salesforce Connect
Replicate Sugar CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Controls to Avro in Delphi
DataBind to Apache Avro in Delphi with standard data access components and controls.
-
Use Claude to Talk to Your Redshift via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Amazon Redshift for you.
-
How to Connect to Live Oracle HCM Cloud 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 Oracle HCM Cloud for you.
-
Working with ADP in LINQPad
Execute LINQ queries to ADP in LINQPad.
-
Integrate with Live GitHub in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to GitHub from the MuleSoft Anypoint Platform to integrate live GitHub into custom reports and dashboards.
-
Analyze Sage Intacct in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sage Intacct and visualize live Sage Intacct in Infragistics Reveal.
-
How to load Dynamics NAV data into Elasticsearch via Logstash
Introducing a simple method to load Dynamics NAV data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Microsoft Exchange-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Exchange.
-
Design BIRT Reports on Instagram
Provide current Instagram to your embedded analytics.
-
Use ChatGPT to Talk to Your Zoho Projects via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Zoho Projects for you.
-
Automated Continuous Azure Synapse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure Synapse replication to SingleStore.
-
Create Dynamic Azure Synapse Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Synapse to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData API Server to Access Zoom in Microsoft PowerPivot
Use the CData API Server to connect to live Zoom in the Power Pivot business intelligence tool.
-
Deploy the ADO.NET Provider for Amazon S3 on an SSRS Report Server
Connect to Amazon S3 from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Establish a Live Connection with Okta using Tableau Bridge
The CData ODBC Driver for Okta enables you to integrate live Okta into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Multiple XML Accounts via the CData Sync CLI
Replicate multiple XML accounts to one or many databases.
-
Trigger Sybase IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Build Amazon S3-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Amazon S3 and create custom apps in Mendix.
-
Build an OLAP Cube in SSAS from Certinia
Establish a connection to Certinia data from SQL Server Analysis Services, and use the Certinia Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating LangGraph with Amazon S3 via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon S3 within automated workflows.
-
How to update Snowflake from Excel
This article explains how to transfer data from Excel to Snowflake using the Excel Add-In for Snowflake.
-
Build Tableau CRM Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Tableau CRM Analytics and build web apps with connectivity to live Tableau CRM Analytics.
-
Import and Visualize CockroachDB in Power View
Create data visualizations based on CockroachDB in Excel.
-
Analyze BigQuery in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google BigQuery and visualize Google BigQuery in SAP Analytics Cloud.
-
Create Data Visualizations in Cognos BI with xBase
Access xBase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze EventBrite in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Eventbrite and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Import Paylocity Using Azure Data Factory
Use CData Connect AI to connect to Paylocity from Azure Data Factory and import live Paylocity.
-
Working with MarkLogic in LINQPad
Execute LINQ queries to MarkLogic in LINQPad.
-
How to Connect to Live WooCommerce 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 WooCommerce for you.
-
Create Dashboards and Visualize Live MongoDB in Geckoboard
Use CData Connect AI to connect to live MongoDB and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Bind Live Presto Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Presto data
-
How to Easily Query Salesforce Marketing in OpenOffice Base
-