CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Raisers Edge NXT Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Raisers Edge NXT in ColdFusion.
-
Connect to Tanda Data in NetBeans
Connect to Tanda in NetBeans with the data source configuration wizard.
-
Build Apps with Live Aweber Data Using the Low-Code Development Platform of Mendix
Connect Aweber with Mendix to build apps using the CData API Driver for JDBC.
-
How to Query Live Google Drive Data in Claude Desktop
Connect to and query live Google Drive Data in Claude Desktop using CData MCP Server.
-
How to work with EmailOctopus Data in Apache Spark using SQL
Access and process EmailOctopus Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Google Drive Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Drive.
-
Integrating GitHub Copilot CLI with Datadog 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.
-
Create SSAS Tabular Models from Clari Data
How to build a SQL Server Analysis Service Tabular Model from Clari using CData drivers.
-
Visualize Live Zoho Recruit Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoho Recruit using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Salesloft Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Salesloft and perform CRUD operations on Salesloft from Node.js.
-
Connect to Square from Asprova with CData Software ODBC Driver for Square
This article shows how to connect faster to Square data from Asprova.
-
Build an OLAP Cube in SSAS from Tally Data
Establish a connection to Tally ERP data from SQL Server Analysis Services, and use the Tally Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Okta Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Okta and the Script function in FileMaker Pro to connect to Okta and work with Okta in your FileMaker application.
-
Connect Oracle HCM Cloud to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle HCM Cloud using the CData Python MCP Server.
-
Connect to Workday Data in Ruby
Connect to Workday in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Perplexity-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Perplexity.
-
ADP Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ADP facts in real time.
-
Access Live Okta Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Okta through MCP integration.
-
Query Live Bullhorn CRM Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Bullhorn CRM directly from the development environment.
-
DataBind Charts to Microsoft Dataverse Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Dataverse (CDS) from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Feed LinkedIn Data into FineReport
How to set LinkedIn as a JDBC data source in FineReport.
-
Access Live Google Spanner Data in Coginiti Pro
Connect to and query live Google Spanner from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Apps with Live Todoist Data Using the Low-Code Development Platform of Mendix
Connect Todoist with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to and Visualize Live Dynamics 365 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics 365.
-
Automated Continuous QuickBooks Time Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Apache Cassandra.
-
Connect to Freshdesk Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Freshdesk from Filemaker Pro on Mac.
-
Getting Started with the CData ODBC Driver for Invoiced
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Invoiced.
-
Integrate Exact Online Data in Pentaho Data Integration
Build ETL pipelines based on Exact Online in the Pentaho Data Integration tool.
-
Deploy the ADO.NET Provider for OnePageCrm on an SSRS Report Server
Connect to OnePageCrm 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.
-
DataBind Controls to GitLab Data in Delphi
DataBind to GitLab in Delphi with standard data access components and controls.
-
Integrating LangChain with Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Lakebase within automated workflows.
-
Consume Box OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Box feeds that reflect any changes in SAP Lumira.
-
Automate Adobe Target Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Adobe Target from PowerShell? This article demonstrates how to utilize the Adobe Target Cmdlets for tasks like connecting to Adobe Target, automating operations, downloading data, and more.
-
Connect to MongoDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MongoDB.
-
Automate CapsuleCRM Data Replication to Azure Synapse
Use CData Sync to customize and automate CapsuleCRM replication to Azure Synapse.
-
DataBind Controls to Office 365 Data in Delphi
DataBind to Microsoft Office 365 in Delphi with standard data access components and controls.
-
Prepare, Blend, and Analyze Epicor Kinetic Data in Alteryx Designer (ODBC)
Build workflows to access live Epicor Kinetic for self-service data analytics.
-
How to connect and process Google Sheets from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Sheets.
-
Connect Square to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Square using the CData Python MCP Server.
-
Load Outreach.io Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Outreach.io to a database.
-
Visualize Live Zoho Inventory Data in the Power BI Service
Use CData Connect AI to connect to live Zoho Inventory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Act-On 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 Act-On for you.
-
Build Dashboards with Cloudant Data in Dundas BI
Create dynamic dashboards and perform analytics based on IBM Cloudant in Dundas BI.
-
Integrating Codex CLI with SAP SuccessFactors LMS 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.
-
Deploy the ADO.NET Provider for Access on an SSRS Report Server
Connect to Microsoft Access 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.
-
Automated Continuous Dotmailer Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Dotmailer replication to Apache Kafka.
-
Access Acumatica Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Acumatica ERP.
-
Edit and Search External Microsoft Dataverse Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Dataverse (CDS) to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Dataverse Data objects that you can access from apps and the dashboard.
-
Use the CData ODBC Driver for EmailOctopus in Microsoft Power Query
You can use the CData EmailOctopus ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import EmailOctopus into Microsoft Power Query.
-
Integrating FormSite Data in Talend Cloud Data Management Platform
Connect FormSite Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
CSV: Unable to Retrieve Columns for Table "csv"
In this entry you will find the resolution for the error: unable to retrieve columns for table "csv".
-
Build Dashboards with Placid Data in Dundas BI
Create dynamic dashboards and perform analytics based on Placid in Dundas BI.
-
Automated Continuous Float Replication to Vertica
Use CData Sync for automated, continuous, customizable Float replication to Vertica.
-
Access Discourse Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Discourse.
-
Use JayDeBeApi to access Google Ad Manager Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Ad Manager.
-
Use Grok to Talk to Your Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Atlassian Confluence for you.
-
Launch the CData Sync AMI on Amazon Web Services
Host the Java edition of CData Sync on Amazon Web Services using the CData Sync Amazon Machine Instance.
-
Use Grok to Talk to Your GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your GitLab for you.
-
Integrating Facebook Data in Talend Cloud Data Management Platform
Connect Facebook Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Facebook.
-
Integrate Sendwithus Data in the Pentaho Report Designer
Publish reports based on Sendwithus in the Pentaho BI tool.
-
How to Connect DBeaver to Samanage via a JDBC Driver
Manage Samanage with visual tools in DBeaver like the query browser.
-
Connect to YouTube Analytics Data from a Connection Pool in JBoss
Integrate YouTube Analytics into Java servlets: Use the Management Console in JBoss to install the YouTube Analytics JDBC Driver.
-
DataBind Controls to LDAP Objects in Delphi
DataBind to LDAP in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time BigCommerce Data
Use CData Power BI Connectors to visualize BigCommerce in Power BI.
-
Getting Started: Connect Claude to Your Data with CData Connect AI
Learn how to connect Claude to your live data sources using CData Connect AI and start asking questions about your data in natural language.
-
Query HubSpot Data in ColdFusion
Write standard ColdFusion data access code to connect to HubSpot.
-
Automated Continuous Amazon DynamoDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to PostgreSQL.
-
Integrating Claude Code CLI with Mouseflow 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 the CData Software ODBC Driver for Oracle Financials Cloud in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Financials Cloud in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Financials Cloud.
-
Connect to LinkedIn Data as an External Source in Dremio
Use the CData JDBC Driver to connect to LinkedIn as an External Source in Dremio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live ShipStation within intelligent workflows.
-
Operational Reporting on Cloudant Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote IBM Cloudant.
-
Connect to Shopify Data from PowerBuilder via JDBC
This article demonstrates how to access Shopify from PowerBuilder using the Shopify JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Freshservice
Provide connectivity to Freshservice through an SAP BusinessObjects universe.
-
Migrating data from ActiveCampaign to Databricks using CData SSIS Components.
Easily push ActiveCampaign to Databricks using the CData SSIS Tasks for ActiveCampaign and Databricks.
-
Connecting Moonlit Workflow with Raisers Edge NXT Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Raisers Edge NXT in real time.
-
Access Live Microsoft Ads Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Ads data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous MarkLogic Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MarkLogic replication to Google Cloud SQL.
-
Connect to and Visualize Live Flowlu Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Flowlu.
-
Choosing the Best Method to Connect Twilio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Twilio from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData SSIS Components to Insert New or Update Existing SingleStore Records from SQL Server
Easily push SQL Server data to SingleStore using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SingleStore or update existing records with data from a SQL Server database.
-
Connecting Mastra with Sybase IQ Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Sybase IQ, no replication required.
-
Create Informatica Mappings From/To a JDBC Data Source for Cohere
Create Cohere data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Deel Data as a MySQL Database in Node.js
Execute MySQL queries against Deel from Node.js.
-
Back Up Apache Kafka to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Kafka. In this article, we will employ an SSIS workflow to populate a database with Apache Kafka data.
-
Automate Azure Data Catalog Data Replication to Azure Data Lake
Use CData Sync to customize and automate Azure Data Catalog replication to Azure Data Lake.
-
Visualize Samanage Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Samanage.
-
Automated Continuous DB2 Replication to SQL Server
Use CData Sync for automated, continuous, customizable DB2 replication to SQL Server.
-
Establish a Live Connection with Todoist Data using Tableau Bridge
The CData ODBC Driver for Todoist enables you to integrate live Todoist into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Biml to Build SSIS Tasks to Replicate Coinbase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Coinbase to SQL Server.
-
How to create Visio diagrams from Exact Online Data
Automatically update Exact Online with the changes you make to Visio master shapes.
-
Integrating Claude Code with Excel Online Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Excel Online within assisted coding and automated development workflows.
-
Getting Started with the CData SSIS Components for Aweber
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Aweber.
-
Use JayDeBeApi to access Teamgate Data in Python
Use standard Python scripting and the development environment of your choice to access live Teamgate.
-
Natively Connect to Zuora Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zuora. Leverage the native support for ODBC in PHP.
-
Access Live ConvertKit Data in Coginiti Pro
Connect to and query live ConvertKit from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate SingleStore Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SingleStore from Informatica Cloud.
-
How to create an RPA flow for Helpscout Data in UiPath Studio
Use the Helpscout ODBC Driver to create workflows that access real-time Helpscout without any coding.
-
How to import Workday Data into Apache Solr
Use the CData Software JDBC Driver for Workday in Data Import Handler and create an automated import of Workday to Apache Solr Enterprise Search platform.
-
Connect to Authorize.Net Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Authorize.Net in Airbyte.