CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Todoist in MicroStrategy
Connect to Todoist data in MicroStrategy Developer using the CData Software JDBC Driver for Todoist.
-
ETL PDFMonkey in Oracle Data Integrator
This article shows how to transfer PDFMonkey data into a data warehouse using Oracle Data Integrator.
-
Migrating data from Salesforce Pardot to Databricks using CData SSIS Components.
Easily push Salesforce Pardot data to Databricks using the CData SSIS Tasks for Salesforce Pardot and Databricks.
-
Automated Continuous Zoho Recruit Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to SQL Server.
-
Integrating Gumloop with QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on QuickBooks Online data within automated workflows.
-
Back Up Supabase data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Supabase data data.
-
Replicate Multiple SAS xpt Accounts
Replicate multiple SAS xpt accounts to one or many databases.
-
Build AI Agents with GetResponse Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live GetResponse data through CData Connect AI.
-
A PostgreSQL Interface for Sybase Data using the CData ODBC Driver
Use the SQL Gateway and Sybase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Twilio Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Twilio and the Script function in FileMaker Pro to connect to Twilio and work with Twilio data in your FileMaker application.
-
How to Create Power BI Visual Reports with Real-Time Insightly Data
Use CData Power BI Connectors to visualize Insightly data in Power BI.
-
Automated Continuous HubDB Replication to SQLite
Use CData Sync for automated, continuous, customizable HubDB replication to SQLite.
-
Connect to Freshteam Data from PowerBuilder via JDBC
This article demonstrates how to access Freshteam data from PowerBuilder using the Freshteam JDBC Driver.
-
Object-Relational Mapping (ORM) with SendGrid Data 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 SendGrid data into a Java-based ORM framework, Hibernate.
-
Design BIRT Reports on HubSpot Data
Provide current HubSpot data to your embedded analytics.
-
Rapidly Develop Sage 300-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Sage 300.
-
Extract, Transform, and Load Beeminder Data in Informatica PowerCenter
Create a simple Workflow for Beeminder data in Informatica PowerCenter.
-
Establish a Live Connection with NetSuite Data using Tableau Bridge
The CData ODBC Driver for NetSuite enables you to integrate live NetSuite data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with CampaignMonitor Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CampaignMonitor data to a JSON file on disk.
-
Excel Spreadsheet Automation on ShipStation Data with the QUERY Formula
Pull data from ShipStation, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Recurly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Recurly replication to SingleStore.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for QuickBooks Time
Provide connectivity to QuickBooks Time data through an SAP BusinessObjects universe.
-
Use CData Connect AI to Access Sage 300 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage 300 data in the Power Pivot business intelligence tool.
-
Getting Started with the CData ADO.NET Provider for Intercom
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Stream SendInBlue Data into Apache Kafka Topics
Access and stream SendInBlue data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Semantic Layer Views for SendGrid Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SendGrid data.
-
Access Live Google Ad Manager Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Ad Manager data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Datadog
Provide connectivity to Datadog data through an SAP BusinessObjects universe.
-
Publish Sendwithus-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sendwithus data.
-
Getting Started with the CData Python Connector for Dynamics CRM
Learn to install and license the CData Python Connector and configure a connection to live Dynamics CRM data.
-
Integrate Deel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Deel with External Services.
-
How to create Visio diagrams from CouchDB Data
Automatically update CouchDB data with the changes you make to Visio master shapes.
-
Extract, Transform, and Load Slack Data in Informatica PowerCenter
Create a simple Workflow for Slack data in Informatica PowerCenter.
-
Integrate Dify with Live NetSuite Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live NetSuite data.
-
How to Build an ETL App for xBase Data in Python with CData
Create ETL applications and real-time data pipelines for xBase data in Python with petl.
-
Create Data Visualizations Based On Odoo Data in Mode
Use CData Connect AI to connect to Odoo Data from Mode and build visualizations using live Odoo data.
-
Using the CData Software ODBC Driver for Marketo in PyCharm
Connect to Marketo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Marketo.
-
Integrate Live Google Ads Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Ads data to Blue Prism using the CData ODBC Driver for Google Ads to create automated workflows for repetitive business tasks.
-
How to Connect to & Open Superchat Data in Microsoft Excel
This article uses the CData ODBC driver for Superchat to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate OpenCode with Live ShipStation Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ShipStation data from within your AI coding agent.
-
Create Reports from SAP Business One Data in Looker Studio
Use CData Connect AI to gain access to live SAP Business One data and create custom reports in Looker Studio.
-
How to Build an ETL App for Google Analytics Data in Python with CData Connect AI
Extract and transform live Google Analytics data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Greenplum Data from a Connection Pool in JBoss
Integrate Greenplum data into Java servlets: Use the Management Console in JBoss to install the Greenplum JDBC Driver.
-
Create ConstantContact-Connected Business Apps in AppSheet
Connect to ConstantContact Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ConstantContact data.
-
Replicate ClickUp Data in Heroku for Use in Salesforce Connect
Replicate ClickUp data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Microsoft Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Ads data and visualize live Microsoft Ads data in Infragistics Reveal.
-
Automated Continuous Raisers Edge NXT Replication to Vertica
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Vertica.
-
Connect to and Visualize Live Deel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Deel data.
-
Connect to LinkedIn Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for LinkedIn Ads to connect to LinkedIn Ads data from Web applications running on WebLogic.
-
Publish Demio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Demio data.
-
Integrating Cursor with Azure Table Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Integrating Dataiku with BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live BambooHR data.
-
Integrate Parquet with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Parquet with External Services.
-
How to connect to Hacker News Data from IntelliJ
Integrate connectivity to Hacker News data with wizards in IntelliJ.
-
Integrate SAS xpt Data into Power Automate Desktop using CData Connect
CData Connect for SAS xpt Data enables you to integrate SAS xpt data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Google Search in MicroStrategy Desktop
Connect to Google Search results in MicroStrategy Desktop using the CData Software JDBC Driver for Google Search.
-
Visualize Live Cohere Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Cohere data.
-
Connect to Real-Time ServiceDesk Plus Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ServiceDesk Plus data in Power Apps.
-
How to Connect to & Open Apollo Data in Microsoft Excel
This article uses the CData ODBC driver for Apollo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Prepare, Blend, and Analyze Confluence Data in Alteryx Designer (ODBC)
Build workflows to access live Confluence data for self-service data analytics.
-
Visualize Live Facebook Ads Data in the Power BI Service
Use CData Connect AI to connect to live Facebook Ads data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Sage 200 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sage 200 data. Leverage the pyodbc module for ODBC in Python.
-
Establish a Live Connection with Vault CRM Data using Tableau Bridge
The CData ODBC Driver for Vault CRM enables you to integrate live Vault CRM data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Pipelines with Live Moosend Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Moosend from Google Cloud Data Fusion, enabling the integration of live Moosend data into the building and management of effective data pipelines.
-
Connect to FreshBooks Data in Ruby
Connect to FreshBooks data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Google Tasks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Tasks replication to Amazon Redshift.
-
Automated Continuous VWO Replication to SQL Server
Use CData Sync for automated, continuous, customizable VWO replication to SQL Server.
-
Automated Continuous API Replication to MongoDB
Use CData Sync for automated, continuous, customizable API replication to MongoDB.
-
Connect to Qualaroo Data in DBArtisan
Use wizards in DBArtisan to configure Qualaroo data as a data source.
-
Enable the MessageBird JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MessageBird data.
-
A PostgreSQL Interface for Amazon S3 Data using the CData ODBC Driver
Use the SQL Gateway and Amazon S3 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Agno to Talk to Your Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Stripe data for you.
-
Connect to Google Contacts Data in Ruby
Connect to Google Contacts data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Neo4J Data in Sisense
Create an ElastiCube in Sisense app with access to Neo4J data.
-
Query Discord Data in ColdFusion
Write standard ColdFusion data access code to connect to Discord data.
-
Access Live Azure Table Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Table data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Adobe Experience Manager Data in Aqua Data Studio
Access Adobe Experience Manager data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to AgileCRM Data in Ruby
Connect to AgileCRM data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Azure Data Lake Storage Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage data replication to OneLake in Microsoft Fabric.
-
How to create an RPA flow for Notion Data in UiPath Studio
Use the Notion ODBC Driver to create workflows that access real-time Notion data without any coding.
-
Automated Continuous Tanda Replication to Databricks
Use CData Sync for automated, continuous, customizable Tanda replication to Databricks.
-
Automated Continuous Zoho Creator Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho Creator data replication to OneLake in Microsoft Fabric.
-
Migrating data from Excel Online to Google BigQuery using CData SSIS Components.
Easily push Excel Online data to Google BigQuery using the CData SSIS Tasks for Excel Online and Google BigQuery.
-
Build Dashboards with Trello Data in Dundas BI
Create dynamic dashboards and perform analytics based on Trello data in Dundas BI.
-
DataBind Controls to Jodoo Data in Delphi
DataBind to Jodoo data in Delphi with standard data access components and controls.
-
Model, Search, and Visualize Live Sugar CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Sugar CRM data for modeling, searching, and visualizing.
-
Create Data Visualizations Based On Office 365 Data in Mode
Use CData Connect AI to connect to Office 365 Data from Mode and build visualizations using live Office 365 data.
-
Create Reports with SAP Concur Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Concur data.
-
Integrating GitHub Copilot with Active Directory data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Use Claude to Talk to Your SAP HANA 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 SAP HANA data for you.
-
Integrate Open WebUI with Live Coda Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Coda data from within the chat interface.
-
How to Connect to Live eBay Analytics 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 eBay Analytics data for you.
-
Connect to LinkedIn Ads Data from AWS Glue
Use CData Connect AI to gain access to live LinkedIn Ads data from your AWS Glue jobs.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Business One
Provide connectivity to SAP Business One data through an SAP BusinessObjects universe.
-
Design BIRT Reports on Bitbucket Data
Provide current Bitbucket data to your embedded analytics.
-
Connecting Agentforce with Bullhorn CRM Data 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 Bullhorn CRM data for you.
-
Visualize Sage 300 Data in TIBCO Spotfire through OData
Integrate Sage 300 data into dashboards in TIBCO Spotfire.
-
Connect to Exact Online Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Exact Online.
-
Integrate Theia IDE with Live Adobe Target Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Adobe Target data from within the development environment.
-
Connect to REST Data in HULFT Integrate
Connect to REST as a JDBC data source in HULFT Integrate