CData Software - Knowledge Base
Recent Articles
-
Add HCL Domino Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HCL Domino with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for Exa on an SSRS Report Server
Connect to Exa 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.
-
Connect to SQL Server Data in Ruby
Connect to Microsoft SQL Server in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to OData Services from AWS Glue
Use CData Connect AI to gain access to live OData from your AWS Glue jobs.
-
Build AI/ML Models with Live FTP Data using Dataiku
Connect FTP Data with Dataiku using the CData JDBC Driver for FTP.
-
Automated Continuous Google Campaign Manager 360 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MongoDB.
-
Connect to Zoho Recruit Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Recruit in the Denodo Virtual DataPort Administrator.
-
Natively Connect to AfterShip Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to AfterShip. Leverage the native support for ODBC in PHP.
-
Load Bugsnag Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bugsnag to a database.
-
Connect to ZarMoney from Asprova with CData Software ODBC Driver for ZarMoney
This article shows how to connect faster to ZarMoney data from Asprova.
-
Access Live Snapchat Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Snapchat Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Agents in Relevance AI with Access to Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sybase IQ within intelligent agent workflows.
-
A PostgreSQL Interface for Google Campaign Manager 360 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Campaign Manager 360 JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live BigQuery Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google BigQuery for you.
-
Access Live Beeminder Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Beeminder in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Google Ads 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 Ads.
-
Build Data Flows from Opsgenie to SQL Server using SSIS
Easily back up Opsgenie to SQL Server using the SSIS components for Opsgenie.
-
Moving Data from Printful to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Printful data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build a PostgreSQL Interface for Egnyte Data using the CData JDBC Driver
Use the Remoting features of the Egnyte JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Mixpanel 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 Mixpanel.
-
Build a Singer.io Tap for Ontraport With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Ontraport data using
-
DataBind Controls to Chargebee Data in Delphi
DataBind to Chargebee in Delphi with standard data access components and controls.
-
Connect and Visualize Live Vertica Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Vertica into the Databricks platform and create visualization dashboards with real-time Vertica.
-
Write a Simple Go Application to work with Microsoft OneDrive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft OneDrive.
-
Operational Reporting on Hubstaff Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Hubstaff.
-
Deploy the ADO.NET Provider for Dynamics CRM on an SSRS Report Server
Connect to Microsoft Dynamics CRM 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.
-
Access Live Raisers Edge NXT Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Raisers Edge NXT from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Boomi Agentstudio with Google Search Results via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Search, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData Excel Add-In for Aha!
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Aha!.
-
Connect to CapsuleCRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CapsuleCRM.
-
Automated Continuous Egnyte Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Egnyte replication to Amazon Redshift.
-
Automated Continuous Sybase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sybase replication to AlloyDB.
-
Opsgenie Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Opsgenie facts in real time.
-
Connect to Email Data in Claris FileMaker Pro
Use the CData ODBC Driver for Email in FileMaker Pro to connect to Email and work with Email in your FileMaker applications.
-
Publish CockroachDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CockroachDB.
-
Connect to and Query eBay Analytics Data in QlikView over ODBC
Create data visualizations with eBay Analytics in QlikView.
-
Validate Gong Data with QuerySurge
Access and validate Gong in QuerySurge using the CData JDBC Driver.
-
Use ChatGPT to Talk to Your Greenhouse 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 Greenhouse for you.
-
Replicate Authorize.Net Data to Multiple Databases
Replicate Authorize.Net to disparate databases with a point-and-click configuration.
-
Create a Data Access Object for Gorgias Data using JDBI
A brief overview of creating a SQL Object API for Gorgias in JDBI.
-
Integrate Theia IDE with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automate Invoiced Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Invoiced from PowerShell? This article demonstrates how to utilize the Invoiced Cmdlets for tasks like connecting to Invoiced, automating operations, downloading data, and more.
-
Integrating Claude Code with Jira Assets Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Jira Assets within assisted coding and automated development workflows.
-
How to integrate ClickUp with Apache Airflow
Access and process ClickUp in Apache Airflow using the CData JDBC Driver.
-
Build Automated Salesforce Pardot-Connected Workflows in Zapier
Use CData Connect AI to connect to live Salesforce Pardot and build automated workflows in Zapier.
-
How to load Calendly data into Elasticsearch via Logstash
Introducing a simple method to load Calendly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for CircleCI from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CircleCI to connect to CircleCI from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CircleCI in Excel.
-
Visualize iContact Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load iContact into TIBCO Spotfire.
-
Use JayDeBeApi to access Invoiced Data in Python
Use standard Python scripting and the development environment of your choice to access live Invoiced.
-
Create Data Visualizations Based On SAP SuccessFactors Data in Mode
Use CData Connect AI to connect to SAP SuccessFactors Data from Mode and build visualizations using live
-
Connect to FormSite Data in RapidMiner
Integrate FormSite with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Multiple LinkedIn Ads Accounts via the CData Sync CLI
Replicate multiple LinkedIn Ads accounts to one or many databases.
-
Build Automated Asana-Connected Workflows in Zapier
Use CData Connect AI to connect to live Asana and build automated workflows in Zapier.
-
Use Agno to Talk to Your Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Couchbase for you.
-
Connect to SendGrid Data from a Connection Pool in Jetty
The SendGrid JDBC Driver supports connection pooling: This article shows how to connect faster to SendGrid from Web apps in Jetty.
-
Use the CData Software JDBC Driver for Todoist in MicroStrategy Web
Connect to Todoist in MicroStrategy Web using the CData Software JDBC Driver for Todoist.
-
Connect to Todoist Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Todoist using standard SQL.
-
Use the CData ODBC Driver for Planio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Planio to connect to Planio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Planio in Excel.
-
Query Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics directly from the development environment.
-
Create Informatica Mappings From/To an ODBC Data Source for HDFS
Create an ODBC connection to HDFS in Informatica and browse and transfer Apache HDFS.
-
Create Perplexity Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Perplexity data access from reports, embedded analytics, and more.
-
Connect to Microsoft Teams Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Teams in DBeaver.
-
Publish Crystal Reports on CockroachDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CockroachDB.
-
DataBind Office 365 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Office 365 with the DevExpress Windows Forms and Web controls to provide Microsoft Office 365 to a chart.
-
How to Connect the Power BI Service to BambooHR: Complete Guide
Connect to the CData Software Power BI Connector for BambooHR from PowerBI.com to provide real-time BambooHR across the organization.
-
Integrate with Highrise Data in JReport Designer
Create charts and reports based on Highrise CRM in JReport Designer.
-
DataBind Controls to Google Sheets Data in Delphi
DataBind to Google Sheets in Delphi with standard data access components and controls.
-
Automated Continuous Perplexity Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Perplexity replication to Amazon Redshift.
-
Integrate Freshsales Data in Pentaho Data Integration
Build ETL pipelines based on Freshsales in the Pentaho Data Integration tool.
-
Integrate Real-Time Access to SAS Data Sets in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAS Data Sets in real time.
-
Access Live Rebilly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Rebilly in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import and Visualize YouTube Analytics Data in Power View
Create data visualizations based on YouTube Analytics in Excel.
-
Create Data Visualizations in Cognos BI with Microsoft Teams Data
Access Microsoft Teams as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Back Up Vercel to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Vercel data.
-
How to use SQLAlchemy ORM to access SAP Ariba Source Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Ariba Source.
-
How to Work with Greenhouse Data in ETL Validator JDBC
Connect to Greenhouse from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating GitHub Copilot CLI with Apache Kafka 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.
-
Integrating LlamaIndex with Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoho Projects in real time.
-
Analyze Paylocity Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Paylocity and visualize live Paylocity in Infragistics Reveal.
-
Natively Connect to Bullhorn CRM Data in PHP
The CData ODBC driver for Bullhorn CRM enables you to create PHP applications with connectivity to Bullhorn CRM. Leverage the native support for ODBC in PHP.
-
Process & Analyze Workday Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Workday Data.
-
Visualize Live Azure Synapse Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Azure Synapse into custom reports in Power BI.
-
Connect to Freshservice Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Freshservice and work with Freshservice in your FileMaker applications.
-
How to Connect the Power BI Service to Gmail: Complete Guide
Connect to the CData Software Power BI Connector for Gmail from PowerBI.com to provide real-time Gmail across the organization.
-
Build Semantic Layer Views for Mailjet Data in APOS Live Data Gateway
Use the CData Connector for Mailjet in APOS Live Data Gateway to build Semantic Layer Views for Mailjet.
-
How to Connect to Perplexity Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Perplexity. Leverage the pyodbc module for ODBC in Python.
-
Build a PostgreSQL Interface for Jira Assets Data using the CData JDBC Driver
Use the Remoting features of the Jira Assets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Pipedrive Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipedrive.
-
Create Reports from Cloudant Data in Looker Studio
Use CData Connect AI to gain access to live IBM Cloudant and create custom reports in Looker Studio.
-
How to Access Live Beeminder Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Beeminder enables you to integrate Beeminder into workflows built using Microsoft Power Automate Desktop.
-
How to Seamlessly Import Drift Data into IBM SPSS Modeler
Integrate Drift data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Zoho Inventory Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Inventory as an External Source in Dremio.
-
Migrating data from Printful to Google BigQuery using CData SSIS Components.
Easily push Printful to Google BigQuery using the CData SSIS Tasks for Printful and Google BigQuery.
-
Load SageHR Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SageHR to a database.
-
How to Seamlessly Import Typeform Data into IBM SPSS Modeler
Integrate Typeform data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Cursor with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Eloqua from within the editor.
-
How to Query Sybase Data in MySQL Workbench
Execute MySQL queries against live Sybase from MySQL Workbench.
-
How to Connect the Power BI Service to Wrike: Complete Guide
Connect to the CData Software Power BI Connector for Wrike from PowerBI.com to provide real-time Wrike across the organization.
-
Automated Continuous Drip Replication to MySQL
Use CData Sync for automated, continuous, customizable Drip replication to MySQL.
-
Integrating Antigravity CLI with Foursquare via CData CLI
Connect Foursquare to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.