CData Software - Knowledge Base
Recent Articles
-
Analyze Okta Data in Cognos Analytics
Use CData Connect AI to connect to Okta Data from Cognos Analytics and analyze live Okta.
-
Getting Started with the CData SSIS Components for Eventbrite
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Eventbrite.
-
Migrating data from Acumatica to Google BigQuery using CData SSIS Components.
Easily push Acumatica ERP to Google BigQuery using the CData SSIS Tasks for Acumatica and Google BigQuery.
-
Replicate Jira Assets Data to Multiple Databases
Replicate Jira Assets to disparate databases with a point-and-click configuration.
-
Connect to Trello Data in DBeaver
Use the CData ODBC Driver to connect to Trello in DBeaver.
-
Connect to Todoist Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Todoist and the SQL Gateway to access Todoist from Google Apps Script.
-
Access Live QuickBooks Time Data in Excel 365 Online (Excel for the web)
Connect to QuickBooks Time from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build AI Agents with MongoDB 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 MongoDB through CData Connect AI.
-
Build Data Flows from EnterpriseDB to SQL Server using SSIS
Easily back up EnterpriseDB to SQL Server using the SSIS components for EnterpriseDB.
-
Easily Integrate PhantomBuster Data in Lazarus Pascal IDE
Learn how to easily integrate live PhantomBuster in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Gmail Data in JReport Designer
Create charts and reports based on Gmail in JReport Designer.
-
DataBind Controls to AlloyDB Data in Delphi
DataBind to Google AlloyDB in Delphi with standard data access components and controls.
-
Build AI Agents with Sage Intacct 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 Sage Intacct through CData Connect AI.
-
How to Query Live Twitter Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Twitter Ads data in natural language using Python.
-
How to Seamlessly Import Perigon Data into IBM SPSS Modeler
Integrate Perigon data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Choosing the Best Method to Connect Discourse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Discourse from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Semantic Layer Views for ChartMogul Data in APOS Live Data Gateway
Use the CData Connector for ChartMogul in APOS Live Data Gateway to build Semantic Layer Views for ChartMogul.
-
How to import Google Drive Data into Apache Solr
Use the CData Software JDBC Driver for Google Drive in Data Import Handler and create an automated import of Google Drive to Apache Solr Enterprise Search platform.
-
Build HDFS-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for HDFS to explore live HDFS Data in GitHub Copilot to assist with building HDFS-powered applications.
-
Getting Started with the CData SSIS Components for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PostgreSQL.
-
Build Square-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Square.
-
Extract, Transform, and Load Freshdesk Data in Informatica PowerCenter
Create a simple Workflow for Freshdesk in Informatica PowerCenter.
-
Create a Data Access Object for Stack Exchange Data using JDBI
A brief overview of creating a SQL Object API for Stack Exchange in JDBI.
-
Build AI Agents with Sage 200 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 Sage 200 through CData Connect AI.
-
DataBind Controls to Snowflake Data in Delphi
DataBind to Snowflake in Delphi with standard data access components and controls.
-
Query Vercel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Vercel from Node.js.
-
Connect to Zoho CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho CRM to connect to Zoho CRM from Web applications running on WebLogic.
-
Connect to Neo4J in SpagoBI
Create reports featuring live Neo4J in SpagoBI Studio. Host Neo4J reports on SpagoBI Server.
-
Viewing GetResponse Data in RAD Studio Data Explorer
How to view GetResponse in RAD Studio Data Explorer using the CData ODBC Driver for GetResponse.
-
Access Live Adobe Target Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Target data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to Live Avalara AvaTax Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Avalara AvaTax for you.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Acumatica actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Getting Started with the CData Power BI Connector for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Twitter Ads.
-
Bridge MySQL Connectivity with Apache NiFi
Access and process MySQL in Apache NiFi using the CData JDBC Driver.
-
Integrate HelloSign Data in Pentaho Data Integration
Build ETL pipelines based on HelloSign in the Pentaho Data Integration tool.
-
Query Azure Table Data in DataGrip
Create a Data Source for Azure Table in DataGrip and use SQL to query live Azure Table Storage.
-
A PostgreSQL Interface for ServiceNow Data (MySQL Remoting via JDBC)
Use the Remoting features of the ServiceNow JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Microsoft Ads Data in Apache Spark using SQL
Access and process Microsoft Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Edit and Search Sentry External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sentry to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sentry objects that you can access from apps and the dashboard.
-
How to Create Power BI Visual Reports with Real-Time Browserless Data
Use CData Power BI Connectors to visualize Browserless in Power BI.
-
Build a Simple VCL Application for Brex Data
How to build a simple VCL Application to view Brex in RAD Studio using the CData ODBC Driver for Brex.
-
Integrate Google Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Ads.
-
Create Dashboards and Visualize Live Quickbase Data in Geckoboard
Use CData Connect AI to connect to live Quickbase and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData ODBC Driver for Cvent in Microsoft Power Query
You can use the CData Cvent ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Cvent into Microsoft Power Query.
-
Automated Continuous CapsuleCRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to AlloyDB.
-
Integrate with Drift Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Drift to a JSON file on disk.
-
Create a Data Access Object for Dynamics NAV Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Dynamics NAV in JDBI.
-
Import Real-Time MongoDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MongoDB in ColdFusion.
-
Create Reports with Amplitude Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amplitude.
-
Integrating ZohoDesk Data in Talend Cloud Data Management Platform
Connect ZohoDesk Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Agents in Relevance AI with Access to Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on IBM DB2 within intelligent agent workflows.
-
Connect to Simplesat Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Databricks Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Databricks and the Script function in FileMaker Pro to connect to Databricks and work with Databricks in your FileMaker application.
-
Salesforce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce facts in real time.
-
Integrate ScrapingBee Data in Pentaho Data Integration
Build ETL pipelines based on ScrapingBee in the Pentaho Data Integration tool.
-
Integrate with live Freshservice Data in Jitterbit
Use CData Connect AI to connect to and integrate live Freshservice in Jitterbit.
-
Getting Started with the CData Tableau Connector for Hubstaff
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Establish a Live Connection with LaunchDarkly Data using Tableau Bridge
The CData ODBC Driver for LaunchDarkly enables you to integrate live LaunchDarkly into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Mixpanel-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Mixpanel Data in GitHub Copilot to assist with building Mixpanel-powered applications.
-
Getting Started with the CData JDBC Driver for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Campaign Manager 360.
-
Access Jira Data from MySQL in PHP
Connect to Jira through the standard MySQL libraries in PHP.
-
Build Azure Data Catalog-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Azure Data Catalog to explore live Azure Data Catalog Data in Claude Code to assist with building Azure Data Catalog-powered applications.
-
Okta Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Okta through CData Connect AI using different applications and tools.
-
Automated Continuous Elorus Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Elorus replication to Google BigQuery.
-
Integrate Theia IDE with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect Phoenix to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apache Phoenix using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Brex in MicroStrategy Desktop
Connect to Brex in MicroStrategy Desktop using the CData Software ODBC Driver for Brex.
-
Integrating LangChain with Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Marketo within automated workflows.
-
Connect to Oracle Sales Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Sales in Google Apps Script.
-
Build Automated Spark-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache Spark SQL and build automated workflows in Zapier.
-
Query Anaplan Data in DataGrip
Create a Data Source for Anaplan in DataGrip and use SQL to query live Anaplan.
-
A PostgreSQL Interface for Twilio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Twilio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with SAP BusinessObjects BI Data in JReport Designer
Create charts and reports based on SAP BusinessObjects BI in JReport Designer.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SQL Server
Provide connectivity to Microsoft SQL Server through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Contentful in MicroStrategy Web
Connect to Contentful in MicroStrategy Web using the CData Software ODBC Driver for Contentful.
-
Build a Simple VCL Application for Oracle Service Cloud Data
How to build a simple VCL Application to view Oracle Service Cloud in RAD Studio using the CData ODBC Driver for Oracle Service Cloud.
-
How to import Chargebee Data into Apache Solr
Use the CData Software JDBC Driver for Chargebee in Data Import Handler and create an automated import of Chargebee to Apache Solr Enterprise Search platform.
-
Use Claude to Talk to Your FreshBooks 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 FreshBooks for you.
-
Bind Live Helpscout Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Helpscout data
-
Create Greenplum-Connected Dashboards in Grafana
Connect to Greenplum Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Pivotal GreenPlum.
-
Automated Continuous SAP Ariba Source Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Apache Kafka.
-
Build Automated Workflows with Live CockroachDB Data in Workato
Use CData Connect AI to connect to live CockroachDB and build automated workflows in Workato.
-
Getting Started with the CData Python Connector for Planio
Learn to install and license the CData Python Connector
-
Automated Continuous EnterpriseDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to SQL Server.
-
Query Mixpanel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mixpanel from Node.js.
-
Build Salesloft-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesloft.
-
Automated Continuous Microsoft Teams Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Amazon S3.
-
LINQ to Neo4J Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Neo4J Data Provider.
-
Use the CData ODBC Driver for Dotmailer from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dotmailer to connect to Dotmailer from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dotmailer in Excel.
-
Create Datasets from Zoom in Domo Workbench and Build Visualizations of Zoom Data in Domo
Use the CData Software ODBC Driver for Zoom to create datasets from Zoom in Domo Workbench and then build visualizations in the Domo service.
-
Visualize ServiceNow Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ServiceNow.
-
Connect to Oracle Eloqua Reporting Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Eloqua Reporting in DBeaver.
-
Build Slack-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Slack.
-
Integrating Antigravity CLI with AdRoll via CData CLI
Connect AdRoll to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software ODBC Driver for Coinbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Coinbase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Coinbase.
-
Rapidly Develop SAP SuccessFactors LMS-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 SAP SuccessFactors LMS.
-
Connect Azure Table to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Table with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Reckon Replication to MongoDB
Use CData Sync for automated, continuous, customizable Reckon replication to MongoDB.
-
A PostgreSQL Interface for Email Data (MySQL Remoting via JDBC)
Use the Remoting features of the Email JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Simple VCL Application for Amazon DynamoDB Data
How to build a simple VCL Application to view Amazon DynamoDB in RAD Studio using the CData ODBC Driver for Amazon DynamoDB.