CData Software - Knowledge Base
Recent Articles
-
Back Up Lakebase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Lakebase. In this article, we will employ an SSIS workflow to populate a database with Lakebase data.
-
Connect to Missive Data in HULFT Integrate
Connect to Missive as a JDBC data source in HULFT Integrate
-
Automated Continuous FormSite Replication to Vertica
Use CData Sync for automated, continuous, customizable FormSite replication to Vertica.
-
Import QuickBooks Online Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to QuickBooks Online Data and provide access to live QuickBooks Online for custom reports in the Power BI Service.
-
Extract, Transform, and Load Intercom Data in Informatica PowerCenter
Create a simple Workflow for Intercom in Informatica PowerCenter.
-
Automated Continuous Asana Replication to Snowflake
Use CData Sync for automated, continuous, customizable Asana replication to Snowflake.
-
Connect to SQL Server Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft SQL Server from Crystal Reports.
-
Build a PostgreSQL Interface for Trello Data using the CData JDBC Driver
Use the Remoting features of the Trello JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Mixpanel with Apache Airflow
Access and process Mixpanel in Apache Airflow using the CData JDBC Driver.
-
Connect to Zoho CRM Data in Ruby
Connect to Zoho CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Square Data from HeidiSQL
Use CData Connect AI to connect to and query live Square from HeidiSQL.
-
Connect and Visualize Live Vault CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Veeva Vault & Vault CRM into the Databricks platform and create visualization dashboards with real-time Veeva Vault & Vault CRM.
-
Build Visualizations of Jira Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Atlassian Jira in Birst.
-
Integrate Cline with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Kintone from within your IDE.
-
Getting Started with the CData Python Connector for RabbitMQ
Learn to install and license the CData Python Connector
-
Connect to Real-Time Suadeo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Suadeo and Dataflow to import and use Suadeo in Power Apps.
-
Provide OData Services of Chargebee Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Chargebee by developing a WCF Service Application.
-
Create Reports with ElevenLabs Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ElevenLabs.
-
Use the CData API Server to Access SAP SuccessFactors LMS Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP SuccessFactors LMS in the Power Pivot business intelligence tool.
-
Integrating GitHub Copilot CLI with Miro 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 PostgreSQL Interface for NetSuite Data using the CData JDBC Driver
Use the Remoting features of the NetSuite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live PabblySubscriptions Data in AWS Lambda
Connect to live PabblySubscriptions in AWS Lambda using the CData JDBC Driver.
-
Integrating Antigravity CLI with Customer.io via CData CLI
Connect Customer.io to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create SSAS Tabular Models from Pushbullet Data
How to build a SQL Server Analysis Service Tabular Model from Pushbullet using CData drivers.
-
Import Real-Time ServiceNow Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ServiceNow in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Kintone
Provide connectivity to Kintone through an SAP BusinessObjects universe.
-
Build Visualizations of Freshservice Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Freshservice in Birst.
-
View Reports on Real-Time SendInBlue Data in Power BI Report Server
Use the CData ODBC Driver for SendInBlue to visualize SendInBlue in Power BI Desktop and then publish them to Power BI Report Server.
-
Working with WooCommerce Data in LINQPad
Execute LINQ queries to WooCommerce in LINQPad.
-
How to load Azure DevOps data into Elasticsearch via Logstash
Introducing a simple method to load Azure DevOps data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Oracle Sales Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle Sales.
-
Choosing the Best Method to Connect Templated to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Templated from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Biml to Build SSIS Tasks to Replicate Sugar CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sugar CRM to SQL Server.
-
How to Build an ETL App for Customer.io Data in Python with CData
Create ETL applications and real-time data pipelines for Customer.io in Python with petl.
-
Manage Google Search Results in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Search.
-
Build Data Flows from Adobe Target to SQL Server using SSIS
Easily back up Adobe Target to SQL Server using the SSIS components for Adobe Target.
-
Visualize Cloudant Data in TIBCO Spotfire through OData
Integrate IBM Cloudant into dashboards in TIBCO Spotfire.
-
Connecting Pipedream with Oracle HCM 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 HCM Cloud data in real time.
-
Use the CData ODBC Driver for Hugging Face from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Hugging Face to connect to Hugging Face from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Hugging Face in Excel.
-
How to Connect to Live SAS xpt 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 SAS XPORT for you.
-
How to import Azure Table Data into Apache Solr
Use the CData Software JDBC Driver for Azure Table in Data Import Handler and create an automated import of Azure Table Storage to Apache Solr Enterprise Search platform.
-
Use the CData ODBC Driver for Bugsnag from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bugsnag to connect to Bugsnag from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bugsnag in Excel.
-
Build a Singer.io Tap for WooCommerce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live WooCommerce data using
-
Build Dashboards with Splunk Data in DBxtra
Create dynamic dashboards and perform analytics based on Splunk in DBxtra.
-
Use the CData Software ODBC Driver for Sage Intacct in MicroStrategy
Connect to Sage Intacct in MicroStrategy Developer using the CData Software ODBC Driver for Sage Intacct.
-
Getting Started with the CData ADO.NET Provider for Calendly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to work with Snapchat Ads Data in Apache Spark using SQL
Access and process Snapchat Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Connect SurveyMonkey to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SurveyMonkey using the CData Python MCP Server.
-
Automated Continuous LaunchDarkly Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Google Cloud SQL.
-
Visualize Wave Financial Data in Tableau
The CData ODBC driver for Wave Financial enables you integrate Wave Financial into Tableau dashboards.
-
Access Live Wrike Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Wrike into the statistical analysis tools available in SAS JMP. This article shows how to use Wrike in the Graph Builder and Query Builder.
-
Build FTP-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to FTP Data from Zoho Analytics and import live FTP Servers.
-
Migrating data from Microsoft Entra ID to Databricks using CData SSIS Components.
Easily push Microsoft Entra ID to Databricks using the CData SSIS Tasks for Microsoft Entra ID and Databricks.
-
Publish Crystal Reports on Oracle Eloqua Reporting Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Eloqua Reporting.
-
Use Microsoft Copilot Studio to talk to your Gmail 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 Gmail for you.
-
Access Live Asana Data in Coginiti Pro
Connect to and query live Asana from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software JDBC Driver for Snapchat Ads in MicroStrategy Web
Connect to Snapchat Ads in MicroStrategy Web using the CData Software JDBC Driver for Snapchat Ads.
-
Query Live Act 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 Act CRM directly from the development environment.
-
Connect to Access Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Access as a data source.
-
Create Jira Assets-Connected Dashboards in Grafana
Connect to Jira Assets Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Jira Assets.
-
Automated Continuous HDFS Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HDFS replication to Apache Kafka.
-
Automated Continuous Paylocity Replication to MongoDB
Use CData Sync for automated, continuous, customizable Paylocity replication to MongoDB.
-
How to Connect to Live QuickBooks Online 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 QuickBooks Online through natural language.
-
Create Data Visualizations in Cognos BI with SAP Fieldglass Data
Access SAP Fieldglass as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Validate Front Data with QuerySurge
Access and validate Front in QuerySurge using the CData JDBC Driver.
-
Integrate with MySQL Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MySQL in SnapLogic.
-
Automated Continuous Grafana Replication to Snowflake
Use CData Sync for automated, continuous, customizable Grafana replication to Snowflake.
-
Create Opsgenie Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Opsgenie data access from reports, embedded analytics, and more.
-
Add Google Contacts Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Contacts with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Reports with REST Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date REST.
-
Publish Crystal Reports on Instantly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Instantly.
-
Import Blackbaud FE NXT Data Using Azure Data Factory
Use CData Connect AI to connect to Blackbaud FE NXT Data from Azure Data Factory and import live Blackbaud FE NXT.
-
Easily Integrate PabblySubscriptions Data in Lazarus Pascal IDE
Learn how to easily integrate live PabblySubscriptions in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate SendGrid with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SendGrid with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SendGrid.
-
Import and Visualize SparkPost Data in Power View
Create data visualizations based on SparkPost in Excel.
-
Create SSAS Tabular Models from Azure Synapse Data
How to build a SQL Server Analysis Service Tabular Model from Azure Synapse using CData drivers.
-
Create Datasets from Figshare in Domo Workbench and Build Visualizations of Figshare Data in Domo
Use the CData Software ODBC Driver for Figshare to create datasets from Figshare in Domo Workbench and then build visualizations in the Domo service.
-
Access Live API Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live API from your Excel spreadsheets.
-
Connect to Sugar CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sugar CRM.
-
Stream Google Contacts Data into Apache Kafka Topics
Access and stream Google Contacts in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Raisers Edge NXT Data in Tableau
The CData ODBC driver for Raisers Edge NXT enables you integrate Raisers Edge NXT into Tableau dashboards.
-
Create Data Visualizations Based On Power BI XMLA Data in Mode
Use CData Connect AI to connect to Power BI XMLA Data from Mode and build visualizations using live
-
Automated Continuous Splunk Replication to Databricks
Use CData Sync for automated, continuous, customizable Splunk replication to Databricks.
-
Connecting GenSpark with WordPress Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to WordPress without any replication or custom integration required.
-
Integrating Antigravity CLI with Xero Accounting via CData CLI
Connect Xero Accounting to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a PostgreSQL Interface for Presto Data using the CData JDBC Driver
Use the Remoting features of the Presto JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Planio in MicroStrategy
Connect to Planio in MicroStrategy Developer using the CData Software JDBC Driver for Planio.
-
How to integrate FreeAgent with Apache Airflow
Access and process FreeAgent in Apache Airflow using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Authorize.Net Data
Access Authorize.Net as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Codex CLI with LinkedIn 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 Google Directory-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Directory and build web apps with connectivity to live Google Directory.
-
Guru Reporting in OBIEE with the Guru JDBC Driver
Deploy the Guru JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Enable the Deel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Deel.
-
Build a PostgreSQL Interface for SAP Data using the CData JDBC Driver
Use the Remoting features of the SAP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build a PostgreSQL Interface for LinkedIn Data using the CData JDBC Driver
Use the Remoting features of the LinkedIn JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with CouchDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Apache CouchDB within assisted coding and automated development workflows.
-
How to Connect to Live Zoho CRM Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zoho CRM without replication.
-
Integrate Live PabblySubscriptions Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PabblySubscriptions to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Configure the CData JDBC Driver for AlloyDB in a Connection Pool in Tomcat
Connect to Google AlloyDB from a connection pool in Tomcat.
-
Publish Jumpseller-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Jumpseller.