CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with Confluence in DBxtra
Create dynamic dashboards and perform analytics based on Atlassian Confluence in DBxtra.
-
Migrating data from SFTP to Databricks using CData SSIS Components.
Easily push SFTP to Databricks using the CData SSIS Tasks for SFTP and Databricks.
-
Create Data Visualizations in Cognos BI with Drip
Access Drip as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ADP using the Model Context Protocol.
-
Extract, Transform, and Load Salesforce Pardot in Informatica PowerCenter
Create a simple Workflow for Salesforce Pardot in Informatica PowerCenter.
-
Create Amazon Marketplace-Connected Business Apps in AppSheet
Connect to Amazon Marketplace via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon Marketplace.
-
Query, Visualize, and Share live Kintone in Redash
Use CData Connect AI to connect to live Kintone in Redash for querying, visualizing, and sharing.
-
Viewing Paylocity in RAD Studio Data Explorer
How to view Paylocity in RAD Studio Data Explorer using the CData ODBC Driver for Paylocity.
-
Create Informatica Mappings From/To an ODBC Data Source for ConstantContact
Create an ODBC connection to ConstantContact in Informatica and browse and transfer ConstantContact.
-
How to Connect to Live SharePoint from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft SharePoint for you.
-
How to import SAP HANA into Apache Solr
Use the CData Software JDBC Driver for SAP HANA in Data Import Handler and create an automated import of SAP HANA to Apache Solr Enterprise Search platform.
-
How to Query Live Pinterest in Claude Desktop
Connect to and query live Pinterest in Claude Desktop using CData Code Assist MCP.
-
Automated Continuous YouTube Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Google Cloud SQL.
-
How to Use a Microsoft Access Database to Update Microsoft Exchange in Real Time
Update Microsoft Exchange data by creating a linked table in Microsoft Access with the CData Microsoft Exchange ODBC Driver.
-
Access Live Snapchat Ads in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Snapchat Ads into the statistical analysis tools available in SAS JMP. This article shows how to use Snapchat Ads in the Graph Builder and Query Builder.
-
How to Connect to & Open Spark in Microsoft Excel
This article uses the CData ODBC driver for Spark to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Asana from Tableau
Use the Tableau Desktop business intelligence tool to connect to Asana.
-
Integrate Unbounce in the Pentaho Report Designer
Publish reports based on Unbounce in the Pentaho BI tool.
-
How to Connect to Live Amazon S3 in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Amazon S3 without replication.
-
How to create Visio diagrams from IBM Informix
Automatically update IBM Informix with the changes you make to Visio master shapes.
-
PowerShell Scripting to Replicate SharePoint to MySQL
Write a simple PowerShell script to replicate Microsoft SharePoint to a MySQL database.
-
Connect to Dynamics NAV in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics NAV and the SQL Gateway to access Microsoft Dynamics NAV from Google Apps Script.
-
Analyze Elasticsearch in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Elasticsearch and visualize live Elasticsearch in Infragistics Reveal.
-
Create Spark-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Spark from OutSystems and build custom enterprise apps using live Apache Spark SQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for REST
Provide connectivity to REST through an SAP BusinessObjects universe.
-
Connect to Salesforce Pardot as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Pardot.
-
How to connect to Google Ad Manager from IntelliJ
Integrate connectivity to Google Ad Manager with wizards in IntelliJ.
-
Automated Continuous Workday Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Workday replication to Google Cloud SQL.
-
Stream Phoenix into Apache Kafka Topics
Access and stream Apache Phoenix in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect Oracle Eloqua Reporting to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle Eloqua Reporting using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live MySQL Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MySQL securely in real time.
-
Connect to Google Ad Manager in Jaspersoft Studio
Execute SQL to remote Google Ad Manager in Jaspersoft Studio.
-
Connect and Visualize Live Trello Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Trello into the Databricks platform and create visualization dashboards with real-time Trello.
-
Build Outreach.io-Connected Apps in Choreo
Use CData Connect AI to connect to Outreach.io from Choreo and build custom apps using live Outreach.io.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Asana using the Model Context Protocol.
-
Getting Started with the CData Excel Add-In for Databricks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Databricks.
-
Automated Continuous Phoenix Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Phoenix replication to OneLake in Microsoft Fabric.
-
Add IBM Informix to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for IBM Informix with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Zoho Projects in ACL Analytics
Connect to Zoho Projects via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho Projects.
-
How to load Sugar CRM data into Elasticsearch via Logstash
Introducing a simple method to load Sugar CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Write a Simple Go Application to work with Phoenix on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache Phoenix.
-
Using the CData Software ODBC Driver for Act-On in PyCharm
Connect to Act-On as an ODBC data source in PyCharm using the CData Software ODBC Driver for Act-On.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Pivotal GreenPlum using the Model Context Protocol.
-
Analyze Airtable in Infragistics Reveal
Use the CData API Server to create an OData API on top of Airtable and visualize live Airtable in Infragistics Reveal.
-
Connect to eBay in RapidMiner
Integrate eBay with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Snowflake in SpagoBI
Create reports featuring live Snowflake in SpagoBI Studio. Host Snowflake reports on SpagoBI Server.
-
Build eBay-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to eBay and build web apps with connectivity to live eBay.
-
Create Dynamics 365-Connected Applications in Appsmith
Connect to Dynamics 365 via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Dynamics 365.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoho Inventory using the Model Context Protocol.
-
Use Claude to Talk to Your Dynamics CRM via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Dynamics CRM for you.
-
Access Live Redis in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Redis from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Basecamp from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Basecamp to connect to Basecamp and execute queries in PowerBuilder.
-
Visualize Sage Intacct in Tableau
The CData ODBC driver for Sage Intacct enables you integrate Sage Intacct into Tableau dashboards.
-
Automated Continuous Hive Replication to MongoDB
Use CData Sync for automated, continuous, customizable Hive replication to MongoDB.
-
Build Dashboards with Splunk in Dundas BI
Create dynamic dashboards and perform analytics based on Splunk in Dundas BI.
-
Build Adobe Commerce-Connected Apps in Choreo
Use CData Connect AI to connect to Adobe Commerce from Choreo and build custom apps using live Adobe Commerce.
-
Automated Continuous MarkLogic Replication to SingleStore
Use CData Sync for automated, continuous, customizable MarkLogic replication to SingleStore.
-
Use the CData Software ODBC Driver for Sage 300 in MicroStrategy Desktop
Connect to Sage 300 in MicroStrategy Desktop using the CData Software ODBC Driver for Sage 300.
-
Connect to Xero from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Xero Accounting from Filemaker Pro on Mac.
-
Analyze Clio in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Clio and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Connecting Agentforce with Oracle via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Oracle Database for you.
-
Use the CData Software JDBC Driver for HubSpot in MicroStrategy Web
Connect to HubSpot in MicroStrategy Web using the CData Software JDBC Driver for HubSpot.
-
Model, Search, and Visualize Live Xero in ThoughtSpot
Use CData Connect AI to connect to live Xero Accounting for modeling, searching, and visualizing.
-
Integrate with Active Directory using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Active Directory to a JSON file on disk.
-
Use Azure AI Foundry to Talk to Your Salesforce via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Salesforce & Force.com for you.
-
How to import Sybase into Apache Solr
Use the CData Software JDBC Driver for Sybase in Data Import Handler and create an automated import of Sybase to Apache Solr Enterprise Search platform.
-
Deploy the ADO.NET Provider for Raisers Edge NXT on an SSRS Report Server
Connect to Raisers Edge NXT 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.
-
Migrating data from Calendly to Snowflake using CData SSIS Components.
Easily push Calendly to Snowflake using the CData SSIS Tasks for Calendly and Snowflake.
-
Visualize Google Directory in TIBCO Spotfire through OData
Integrate Google Directory into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Tableau Connector for SAP Netweaver Gateway
-