CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Highrise
Provide connectivity to Highrise data through an SAP BusinessObjects universe.
-
Visualize Sendwithus Data in Tableau
The CData ODBC driver for Sendwithus enables you integrate Sendwithus data into Tableau dashboards.
-
Migrating data from Cvent to Databricks using CData SSIS Components.
Easily push Cvent data to Databricks using the CData SSIS Tasks for Cvent and Databricks.
-
How to integrate BambooHR with Apache Airflow
Access and process BambooHR data in Apache Airflow using the CData JDBC Driver.
-
Connect to Dotmailer Data in HULFT Integrate
Connect to Dotmailer as a JDBC data source in HULFT Integrate
-
Visualize Teradata Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Teradata data into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Yelp in MicroStrategy
Connect to Yelp data in MicroStrategy Developer using the CData Software JDBC Driver for Yelp.
-
Use Dash to Build Web Apps on Exact Online Data via CData Connect AI
Build interactive Dash web apps on live Exact Online data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Moosend Replication to MongoDB
Use CData Sync for automated, continuous, customizable Moosend replication to MongoDB.
-
How to create Google Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Ads data in MySQL .
-
Visualize Facebook Data in Tableau
The CData ODBC driver for Facebook enables you integrate Facebook data into Tableau dashboards.
-
Publish Excel Online-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Excel Online data.
-
Automated Continuous MailerSend Replication to MySQL
Use CData Sync for automated, continuous, customizable MailerSend replication to MySQL.
-
Use the CData SSIS Components to Insert New or Update Existing LDAP Records from SQL Server
Easily push SQL Server data to LDAP using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into LDAP or update existing records with data from a SQL Server database.
-
How to integrate Metabase with Oracle Data
Use CData Connect AI to connect to live Oracle data and create an interactive dashboard in Metabase from Oracle data.
-
Migrating data from Instantly to Google BigQuery using CData SSIS Components.
Easily push Instantly data to Google BigQuery using the CData SSIS Tasks for Instantly and Google BigQuery.
-
Bridge Todoist Connectivity with Apache NiFi
Access and process Todoist data in Apache NiFi using the CData JDBC Driver.
-
Replicate Multiple Google Ads Accounts
Replicate multiple Google Ads accounts to one or many databases.
-
How to Visualize Pinterest Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pinterest data in Python.
-
Build Charts with Gumroad Data in Clear Analytics
Create dynamic charts and perform analytics based on Gumroad data in Clear Analytics.
-
Query MongoDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against MongoDB data from Node.js.
-
Import Perplexity Data Using Azure Data Factory
Use CData Connect AI to connect to Perplexity Data from Azure Data Factory and import live Perplexity data.
-
Connect to Egnyte Data in Aqua Data Studio
Access Egnyte data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Claude to Talk to Your Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Wave Financial data for you.
-
Viewing AfterShip Data in RAD Studio Data Explorer
How to view AfterShip data in RAD Studio Data Explorer using the CData ODBC Driver for AfterShip.
-
Integrate Open WebUI with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Campaign Manager 360 data from within the chat interface.
-
Integrating MYOB AccountRight Data in Talend Cloud Data Management Platform
Connect MYOB AccountRight Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MYOB AccountRight.
-
Automated Continuous SharePoint Excel Services Replication to SingleStore
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to SingleStore.
-
Publish Reports with Printify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Printify data.
-
Connect to Notion Data from PowerBuilder via ADO.NET
This article demonstrates how to access Notion data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Enable the Google Tasks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Tasks data.
-
Visualize Live Google Analytics Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Analytics data into custom reports in Power BI.
-
Integrating LangGraph with Google Drive Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Drive data within automated workflows.
-
How to Work with MailChimp Data in AWS Glue Jobs Using JDBC
Connect to MailChimp from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Easily Query Miro Data in OpenOffice Base
Connect to Miro data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Pushbullet Data in Jaspersoft Studio
Execute SQL to remote Pushbullet data in Jaspersoft Studio.
-
Integrate Pingdom with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pingdom with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pingdom data.
-
How to Build an ETL App for Outreach.io Data in Python with CData Connect AI
Build ETL pipelines that read and write live Outreach.io data in Python with petl and the CData Connect AI Python SDK.
-
Integrate OpenCode with Live LinkedIn Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live LinkedIn data from within your AI coding agent.
-
Connect to Adobe Target Data in ACL Analytics
Connect to Adobe Target data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Adobe Target data.
-
Connect to Foursquare Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Foursquare data using standard SQL.
-
Connect Facebook Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Facebook Ads data using the CData Python MCP Server.
-
Integrate Trae with Live Kintone Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Kintone data from within the AI-powered IDE.
-
How to Easily Query Zendesk Data in OpenOffice Base
Connect to Zendesk data in OpenOffice Base using the CData ODBC Driver for Zendesk and generate reports with live data insights.
-
Automated Continuous Keap Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Keap replication to Apache Cassandra.
-
How to Access QuickBooks Online Data Using Entity Framework
This article shows how to access QuickBooks Online data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Bridge Kafka Connectivity with Apache NiFi
Access and process Kafka data in Apache NiFi using the CData JDBC Driver.
-
Impala Reporting in OBIEE with the Impala JDBC Driver
Deploy the Impala JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Reckon Data in ColdFusion
Write standard ColdFusion data access code to connect to Reckon data.
-
Build Agents in Relevance AI with Access to Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon S3 data within intelligent agent workflows.
-
Integrate Ontraport Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Ontraport data from Informatica Cloud.
-
Use the CData Software ODBC Driver for Pinecone in MicroStrategy Web
Connect to Pinecone data in MicroStrategy Web using the CData Software ODBC Driver for Pinecone.
-
How to connect to PhantomBuster Data in DBVisualizer
Integrate PhantomBuster data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Twitter Ads Data from MySQL in Amazon QuickSight
Connect to Twitter Ads and build visualizations of Twitter Ads data using a MySQL Connection in Amazon QuickSight.
-
Build Semantic Layer Views for Microsoft Entra ID Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Entra ID in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Entra ID data.
-
Create Informatica Mappings From/To a JDBC Data Source for Discord
Create Discord data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Connect AI Python SDK for Box
Install the CData Connect AI Python SDK to read and write live Box data with standard DB-API 2.0 Python code.
-
Work with Live LinkedIn Ads Data in Power Query
Use CData Connect AI to connect to LinkedIn Ads data and work with live LinkedIn Ads data in Microsoft Power Query.
-
Connect to Google Calendar Data from PowerBuilder via JDBC
This article demonstrates how to access Google Calendar data from PowerBuilder using the Google Calendar JDBC Driver.
-
How to Access Live SAP ByDesign Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP ByDesign enables you to integrate SAP ByDesign data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Azure Table Data in Looker
Use CData Connect AI to connect to Azure Table Data from Looker and build custom apps using live Azure Table data.
-
How to Connect to Live Dynamics 365 Data 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 Dynamics 365 data for you.
-
Bridge Apollo Connectivity with Apache NiFi
Access and process Apollo data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Gorgias Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Gorgias data replication to OneLake in Microsoft Fabric.
-
Access HCL Domino Data from MySQL in PHP
Connect to HCL Domino through the standard MySQL libraries in PHP.
-
Build a Simple VCL Application for Bullhorn CRM Data
How to build a simple VCL Application to view Bullhorn CRM data in RAD Studio using the CData ODBC Driver for Bullhorn CRM.
-
How to use SQLAlchemy ORM to access EmailOctopus Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of EmailOctopus data.
-
Use the CData Software JDBC Driver for ZohoMarketingHub in MicroStrategy Web
Connect to ZohoMarketingHub data in MicroStrategy Web using the CData Software JDBC Driver for ZohoMarketingHub.
-
Build AI/ML Models with Live LinkedIn Ads Data using Dataiku
Connect LinkedIn Ads Data with Dataiku using the CData JDBC Driver for LinkedIn Ads.
-
Write a Simple Go Application to work with Webex Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Webex data.
-
Connect to Accelo Data in Ruby
Connect to Accelo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access SendGrid Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SendGrid data from your Oracle system.
-
Connect to Quaderno Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Quaderno data.
-
Visualize ADP Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ADP data into TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Campaigner
Create an ODBC connection to Campaigner in Informatica and browse and transfer Campaigner data.
-
Visualize Coda Data in Sisense
Create an ElastiCube in Sisense app with access to Coda data.
-
Integrate LibreChat with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live QuickBooks Time data from within the chat interface.
-
Query LaunchDarkly Data in DataGrip
Create a Data Source for LaunchDarkly in DataGrip and use SQL to query live LaunchDarkly data.
-
Create Mode-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Mode Data from Klipfolio and build custom visualizations using live Mode data.
-
Connecting GenSpark with Amazon S3 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon S3 data without any replication or custom integration required.
-
Integrate LibreChat with Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live iContact data from within the chat interface.
-
Process & Analyze Datadog Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Datadog Data.
-
Build EnterpriseDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live EnterpriseDB data and build visualizations in Tableau.
-
Integrate with live Hive Data in Jitterbit
Use CData Connect AI to connect to and integrate live Hive data in Jitterbit.
-
Create Reports from Salesforce Marketing Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce Marketing data and create custom reports in Looker Studio.
-
Build Voice Agents in ElevenLabs with access to Live SAP HANA XS Advanced Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP HANA XS Advanced data.
-
How to load Yelp data into Elasticsearch via Logstash
Introducing a simple method to load Yelp data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with Billsby Data in JReport Designer
Create charts and reports based on Billsby data in JReport Designer.
-
Getting Started with the CData Power BI Connector for Exa
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Query Yelp Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Yelp data from Node.js.
-
Automated Continuous Avro Replication to SingleStore
Use CData Sync for automated, continuous, customizable Avro replication to SingleStore.
-
Automated Continuous ShipEngine Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ShipEngine replication to Google BigQuery.
-
Build Apps with Live Printify Data Using the Low-Code Development Platform of Mendix
Connect Printify data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Connect to Live ServiceDesk Plus Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ServiceDesk Plus data without replication.
-
How to Visualize Office 365 Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Office 365 data in Python.
-
Use the CData ODBC Driver for Sugar CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sugar CRM to connect to Sugar CRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sugar CRM data in Excel.
-
Visualize Live Freshteam Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Freshteam data into custom reports in Power BI.
-
Query Hugging Face Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Hugging Face data from Node.js.
-
Access Live WooCommerce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate WooCommerce data into the statistical analysis tools available in SAS JMP. This article shows how to use WooCommerce data in the Graph Builder and Query Builder.
-
Build a Singer.io Tap for Miro With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Miro data using the CData Python Connector.