CData Software - Knowledge Base
Recent Articles
-
Integrating GitHub Copilot CLI with Printful 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.
-
How to publish and share Reckon Accounts Hosted Data dashboards with Tableau Server
The CData ODBC driver for Reckon Accounts Hosted enables you integrate Reckon Accounts Hosted into Tableau dashboards.
-
Write a Simple Go Application to work with Mouseflow Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mouseflow.
-
Use Grok to Talk to Your ActiveCampaign 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 ActiveCampaign for you.
-
Automated Continuous Neo4J Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Neo4J replication to Apache Kafka.
-
How to Access Live CockroachDB Data in Visual Studio Code via Cline
Run CData MCP Server for CockroachDB on Windows Subsytem for Linux (WSL) and connect to live CockroachDB from the Cline extension in Visual Studio Code.
-
Connect to Active Directory Data from Crystal Reports
Use CData Connect AI to connect to and report on live Active Directory from Crystal Reports.
-
Create Informatica Mappings From/To an ODBC Data Source for Redis
Create an ODBC connection to Redis in Informatica and browse and transfer Redis.
-
Connect to Copper Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Copper to connect to Copper and execute queries in PowerBuilder.
-
Working with Salesforce Data in LINQPad
Execute LINQ queries to Salesforce & Force.com in LINQPad.
-
Automated Continuous LDAP Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LDAP replication to Amazon Redshift.
-
How to Connect DBeaver to Office 365 via a JDBC Driver
Manage Microsoft Office 365 with visual tools in DBeaver like the query browser.
-
Automate ShipEngine Data Replication to Azure Data Lake
Use CData Sync to customize and automate ShipEngine replication to Azure Data Lake.
-
Connect Foursquare to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Foursquare with IBM WebSphere for seamless data integration and connectivity.
-
How to connect and process WooCommerce from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live WooCommerce.
-
Configure the CData JDBC Driver for QuickBooks in a Connection Pool in Tomcat
Connect to QuickBooks Desktop from a connection pool in Tomcat.
-
Connect PostgreSQL Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PostgreSQL using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData ADO.NET Provider for Twilio
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Twilio.
-
How to import Mailjet Data into Apache Solr
Use the CData Software JDBC Driver for Mailjet in Data Import Handler and create an automated import of Mailjet to Apache Solr Enterprise Search platform.
-
ETL Avro in Oracle Data Integrator
This article shows how to transfer Apache Avro into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Connect AI Python SDK for IBM Cloud Object Storage
Install the CData Connect AI Python SDK to read and write live IBM Cloud Object Storage with standard DB-API 2.0 Python code.
-
Connect to ClickUp Data from a Connection Pool in JBoss
Integrate ClickUp into Java servlets: Use the Management Console in JBoss to install the ClickUp JDBC Driver.
-
Build Facebook-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Facebook and build Facebook-connected web apps with Axios.
-
Use Microsoft Copilot Studio to talk to your Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Authorize.Net for you.
-
Integrate Impala Data in the Pentaho Report Designer
Publish reports based on Apache Impala in the Pentaho BI tool.
-
Access Stripe Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Stripe from your Oracle system.
-
Prepare, Blend, and Analyze Dynamics CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Dynamics CRM for self-service data analytics.
-
How to Seamlessly Import Google Search Data into IBM SPSS Modeler
Integrate Google Search data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous LinkedIn Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to SQLite.
-
Build Salesforce Data 360-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Salesforce Data 360 to explore live Salesforce Data 360 Data in Gemini Code Assist to assist with building Salesforce Data 360-powered applications.
-
Build ADP-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ADP Data and create custom apps in Bubble.
-
Build Voice Agents in ElevenLabs with access to Live Power BI XMLA Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Power BI XMLA.
-
Query Exact Online Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Exact Online entities in PHP by modeling them as objects.
-
ETL SAP Business One in Oracle Data Integrator
This article shows how to transfer SAP Business One into a data warehouse using Oracle Data Integrator.
-
Prepare, Blend, and Analyze Cloudflare Data in Alteryx Designer (ODBC)
Build workflows to access live Cloudflare for self-service data analytics.
-
Connect to Salesloft Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesloft in the Denodo Virtual DataPort Administrator.
-
Connect to HubDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access HubDB from Appeon PowerBuilder using the CData ADO.NET Provider for HubDB.
-
Getting Started with the CData Connect AI Python SDK for Apollo
Install the CData Connect AI Python SDK to read and write live Apollo with standard DB-API 2.0 Python code.
-
How to work with ZohoPeople Data in Apache Spark using SQL
Access and process ZohoPeople Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Kintone Data from PowerBuilder via ADO.NET
This article demonstrates how to access Kintone from Appeon PowerBuilder using the CData ADO.NET Provider for Kintone.
-
Connect to ShipStation Data in Aqua Data Studio
Access ShipStation from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bridge Pinecone Connectivity with Apache NiFi
Access and process Pinecone in Apache NiFi using the CData JDBC Driver.
-
Connect to Real-Time FTP Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for FTP and Dataflow to import and use FTP Servers in Power Apps.
-
Visualize CampaignMonitor Data in Tableau
The CData ODBC driver for CampaignMonitor enables you integrate CampaignMonitor into Tableau dashboards.
-
Analyze FreshBooks Data in Cognos Analytics
Use CData Connect AI to connect to FreshBooks Data from Cognos Analytics and analyze live FreshBooks.
-
Build Dashboards with Airtable Data in Dundas BI
Create dynamic dashboards and perform analytics based on Airtable in Dundas BI.
-
Integrate with ZohoPeople Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoPeople to a JSON file on disk.
-
How to connect Amazon QuickSight to Asana Data
Create a connection to Asana in CData Connect AI and insert Asana into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Charts with Google Sheets Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Sheets in Clear Analytics.
-
Working with Square Data in LINQPad
Execute LINQ queries to Square in LINQPad.
-
Connect to Omnisend Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Omnisend using standard SQL.
-
Getting Started with the CData Python Connector for Mode
Learn to install and license the CData Python Connector
-
Connect to Pipeliner CRM Data in JRuby
Create a simple JRuby app with access to live Pipeliner CRM.
-
Connect to and Query Freshsales Data in QlikView over ODBC
Create data visualizations with Freshsales in QlikView.
-
Validate Timely Data with QuerySurge
Access and validate Timely in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live MariaDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MariaDB securely in real time.
-
Feed Helpscout Data into FineReport
How to set Helpscout as a JDBC data source in FineReport.
-
How to create Mailgun federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mailgun in MySQL .
-
ETL Sage 200 in Oracle Data Integrator
This article shows how to transfer Sage 200 into a data warehouse using Oracle Data Integrator.
-
Connect to and Query Moosend Data in QlikView over ODBC
Create data visualizations with Moosend in QlikView.
-
DataBind Charts to Bitly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bitly 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.
-
Create SSAS Tabular Models from QuickBooks Data
How to build a SQL Server Analysis Service Tabular Model from QuickBooks Desktop using CData drivers.
-
How to Easily Query MessageBird Data in OpenOffice Base
Connect to MessageBird data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Databricks Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Databricks replication to Google Cloud SQL.
-
Automated Continuous Monday.com Replication to MySQL
Use CData Sync for automated, continuous, customizable Monday.com replication to MySQL.
-
Integrate SAP Ariba Source Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Ariba Source and integrate live SAP Ariba Source into your Power Automate tasks.
-
How to connect to Timely Data with Squirrel SQL client
Connect to Timely and execute queries in the Squirrel SQL Client.
-
Integrating Cursor CLI with Aircall 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.
-
Connecting Agentforce with FHIR 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 FHIR for you.
-
Visualize Live Salesforce Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesforce & Force.com.
-
Natively Connect to Neo4J Data in PHP
The CData ODBC driver for Neo4J enables you to create PHP applications with connectivity to Neo4J. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Tableau Connector for MongoDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for MongoDB.
-
Automate Strava Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Strava from PowerShell? This article demonstrates how to utilize the Strava Cmdlets for tasks like connecting to Strava, automating operations, downloading data, and more.
-
How to Access Live Azure Table Data in Visual Studio Code via Cline
Run CData MCP Server for Azure Table on Windows Subsytem for Linux (WSL) and connect to live Azure Table Storage from the Cline extension in Visual Studio Code.
-
Integrate Oracle Eloqua Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Eloqua in the Pentaho Data Integration tool.
-
Consume SFTP OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SFTP feeds that reflect any changes in SAP Lumira.
-
Build Agents in Relevance AI with Access to Live Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Search within intelligent agent workflows.
-
Connect to and Query Everhour Data in QlikView over ODBC
Create data visualizations with Everhour in QlikView.
-
Process & Analyze SAP Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Data.
-
Connecting Pipedream with Oracle Service Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Oracle Service Cloud data in real time.
-
Integrate Vercel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Vercel with External Services.
-
How to create an RPA flow for Mixpanel Data in UiPath Studio
Use the Mixpanel ODBC Driver to create workflows that access real-time Mixpanel without any coding.
-
Choosing the Best Method to Connect Azure Data Lake Storage to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure Data Lake Storage from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Query Live Teamwork Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Teamwork data in natural language using Python.
-
Viewing PolarTeamPro Data in RAD Studio Data Explorer
How to view PolarTeamPro in RAD Studio Data Explorer using the CData ODBC Driver for PolarTeamPro.
-
Build Cvent-Connected Apps in Choreo
Use CData Connect AI to connect to Cvent Data from Choreo and build custom apps using live Cvent.
-
How to integrate Templated with Apache Airflow
Access and process Templated in Apache Airflow using the CData JDBC Driver.
-
Stream Copper Data into Apache Kafka Topics
Access and stream Copper in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Google Analytics Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Analytics in FileMaker Pro to connect to Google Analytics and work with Google Analytics in your FileMaker applications.
-
Build Cloudant-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Cloudant to explore live Cloudant Data in Cursor to assist with building Cloudant-powered applications.
-
Integrate Cursor with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Xero Accounting from within the editor.
-
Creating HubSpot-Connected Applications in Unqork
You can use CData Connect AI to feed HubSpot to Unqork and build custom business apps.
-
Create Reports from Klaviyo Data in Looker Studio
Use CData Connect AI to gain access to live Klaviyo and create custom reports in Looker Studio.
-
How to Query Live BigCommerce Data in Perplexity MacOS Desktop
Connect to and query live BigCommerce Data in Perplexity Desktop using CData MCP Server.
-
Create SSAS Tabular Models from Amazon Athena Data
How to build a SQL Server Analysis Service Tabular Model from Amazon Athena using CData drivers.
-
Getting Started with the CData Power BI Connector for Jira
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Jira.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Azure Table actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Exact Online Data in NetBeans
Connect to Exact Online in NetBeans with the data source configuration wizard.
-
Create Couchbase-Connected Nintex Workflows
Use CData Connect AI to connect to Couchbase Data from Nintex Workflow Cloud and build custom workflows using live Couchbase.
-
Integrate Coinbase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Coinbase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Coinbase.