CData Software - Knowledge Base
Recent Articles
-
How to integrate SendInBlue with Apache Airflow
Access and process SendInBlue data in Apache Airflow using the CData JDBC Driver.
-
Integrating Dataiku with Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Splunk data.
-
How to Connect to Live QuickBooks Time Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your QuickBooks Time data for you.
-
Operational Reporting on PayPal Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PayPal data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle HCM Cloud
Provide connectivity to Oracle HCM Cloud data through an SAP BusinessObjects universe.
-
Integrating Claude Code with MySQL Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MySQL data within assisted coding and automated development workflows.
-
Publish ZeroBounce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZeroBounce data.
-
Getting Started with the CData JDBC Driver for SFTP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SFTP.
-
Rapidly Develop Trello-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 Trello.
-
Analyze Amazon Athena Data in Looker
Use CData Connect AI to connect to Amazon Athena Data from Looker and build custom apps using live Amazon Athena data.
-
Access Live Lakebase Data in Excel 365 Online (Excel for the web)
Connect to Lakebase data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Devin with Live SendGrid Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SendGrid data.
-
Migrating data from LinkedIn Ads to Databricks using CData SSIS Components.
Easily push LinkedIn Ads data to Databricks using the CData SSIS Tasks for LinkedIn Ads and Databricks.
-
Stream Optimizely Data into Apache Kafka Topics
Access and stream Optimizely data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to update Google Calendar from Excel
This article explains how to transfer data from Excel to Google Calendar using the Excel Add-In for Google Calendar.
-
Visualize Pipedrive Data in Tableau
The CData ODBC driver for Pipedrive enables you integrate Pipedrive data into Tableau dashboards.
-
Connect to Google Sheets Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Sheets and the Script function in FileMaker Pro to connect to Google Sheets and work with Google Sheets data in your FileMaker application.
-
Use ChatGPT to Talk to Your Highrise 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 Highrise data for you.
-
Integrate Amazon DynamoDB Data into Power Automate Desktop using CData Connect
CData Connect for Amazon DynamoDB Data enables you to integrate Amazon DynamoDB data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live SuiteCRM Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SuiteCRM data without replication.
-
Use the CData Software JDBC Driver for Certinia in MicroStrategy Desktop
Connect to Certinia data in MicroStrategy Desktop using the CData Software JDBC Driver for Certinia.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho CRM
Provide connectivity to Zoho CRM data through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live Pinterest Data in ThoughtSpot
Use CData Connect AI to connect to live Pinterest data for modeling, searching, and visualizing.
-
Integrating GitHub Copilot with Azure Data Catalog 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.
-
Build a Simple VCL Application for TigerGraph Data
How to build a simple VCL Application to view TigerGraph data in RAD Studio using the CData ODBC Driver for TigerGraph.
-
Integrate Live Demio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Demio data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize FormSite Data in Sisense
Create an ElastiCube in Sisense app with access to FormSite data.
-
Connect to Pingdom Data in NetBeans
Connect to Pingdom data in NetBeans with the data source configuration wizard.
-
Connect to and Visualize Live Mailgun Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mailgun data.
-
Getting Started with the CData Tableau Connector for HCL Domino
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for HCL Domino.
-
Integrating Claude Code with YouTube Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on YouTube Analytics data within assisted coding and automated development workflows.
-
Connect to FTP Data in DBArtisan
Use wizards in DBArtisan to configure FTP data as a data source.
-
Connect to SparkPost Data from PowerBuilder via JDBC
This article demonstrates how to access SparkPost data from PowerBuilder using the SparkPost JDBC Driver.
-
Automated Continuous Salesforce Pardot Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to MySQL.
-
Use the CData Software JDBC Driver for Timely in MicroStrategy Web
Connect to Timely data in MicroStrategy Web using the CData Software JDBC Driver for Timely.
-
Integrating LangGraph with Adobe Target Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Adobe Target data within automated workflows.
-
Excel Spreadsheet Automation on IBM Informix Data with the QUERY Formula
Pull data from IBM Informix, automate spreadsheets, and more with the QUERY formula.
-
How to Work with GraphQL Data in ETL Validator JDBC
Connect to GraphQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Basecamp Data from HeidiSQL
Use CData Connect AI to connect to and query live Basecamp data from HeidiSQL.
-
Automated Continuous Azure DevOps Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure DevOps replication to AlloyDB.
-
Easily Integrate Phoenix Data in Lazarus Pascal IDE
Learn how to easily integrate live Phoenix data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Oracle Service Cloud Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Service Cloud data. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to & Open Azure DevOps Data in Microsoft Excel
This article uses the CData ODBC driver for Azure DevOps to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Codex with NetSuite 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.
-
Create ConstantContact Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ConstantContact data access from reports, embedded analytics, and more.
-
Access Cosmos DB Data from MySQL in PHP
Connect to Cosmos DB through the standard MySQL libraries in PHP.
-
Replicate Apify Data from PowerShell
Write a quick PowerShell script to query Apify data. Use connectivity to the live data to replicate Apify data to SQL Server.
-
Use the CData Software JDBC Driver for Facebook in MicroStrategy Web
Connect to Facebook data in MicroStrategy Web using the CData Software JDBC Driver for Facebook.
-
Analyze Gmail Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Gmail data with the CData JDBC Driver for Gmail.
-
Automated Continuous HBase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HBase replication to Google Cloud SQL.
-
How to connect to GitHub Data in DBVisualizer
Integrate GitHub data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Access Freshteam Data Using Entity Framework
This article shows how to access Freshteam data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Odoo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Odoo Data and create custom apps in Mendix.
-
How to create an RPA flow for Box Data in UiPath Studio
Use the Box ODBC Driver to create workflows that access real-time Box data without any coding.
-
Visualize Monday.com Data in Sisense
Create an ElastiCube in Sisense app with access to Monday.com data.
-
Connect to Real-Time Printful Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Printful data in Power Apps.
-
Replicate Ontraport Data to Multiple Databases
Replicate Ontraport data to disparate databases with a point-and-click configuration.
-
Connect to HDFS Data in DBeaver
Use the CData ODBC Driver to connect to HDFS data in DBeaver.
-
Interact with Live Sendwithus Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Sendwithus data.
-
Validate ConvertAPI Data with QuerySurge
Access and validate ConvertAPI data in QuerySurge using the CData JDBC Driver.
-
Build MariaDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MariaDB data and build visualizations in Tableau Cloud.
-
Connect to Azure DevOps Data from AWS Glue
Use CData Connect AI to gain access to live Azure DevOps data from your AWS Glue jobs.
-
Integrate BigCommerce Data in Pentaho Data Integration
Build ETL pipelines based on BigCommerce data in the Pentaho Data Integration tool.
-
Visualize Live Anaplan Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Anaplan data.
-
Prepare, Blend, and Analyze PhantomBuster Data in Alteryx Designer (ODBC)
Build workflows to access live PhantomBuster data for self-service data analytics.
-
Automated Continuous Oracle Service Cloud Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Azure SQL Database.
-
Use the CData Software JDBC Driver for Gumroad in MicroStrategy Web
Connect to Gumroad data in MicroStrategy Web using the CData Software JDBC Driver for Gumroad.
-
Use ChatGPT to Talk to Your Office 365 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 Office 365 data for you.
-
Create Spark Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Spark from PowerBI.com to create Power BI Dataflows with real-time data.
-
Model, Search, and Visualize Live Sage Cloud Accounting Data in ThoughtSpot
Use CData Connect AI to connect to live Sage Cloud Accounting data for modeling, searching, and visualizing.
-
How to Connect to & Open Suadeo Data in Microsoft Excel
This article uses the CData ODBC driver for Suadeo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Gumroad Replication to Databricks
Use CData Sync for automated, continuous, customizable Gumroad replication to Databricks.
-
Access Live ServiceNow Data in TIBCO Data Virtualization
Use the ServiceNow Tibco DV Adapter to create a ServiceNow data data source in TIBCO Data Virtualization Studio and gain access to live ServiceNow data from your TDV Server.
-
Connect to BambooHR Data in CloverDX (formerly CloverETL)
Transfer BambooHR data using the visual workflow in the CloverDX data integration tool.
-
Consume BigQuery OData Feeds in PowerBuilder
This article demonstrates how to consume BigQuery data as OData feeds from PowerBuilder using the API Server.
-
How to Connect to ClickTime Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ClickTime data. Leverage the pyodbc module for ODBC in Python.
-
Integrate SAP Concur Data into Power Automate Desktop using CData Connect
CData Connect for SAP Concur Data enables you to integrate SAP Concur data into workflows built using Microsoft Power Automate Desktop.
-
Work with Azure Data Catalog Data in FoxPro
Load Azure Data Catalog data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Build an ETL App for XML Data in Python with CData
Create ETL applications and real-time data pipelines for XML data in Python with petl.
-
Use the CData Software JDBC Driver for Reckon in MicroStrategy Desktop
Connect to Reckon data in MicroStrategy Desktop using the CData Software JDBC Driver for Reckon.
-
Publish Reports with Pinecone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinecone data.
-
How to use SQLAlchemy ORM to access SAP SuccessFactors LMS Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP SuccessFactors LMS data.
-
Create a Data Access Object for CapsuleCRM Data using JDBI
A brief overview of creating a SQL Object API for CapsuleCRM data in JDBI.
-
Use JayDeBeApi to access Microsoft Teams Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Teams data.
-
How to Connect to Live Basecamp Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Basecamp data for you.
-
Integrate OpenCode with Live GitLab Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live GitLab data from within your AI coding agent.
-
A PostgreSQL Interface for Basecamp Data using the CData ODBC Driver
Use the SQL Gateway and Basecamp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for SharePoint in PyCharm
Connect to SharePoint as an ODBC data source in PyCharm using the CData Software ODBC Driver for SharePoint.
-
Build an OLAP Cube in SSAS from BambooHR Data
Establish a connection to BambooHR data data from SQL Server Analysis Services, and use the BambooHR Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Epicor Kinetic Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Epicor Kinetic data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to publish and share Avro Data dashboards with Tableau Server
The CData ODBC driver for Avro enables you integrate Avro data into Tableau dashboards.
-
How to Work with SharePoint Data in AWS Glue Jobs Using JDBC
Connect to SharePoint from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Reports with Apollo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apollo data.
-
Integrate with Shopify Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Shopify data to a JSON file on disk.
-
How to Connect to Live eBay Analytics Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live eBay Analytics data securely in real time.
-
Visualize Live GraphQL Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live GraphQL data.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy
Connect to Zoom data in MicroStrategy Developer using the CData Software JDBC Driver for Zoom.
-
How to use SQLAlchemy ORM to access Keap Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Keap data.
-
Build AI/ML Models with Live ScrapingBee Data using Dataiku
Connect ScrapingBee Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Antigravity CLI with Gmail data via CData CLI
Connect Gmail data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.