CData Software - Knowledge Base
Recent Articles
-
Integrating Cursor CLI with Google Tasks 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 Dashboards with SuiteCRM Data in DBxtra
Create dynamic dashboards and perform analytics based on SuiteCRM in DBxtra.
-
Operational Reporting on Missive Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Missive.
-
Automated Continuous MYOB AccountRight Replication to Oracle
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Oracle.
-
Connect to QuickBooks Online Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for QuickBooks Online Data and connect to QuickBooks Online in Akorbi Digital RunMyProcess.
-
A PostgreSQL Interface for Azure Synapse Data using the CData ODBC Driver
Use the SQL Gateway and Azure Synapse ODBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for Egnyte Data using the CData ODBC Driver
Use the SQL Gateway and Egnyte ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Codex CLI with Microsoft Access 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.
-
Operational Reporting on Perplexity Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Perplexity.
-
Integrating Antigravity CLI with AfterShip via CData CLI
Connect AfterShip to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData ODBC Driver for Box in Microsoft Power Query
You can use the CData Box ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Box into Microsoft Power Query.
-
Publish Oracle Financials Cloud-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Financials Cloud.
-
Connect to Mocean from Asprova with CData Software ODBC Driver for Mocean
This article shows how to connect faster to Mocean data from Asprova.
-
Moving Data from ClickTime to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ClickTime data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Object-Relational Mapping (ORM) with PostgreSQL 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 PostgreSQL into a Java-based ORM framework, Hibernate.
-
How to Work with Apify Data in ETL Validator JDBC
Connect to Apify from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Splunk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Splunk replication to OneLake in Microsoft Fabric.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SpaceX
Provide connectivity to SpaceX through an SAP BusinessObjects universe.
-
Automate Hive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Hive from PowerShell? This article demonstrates how to utilize the Hive Cmdlets for tasks like connecting to Apache Hive, automating operations, downloading data, and more.
-
How to Build an ETL App for PhantomBuster Data in Python with CData
Create ETL applications and real-time data pipelines for PhantomBuster in Python with petl.
-
How to Easily Query Snapchat Ads Data in OpenOffice Base
Connect to Snapchat Ads data in OpenOffice Base using the CData ODBC Driver for Snapchat Ads and generate reports with live data insights.
-
Getting Started with the CData Power BI Connector for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Microsoft OneDrive.
-
Bidirectional Access to Lakebase Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Lakebase in Filemaker Pro for Mac or Windows.
-
DataBind Controls to Opsgenie Data in Delphi
DataBind to Opsgenie in Delphi with standard data access components and controls.
-
Perform Batch Operations with Bitbucket Data in Apache NiFi
Connect to Bitbucket and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Excel Online Data in AWS Lambda
Connect to live Microsoft Excel Online in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Google Analytics Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Analytics. Leverage the pyodbc module for ODBC in Python.
-
DataBind SageHR Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide SageHR to a chart.
-
Connect to CouchDB Data from a Connection Pool in JBoss
Integrate Apache CouchDB into Java servlets: Use the Management Console in JBoss to install the CouchDB JDBC Driver.
-
Build Semantic Layer Views for CouchDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache CouchDB.
-
DataBind Controls to ChartMogul Data in Delphi
DataBind to ChartMogul in Delphi with standard data access components and controls.
-
Integrating Kiro CLI with Webflow 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.
-
Trigger Acumatica IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Acumatica with standard wizards in Logic Apps.
-
Use the CData Software ODBC Driver for Tally in MicroStrategy Desktop
Connect to Tally ERP in MicroStrategy Desktop using the CData Software ODBC Driver for Tally.
-
Access Live Phoenix Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Apache Phoenix through MCP integration.
-
Use ChatGPT to Talk to Your Dynamics 365 Business Central 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 Dynamics 365 Business Central for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage 200
Provide connectivity to Sage 200 through an SAP BusinessObjects universe.
-
Working with QuickBooks using LINQPad
The CData ADO.NET Providers can be used from many applications and development environments. This article shows how to use the CData ADO.NET Provider for QuickBooks to connect to QuickBooks in LINQPad. Although this example uses the QuickBooks Data Provider, the same process applies to any CData ADO.NET Providers.
-
Automate Zendesk Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zendesk from PowerShell? This article demonstrates how to utilize the Zendesk Cmdlets for tasks like connecting to Zendesk, automating operations, downloading data, and more.
-
SAP Reporting in OBIEE with the SAP JDBC Driver
Deploy the SAP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Codex CLI with ConvertAPI 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.
-
Integrate Real-Time Access to FHIR in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to FHIR in real time.
-
Integrate Billsby with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Billsby with External Services.
-
Getting Started with the CData SSIS Components for Drift
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Drift.
-
ETL Pipeliner CRM in Oracle Data Integrator
This article shows how to transfer Pipeliner CRM into a data warehouse using Oracle Data Integrator.
-
Query Live Okta 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 Okta directly from the development environment.
-
Publish Crystal Reports on Anaplan Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Anaplan.
-
Design BIRT Reports on Attio Data
Provide current Attio to your embedded analytics.
-
Connect Pinecone to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pinecone using the CData Python MCP Server.
-
Replicate Multiple LinkedIn Accounts
Replicate multiple LinkedIn accounts to one or many databases.
-
Visualize Quaderno Data in Sisense
Create an ElastiCube in Sisense app with access to Quaderno.
-
Build an OLAP Cube in SSAS from Webex Data
Establish a connection to Webex data from SQL Server Analysis Services, and use the Webex Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Freshteam from Asprova with CData Software ODBC Driver for Freshteam
This article shows how to connect faster to Freshteam data from Asprova.
-
Create Datasets from Outlook in Domo Workbench and Build Visualizations of Outlook Data in Domo
Use the CData Software ODBC Driver for Outlook to create datasets from Outlook in Domo Workbench and then build visualizations in the Domo service.
-
Excel Spreadsheet Automation on Salesforce Marketing Data with the QUERY Formula
Pull data from Salesforce Marketing, automate spreadsheets, and more with the QUERY formula.
-
Analyze Greenhouse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Greenhouse with the CData JDBC Driver for Greenhouse.
-
Configuring Clustering for CData Sync
A basic guide to configuring clustering in CData Sync, including setup of the shared application directory, application database, and cluster mode.
-
Integrate CapsuleCRM Data in Pentaho Data Integration
Build ETL pipelines based on CapsuleCRM in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with Amazon Marketplace Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon Marketplace.
-
Access Live SAS xpt Data in AWS Lambda
Connect to live SAS XPORT in AWS Lambda using the CData JDBC Driver.
-
Use the CData ODBC Driver for DB2 in Microsoft Power Query
You can use the CData DB2 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM DB2 into Microsoft Power Query.
-
Validate LionDesk Data with QuerySurge
Access and validate LionDesk in QuerySurge using the CData JDBC Driver.
-
Feed Figshare Data into FineReport
How to set Figshare as a JDBC data source in FineReport.
-
How to Connect to Live Sage Cloud Accounting 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 Sage Business Cloud Accounting for you.
-
Analyze MongoDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MongoDB from Power Pivot. You will use the Table Import Wizard to load MongoDB. You can visually build the import query or use any SQL supported by the driver.
-
Build Data Flows from SQL Server to Dynamics 365 through SSIS
Easily push SQL Server data to Dynamics 365 using the CData SSIS Tasks for Dynamics 365.
-
Import Real-Time TaxJar Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use TaxJar in ColdFusion.
-
Integrating GitHub Copilot CLI with ZohoExpense 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 Kafka Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Kafka data access from reports, embedded analytics, and more.
-
DataBind Controls to Sage 200 Data in Delphi
DataBind to Sage 200 in Delphi with standard data access components and controls.
-
How to Query eBay Analytics Data in MySQL Workbench
Execute MySQL queries against live eBay Analytics from MySQL Workbench.
-
Query Short.io Data in ColdFusion
Write standard ColdFusion data access code to connect to Short.io.
-
Integrate with Helpscout Data in JReport Designer
Create charts and reports based on Helpscout in JReport Designer.
-
Integrating Hubstaff Data in Talend Cloud Data Management Platform
Connect Hubstaff Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Work with Mixpanel Data in FoxPro
Load Mixpanel into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to and Visualize Live ElevenLabs Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ElevenLabs.
-
Natively Connect to SFTP Data in PHP
The CData ODBC driver for SFTP enables you to create PHP applications with connectivity to SFTP. Leverage the native support for ODBC in PHP.
-
Connect to Supabase Data in CloverDX (formerly CloverETL)
Transfer Supabase using the visual workflow in the CloverDX data integration tool.
-
How to connect to SAS xpt Data in DBVisualizer
Integrate SAS XPORT with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Clio Data from Spring Boot
Connect to Clio in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Tally Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Tally replication to Azure SQL Database.
-
Create Informatica Mappings From/To a JDBC Data Source for Facebook Ads
Create Facebook Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Load Tanda Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Tanda to a database.
-
Visualize Live Avro Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache Avro using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Prepare, Blend, and Analyze Cvent Data in Alteryx Designer (ODBC)
Build workflows to access live Cvent for self-service data analytics.
-
Visualize Live Calendly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Calendly using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Antigravity CLI with Oracle SCM via CData CLI
Connect Oracle SCM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData JDBC Driver for Gong
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Gong.
-
Connect to Basecamp Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect to Google Spanner Data from Spring Boot
Connect to Google Spanner in a Spring Boot Application using the CData JDBC Driver for Google Spanner
-
How to Build an ETL App for Google Spanner Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Spanner in Python with petl and the CData Connect AI Python SDK.
-
Build a Singer.io Tap for CampaignMonitor With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CampaignMonitor data using
-
Stream HubSpot Data into Apache Kafka Topics
Access and stream HubSpot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect the Power BI Service to MessageBird: Complete Guide
Connect to the CData Software Power BI Connector for MessageBird from PowerBI.com to provide real-time MessageBird across the organization.
-
Use Azure AI Foundry to Talk to Your SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SingleStore for you.
-
Access Live Jira Data in AWS Lambda
Connect to live Atlassian Jira in AWS Lambda using the CData JDBC Driver.
-
Integrate PagerDuty Data in the Pentaho Report Designer
Publish reports based on PagerDuty in the Pentaho BI tool.
-
ETL Monday.com in Oracle Data Integrator
This article shows how to transfer Monday.com into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Oracle Eloqua Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to PostgreSQL.
-
Integrating Antigravity CLI with Clockify via CData CLI
Connect Clockify to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.