CData Software - Knowledge Base
Recent Articles
-
How to import Excel Data into Apache Solr
Use the CData Software JDBC Driver for Excel in Data Import Handler and create an automated import of Microsoft Excel to Apache Solr Enterprise Search platform.
-
Integrating GitHub Copilot CLI with Helpscout 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.
-
Trigger Couchbase IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Couchbase with standard wizards in Logic Apps.
-
Build Dashboards with Salesforce Data in Dundas BI
Create dynamic dashboards and perform analytics based on Salesforce & Force.com in Dundas BI.
-
Migrating data from Vercel to Databricks using CData SSIS Components.
Easily push Vercel to Databricks using the CData SSIS Tasks for Vercel and Databricks.
-
Connect to Beeminder Data in NetBeans
Connect to Beeminder in NetBeans with the data source configuration wizard.
-
Connect to and Query Marketo Data in QlikView over ODBC
Create data visualizations with Marketo in QlikView.
-
Query Dynamics 365 Data in DataGrip
Create a Data Source for Dynamics 365 in DataGrip and use SQL to query live Microsoft Dynamics 365.
-
Automated Continuous Hubstaff Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Hubstaff replication to Apache Kafka.
-
Back Up Nethunt 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 Nethunt data.
-
Automate LinkedIn Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LinkedIn from PowerShell? This article demonstrates how to utilize the LinkedIn Cmdlets for tasks like connecting to LinkedIn, automating operations, downloading data, and more.
-
Automated Continuous Oracle Sales Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Apache Cassandra.
-
Integrating Claude Code CLI with Rebilly 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 integrate Metabase with IBM Cloud Object Storage Data
Use CData Connect AI to connect to live IBM Cloud Object Storage and create an interactive dashboard in Metabase from IBM Cloud Object Storage.
-
Create Reports with Anaplan Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Anaplan.
-
How to Build an ETL App for Google Sheets Data in Python with CData
Create ETL applications and real-time data pipelines for Google Sheets in Python with petl.
-
How to Connect the Power BI Service to Intercom: Complete Guide
Connect to the CData Software Power BI Connector for Intercom from PowerBI.com to provide real-time Intercom across the organization.
-
Use Dash to Build to Web Apps on Samanage Data
Create Python applications that use pandas and Dash to build Samanage-connected web apps.
-
Integrating Mailgun Data in Talend Cloud Data Management Platform
Connect Mailgun Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to ZohoSubscriptions Data in DBArtisan
Use wizards in DBArtisan to configure ZohoSubscriptions as a data source.
-
Integrating OpenCode Terminal with SAP Netweaver Gateway 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.
-
Automated Continuous SendInBlue Replication to Vertica
Use CData Sync for automated, continuous, customizable SendInBlue replication to Vertica.
-
How to Query Live SFTP Data in Claude Desktop
Connect to and query live SFTP Data in Claude Desktop using CData MCP Server.
-
How to Connect to Live FHIR 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 FHIR for you.
-
Automated Continuous iContact Replication to Vertica
Use CData Sync for automated, continuous, customizable iContact replication to Vertica.
-
Replicate Amplitude Data from PowerShell
Write a quick PowerShell script to query Amplitude. Use connectivity to the live data to replicate Amplitude to SQL Server.
-
How to connect to SAP Netweaver Gateway Data in DBVisualizer
Integrate SAP Netweaver Gateway with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData API Server to Access Oracle Service Cloud Data in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle Service Cloud in the Power Pivot business intelligence tool.
-
Build an OLAP Cube in SSAS from QuickBooks Data
Establish a connection to QuickBooks Desktop data from SQL Server Analysis Services, and use the QuickBooks Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Act-On Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Act-On from Power Pivot. You will use the Table Import Wizard to load Act-On. You can visually build the import query or use any SQL supported by the driver.
-
Explore Geographical Relationships in Splunk Data with Power Map
Create data visualizations with Splunk in Power Map.
-
Visualize Live ShipStation Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ShipStation into custom reports in Power BI.
-
Integrate with Google Campaign Manager 360 Data in JReport Designer
Create charts and reports based on Google Campaign Manager 360 in JReport Designer.
-
Use ChatGPT to Talk to Your Active Directory 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 Active Directory for you.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Sheets to Power BI dashboards. Simply drag and drop Google Sheets into data visuals on the Power BI canvas.
-
Automated Continuous Impala Replication to Databricks
Use CData Sync for automated, continuous, customizable Impala replication to Databricks.
-
Working with CSV Data in LINQPad
Execute LINQ queries to CSV/TSV Files in LINQPad.
-
Easily Integrate EmailOctopus Data in Lazarus Pascal IDE
Learn how to easily integrate live EmailOctopus in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Gorgias 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 Gorgias into TIBCO Spotfire.
-
Use Claude to Talk to Your Bullhorn CRM 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 Bullhorn CRM for you.
-
Integrating Codex CLI with Hacker News 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.
-
Access Live Zoho Projects Data in TIBCO Data Virtualization
Use the Zoho Projects Tibco DV Adapter to create a Zoho Projects data source in TIBCO Data Virtualization Studio and gain access to live Zoho Projects from your TDV Server.
-
Connect to OneNote Data in ACL Analytics
Connect to Microsoft OneNote via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft OneNote.
-
Build Automated Workflows with Live HCL Domino Data in Workato
Use CData Connect AI to connect to live HCL Domino and build automated workflows in Workato.
-
Build Charts with SFTP Data in Clear Analytics
Create dynamic charts and perform analytics based on SFTP in Clear Analytics.
-
Access Delighted 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 Delighted.
-
View Reports on Real-Time ConvertKit Data in Power BI Report Server
Use the CData ODBC Driver for ConvertKit to visualize ConvertKit in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Codex CLI with Gmail 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.
-
Use the CData Software ODBC Driver for Twilio in SAS for Real-Time Reporting and Analytics
Connect to real-time Twilio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Twilio.
-
Connect to TigerGraph from Asprova with CData Software ODBC Driver for TigerGraph
This article shows how to connect faster to TigerGraph data from Asprova.
-
Query Microsoft Planner Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Planner from Node.js.
-
Connect to and Visualize Live ClickUp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ClickUp.
-
Connect to CockroachDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access CockroachDB from Appeon PowerBuilder using the CData ADO.NET Provider for CockroachDB.
-
Integrate Unbounce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Unbounce with External Services.
-
Use Dash to Build to Web Apps on Act-On Data
Create Python applications that use pandas and Dash to build Act-On-connected web apps.
-
Publish Crystal Reports on SAP HANA Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP HANA.
-
Integrate Live WordPress Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrating LangGraph with Google Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Ads within automated workflows.
-
How to import AlloyDB Data into Apache Solr
Use the CData Software JDBC Driver for AlloyDB in Data Import Handler and create an automated import of Google AlloyDB to Apache Solr Enterprise Search platform.
-
Connect to SAP Netweaver Gateway Data in RazorSQL
Connect to SAP Netweaver Gateway from wizards and query SAP Netweaver Gateway from the GUI in the RazorSQL database management tool.
-
Import HCL Domino Data Using Azure Data Factory
Use CData Connect AI to connect to HCL Domino Data from Azure Data Factory and import live HCL Domino.
-
View Reports on Real-Time Hubstaff Data in Power BI Report Server
Use the CData ODBC Driver for Hubstaff to visualize Hubstaff in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating OpenCode Terminal with Vercel 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 Access Amazon S3 Data Using Entity Framework
This article shows how to access Amazon S3 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate CircleCI with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CircleCI with External Services.
-
Object-Relational Mapping (ORM) with Intercom Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Intercom into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData JDBC Driver for Parquet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Parquet.
-
Build Oracle Sales-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle Sales Data and create custom apps in Bubble.
-
How to Query Live SAP Business One Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Business One data in natural language using Python.
-
DataBind Controls to Missive Data in Delphi
DataBind to Missive in Delphi with standard data access components and controls.
-
How to Visualize Tavily Data in Python with pandas
Use pandas and other modules to analyze and visualize live Tavily in Python.
-
How to load Google Analytics data into Elasticsearch via Logstash
Introducing a simple method to load Google Analytics data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Excel Online Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Excel Online in the Pentaho Data Integration tool.
-
Integrate Mocean with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mocean with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mocean.
-
How to publish and share Telegram Data dashboards with Tableau Server
The CData ODBC driver for Telegram enables you integrate Telegram into Tableau dashboards.
-
How to use SQLAlchemy ORM to access SAP Concur Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Concur.
-
Import SAP Netweaver Gateway Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Netweaver Gateway Data and provide access to live SAP Netweaver Gateway for custom reports in the Power BI Service.
-
Connect to Microsoft Planner Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Planner from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Planner.
-
Automated Continuous Amazon Marketplace Replication to SingleStore
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to SingleStore.
-
Connect ChartMogul to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ChartMogul using the CData Python MCP Server.
-
How to load JSON data into Elasticsearch via Logstash
Introducing a simple method to load JSON data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Kiro CLI with Onfleet 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.
-
Automated Continuous Google Search Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Search replication to Vertica.
-
Access Live ConstantContact Data in AWS Lambda
Connect to live ConstantContact in AWS Lambda using the CData JDBC Driver.
-
Validate Stack Exchange Data with QuerySurge
Access and validate Stack Exchange in QuerySurge using the CData JDBC Driver.
-
Build Data Flows from Customer.io to SQL Server using SSIS
Easily back up Customer.io to SQL Server using the SSIS components for Customer.io.
-
Create Toggl Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Toggl from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Auth0 Data in Aqua Data Studio
Access Auth0 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Highrise Data in HULFT Integrate
Connect to Highrise as a JDBC data source in HULFT Integrate
-
Automated Continuous SAP Hybris C4C Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Databricks.
-
Connect to Avaza Data from PowerBuilder via JDBC
This article demonstrates how to access Avaza from PowerBuilder using the Avaza JDBC Driver.
-
Build Visualizations of CapsuleCRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CapsuleCRM in Birst.
-
Perform Batch Operations with Oracle Data in Apache NiFi
Connect to Oracle Database and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect ZohoMarketingHub to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoMarketingHub with IBM WebSphere for seamless data integration and connectivity.
-
Create Power BI Reports on Real-Time Google Contacts Data
Use the CData ODBC Driver for Google Contacts to visualize Google Contacts in Power BI Desktop.
-
Design BIRT Reports on Mailgun Data
Provide current Mailgun to your embedded analytics.
-
Create Missive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Missive from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect PolyBase to CapsuleCRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CapsuleCRM.
-
Getting Started with the CData ODBC Driver for Hive
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Hive.
-
Build a Singer.io Tap for Trello With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Trello data using