CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to MailerSend Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MailerSend in Filemaker Pro for Mac or Windows.
-
Integrating Kiro CLI with Paddle 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.
-
Analyze Google Ads Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Ads with the CData JDBC Driver for Google Ads.
-
Access Live Google Directory Data in AWS Lambda
Connect to live Google Directory in AWS Lambda using the CData JDBC Driver.
-
How to Connect Flowise AI Agents to Live Salesforce Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Salesforce & Force.com without replication.
-
Create Trello Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Trello data access from reports, embedded analytics, and more.
-
Replicate Reckon Data in Heroku for Use in Salesforce Connect
Replicate Reckon to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind LeadDesk Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide LeadDesk to a chart.
-
Replicate LDAP Objects to Multiple Databases
Replicate LDAP to disparate databases with a point-and-click configuration.
-
Replicate Bannerbear Data from PowerShell
Write a quick PowerShell script to query Bannerbear. Use connectivity to the live data to replicate Bannerbear to SQL Server.
-
Create SSAS Tabular Models from Workable Data
How to build a SQL Server Analysis Service Tabular Model from Workable using CData drivers.
-
Automated Continuous Freshdesk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Freshdesk replication to Azure SQL Database.
-
How to Connect to Live Procore Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Procore for you.
-
Connect to Slack Data in Google Apps Script via Connect AI
Use CData Connect AI to access Slack in Google Apps Script.
-
Access Live ADP Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live ADP data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Import and Visualize Klipfolio Data in Power View
Create data visualizations based on Klipfolio in Excel.
-
Create SSAS Tabular Models from BenchmarkEmail Data
How to build a SQL Server Analysis Service Tabular Model from BenchmarkEmail using CData drivers.
-
Use the CData Software JDBC Driver for Testmonitor in MicroStrategy
Connect to Testmonitor in MicroStrategy Developer using the CData Software JDBC Driver for Testmonitor.
-
Access Live Office 365 Data in TIBCO Data Virtualization
Use the Office 365 Tibco DV Adapter to create a Microsoft Office 365 data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Office 365 from your TDV Server.
-
Connect to Salesforce Data 360 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesforce Data 360 to connect to Salesforce Data 360 and execute queries in PowerBuilder.
-
Use Manus AI to Talk to Your Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Square.
-
Publish Crystal Reports on CampaignMonitor Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CampaignMonitor.
-
Analyze Accelo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Accelo with the CData JDBC Driver for Accelo.
-
Build Voice Agents in ElevenLabs with access to Live Impala Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apache Impala.
-
Import Real-Time ServiceDesk Plus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ServiceDesk Plus in ColdFusion.
-
Choosing the Best Method to Connect CloudConvert to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CloudConvert from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Hive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Hive. Leverage the pyodbc module for ODBC in Python.
-
Create Dynamic Calendly Grids Using the Infragistics XamDataGrid
Learn how you can connect Calendly to Infragistics XamDataGrid to build dynamic grids.
-
How to Access Dynamics NAV Data Using Entity Framework
This article shows how to access Microsoft Dynamics NAV using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Biml to Build SSIS Tasks to Replicate Impala Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Impala to SQL Server.
-
Load Rebilly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Rebilly to a database.
-
Automated Continuous CouchDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable CouchDB replication to MongoDB.
-
Publish Reports with Anaplan Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Anaplan.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for NASA
Provide connectivity to NASA through an SAP BusinessObjects universe.
-
How to connect and process Printify from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Printify.
-
Integrating OpenCode Terminal with Amplitude 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.
-
How to publish and share Oracle HCM Cloud Data dashboards with Tableau Server
The CData ODBC driver for Oracle HCM Cloud enables you integrate Oracle HCM Cloud into Tableau dashboards.
-
Establish a Live Connection with Trello Data using Tableau Bridge
The CData ODBC Driver for Trello enables you to integrate live Trello into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live SAP ByDesign Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SAP Business ByDesign for you.
-
How to Create Power BI Visual Reports with Real-Time Recurly Data
Use CData Power BI Connectors to visualize Recurly in Power BI.
-
Use the CData Software ODBC Driver for Calendly in MicroStrategy
Connect to Calendly in MicroStrategy Developer using the CData Software ODBC Driver for Calendly.
-
Connect to Avro Data from HeidiSQL
Use CData Connect AI to connect to and query live Apache Avro from HeidiSQL.
-
How to create an RPA flow for HCL Domino Data in UiPath Studio
Use the HCL Domino ODBC Driver to create workflows that access real-time HCL Domino without any coding.
-
How to Connect to Live Vault CRM Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Veeva Vault & Vault CRM through natural language.
-
Build Data Flows from Auth0 to SQL Server using SSIS
Easily back up Auth0 to SQL Server using the SSIS components for Auth0.
-
A PostgreSQL Interface for Office 365 Data using the CData ODBC Driver
Use the SQL Gateway and Office 365 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with Cohere Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cohere.
-
Build a PostgreSQL Interface for ElevenLabs Data using the CData JDBC Driver
Use the Remoting features of the ElevenLabs JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Excel Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Excel to connect to Microsoft Excel and execute queries in PowerBuilder.
-
Getting Started with the CData Excel Add-In for Mailjet
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mailjet.
-
Use Claude to Talk to Your Tally 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 Tally ERP for you.
-
Create Datasets from GitLab in Domo Workbench and Build Visualizations of GitLab Data in Domo
Use the CData Software ODBC Driver for GitLab to create datasets from GitLab in Domo Workbench and then build visualizations in the Domo service.
-
Visualize SurveyMonkey Data in TIBCO Spotfire through OData
Integrate SurveyMonkey into dashboards in TIBCO Spotfire.
-
How to Connect Flowise AI Agents to Live Hive Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Apache Hive without replication.
-
Automated Continuous SuiteCRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable SuiteCRM replication to SQL Server.
-
Enable the ElevenLabs JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ElevenLabs.
-
Working with Todoist Data in LINQPad
Execute LINQ queries to Todoist in LINQPad.
-
Use ChatGPT to Talk to Your FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your FreshBooks for you.
-
Automated Continuous Avro Replication to Databricks
Use CData Sync for automated, continuous, customizable Avro replication to Databricks.
-
Replicate Multiple Pingdom Accounts via the CData Sync CLI
Replicate multiple Pingdom accounts to one or many databases.
-
How to Create Power BI Visual Reports with Real-Time SAP BusinessObjects BI Data
Use CData Power BI Connectors to visualize SAP BusinessObjects BI in Power BI.
-
Import SAS Data Sets Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAS Data Sets Data and provide access to live SAS Data Sets for custom reports in the Power BI Service.
-
Build MariaDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MariaDB and build web apps with connectivity to live MariaDB.
-
Create Slack Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Slack from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Google Tasks Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Tasks replication to Vertica.
-
Connect to Live Splunk Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Splunk in CData Connect AI and connect to your Splunk from PostgreSQL.
-
Work with Grafana Data in FoxPro
Load Grafana into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To an ODBC Data Source for Asana
Create an ODBC connection to Asana in Informatica and browse and transfer Asana.
-
Import Highrise Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Highrise CRM. In this article, you will use the OData format to import Highrise CRM into Microsoft Power Query.
-
Replicate Multiple Teradata Accounts via the CData Sync CLI
Replicate multiple Teradata accounts to one or many databases.
-
Automated Continuous Greenhouse Replication to Snowflake
Use CData Sync for automated, continuous, customizable Greenhouse replication to Snowflake.
-
Integrate Goose with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Ariba Source from within the local AI agent.
-
Connect to Kintone Data from a Connection Pool in JBoss
Integrate Kintone into Java servlets: Use the Management Console in JBoss to install the Kintone JDBC Driver.
-
How to Connect DBeaver to Superchat via a JDBC Driver
Manage Superchat with visual tools in DBeaver like the query browser.
-
Working with Dynamics 365 Data in LINQPad
Execute LINQ queries to Microsoft Dynamics 365 in LINQPad.
-
Connect to LDAP Objects in the Denodo Platform
Use CData driver technologies to create a virtual data source for LDAP in the Denodo Virtual DataPort Administrator.
-
Establish a Live Connection with Google Drive Data using Tableau Bridge
The CData ODBC Driver for Google Drive enables you to integrate live Google Drive into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Automated Workflows with Live BigCommerce Data in Workato
Use CData Connect AI to connect to live BigCommerce and build automated workflows in Workato.
-
Connect to ZohoPeople in SpagoBI
Create reports featuring live ZohoPeople in SpagoBI Studio. Host ZohoPeople reports on SpagoBI Server.
-
DataBind Controls to EmailOctopus Data in C++Builder
DataBind to EmailOctopus in C++Builder with standard components and controls.
-
Build Couchbase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Couchbase.
-
How to create Visio diagrams from Vault CRM Data
Automatically update Veeva Vault & Vault CRM with the changes you make to Visio master shapes.
-
How to Query Live FTP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live FTP Servers data in natural language using Python.
-
Prepare, Blend, and Analyze SharePoint Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft SharePoint for self-service data analytics.
-
Import Real-Time Tanda Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Tanda in ColdFusion.
-
Extract, Transform, and Load Parquet Data in Informatica PowerCenter
Create a simple Workflow for Apache Parquet in Informatica PowerCenter.
-
Build Dashboards with Acumatica Data in Dundas BI
Create dynamic dashboards and perform analytics based on Acumatica ERP in Dundas BI.
-
Create a Data Access Object for HDFS Data using JDBI
A brief overview of creating a SQL Object API for Apache HDFS in JDBI.
-
Connect and Query Live Reckon Accounts Hosted Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Reckon Accounts Hosted into Databricks
-
Connect to Cassandra Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cassandra to connect to Apache Cassandra and execute queries in PowerBuilder.
-
Connect to Adobe Target Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Target and the SQL Gateway to access Adobe Target from Google Apps Script.
-
Use Biml to Build SSIS Tasks to Replicate HDFS Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache HDFS to SQL Server.
-
Use the CData Software ODBC Driver for Azure Analysis Services in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Analysis Services in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Analysis Services.
-
How to connect to Mocean Data with Squirrel SQL client
Connect to Mocean and execute queries in the Squirrel SQL Client.
-
Query GetResponse Data in ColdFusion
Write standard ColdFusion data access code to connect to GetResponse.
-
Getting Started with the CData Tableau Connector for Humanity
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate MailerSend Data in the Pentaho Report Designer
Publish reports based on MailerSend in the Pentaho BI tool.
-
Access Live Zoho Books Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Books from your Excel spreadsheets.
-
Query Beeminder Data in ColdFusion
Write standard ColdFusion data access code to connect to Beeminder.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BenchmarkEmail
Provide connectivity to BenchmarkEmail through an SAP BusinessObjects universe.