CData Software - Knowledge Base
Recent Articles
-
How to Work with Tally Data in AWS Glue Jobs Using JDBC
Connect to Tally from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to SpaceX Data in HULFT Integrate
Connect to SpaceX as a JDBC data source in HULFT Integrate
-
Create MYOB AccountRight-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MYOB AccountRight Data from Klipfolio and build custom visualizations using live MYOB AccountRight.
-
Integrating OpenCode Terminal with Discourse 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.
-
Connect to Real-Time Moosend Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Moosend in Power Apps.
-
Getting Started with the CData ODBC Driver for TigerGraph
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for TigerGraph.
-
Object-Relational Mapping (ORM) with EmailOctopus 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 EmailOctopus into a Java-based ORM framework, Hibernate.
-
Connect to Tally Data in HULFT Integrate
Connect to Tally as a JDBC data source in HULFT Integrate
-
DataBind Charts to Omnisend Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Omnisend from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Import Real-Time eBay Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use eBay in ColdFusion.
-
Create Azure Analysis Services Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Azure Analysis Services data access from reports, embedded analytics, and more.
-
Automated Continuous Reckon Accounts Hosted Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Apache Cassandra.
-
Connect to BigCommerce Data from a Connection Pool in Jetty
The BigCommerce JDBC Driver supports connection pooling: This article shows how to connect faster to BigCommerce from Web apps in Jetty.
-
Design BIRT Reports on ZeroBounce Data
Provide current ZeroBounce to your embedded analytics.
-
Replicate Multiple Clockify Accounts
Replicate multiple Clockify accounts to one or many databases.
-
Prepare, Blend, and Analyze HubSpot Data in Alteryx Designer (ODBC)
Build workflows to access live HubSpot for self-service data analytics.
-
Natively Connect to Amazon S3 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon S3. Leverage the native support for ODBC in PHP.
-
How to Easily Query Placid Data in OpenOffice Base
Connect to Placid data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Front Data in Pentaho Data Integration
Build ETL pipelines based on Front in the Pentaho Data Integration tool.
-
How to Connect the Power BI Service to MailChimp: Complete Guide
Connect to the CData Software Power BI Connector for MailChimp from PowerBI.com to provide real-time MailChimp across the organization.
-
Analyze HCL Domino Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of HCL Domino and visualize live HCL Domino in Infragistics Reveal.
-
Use the CData ODBC Driver for SageHR from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SageHR to connect to SageHR from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SageHR in Excel.
-
How to Easily Query Google Cloud Storage Data in OpenOffice Base
Connect to Google Cloud Storage data in OpenOffice Base using the CData ODBC Driver for Google Cloud Storage and generate reports with live data insights.
-
Deploy the ADO.NET Provider for ClickUp on an SSRS Report Server
Connect to ClickUp 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.
-
Prepare, Blend, and Analyze GraphQL Data in Alteryx Designer (ODBC)
Build workflows to access live GraphQL for self-service data analytics.
-
How to Visualize Raisers Edge NXT Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Raisers Edge NXT in Python.
-
Query Lakebase Data as a SQL Server Database in Node.js
Execute SQL Server queries against Lakebase from Node.js.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Okta within intelligent workflows.
-
Building Dynamic Web Pages with Greenplum Data Using AngularJS
Create single-page applications with live connectivity to Greenplum using the CData API Server.
-
Create Excel Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Excel data access from reports, embedded analytics, and more.
-
Integrating GitHub Copilot CLI with Dropbox 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 Copper Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Copper replication to Azure SQL Database.
-
Automated Continuous Cassandra Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Cassandra replication to OneLake in Microsoft Fabric.
-
Create Workday-Connected Dashboards in Grafana
Connect to Workday Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Workday.
-
Access Vimeo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Vimeo from HeidiSQL.
-
Getting Started with the CData ADO.NET Provider for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for YouTube Analytics.
-
Connect to EmailOctopus Data in DBeaver
Use the CData ODBC Driver to connect to EmailOctopus in DBeaver.
-
Integrate Harvest with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Harvest with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Harvest.
-
Automated Continuous Parquet Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Parquet replication to PostgreSQL.
-
Build Charts with ZeroBounce Data in Clear Analytics
Create dynamic charts and perform analytics based on ZeroBounce in Clear Analytics.
-
Import and Visualize SAP Ariba Source Data in Power View
Create data visualizations based on SAP Ariba Source in Excel.
-
Choosing the Best Method to Connect RSS to SQL Server: 5 Options Explained
Discover multiple ways to connect and use RSS Feeds from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use JayDeBeApi to access Jodoo Data in Python
Use standard Python scripting and the development environment of your choice to access live Jodoo.
-
Working with MailChimp Data in LINQPad
Execute LINQ queries to MailChimp in LINQPad.
-
Choosing the Best Method to Connect Google Ad Manager to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Ad Manager from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Live Eventbrite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Eventbrite using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Load Adobe Commerce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Commerce to a database.
-
Visualize Zoho Inventory Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Inventory.
-
Excel Spreadsheet Automation on Zoho Books Data with the QUERY Formula
Pull data from Zoho Books, automate spreadsheets, and more with the QUERY formula.
-
Connect to Slack Data in JRuby
Create a simple JRuby app with access to live Slack.
-
Automated Continuous Google Campaign Manager 360 Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to SQLite.
-
Integrating Dataiku with Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Excel Online.
-
Import NetSuite Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to NetSuite Data and provide access to live NetSuite CRM & ERP for custom reports in the Power BI Service.
-
Use Grok to Talk to Your PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your PostgreSQL for you.
-
Connect to Zoho CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho CRM in the Denodo Virtual DataPort Administrator.
-
Connect to LionDesk Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LionDesk to connect to LionDesk and execute queries in PowerBuilder.
-
Build Reckon Accounts Hosted-Connected Apps in Choreo
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Choreo and build custom apps using live Reckon Accounts Hosted.
-
Publish Reports with FreeAgent Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FreeAgent.
-
Replicate Dotmailer Data to Multiple Databases
Replicate Dotmailer to disparate databases with a point-and-click configuration.
-
How to Query Live Rootly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Rootly data in natural language using Python.
-
Analyze Microsoft Dataverse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Dataverse (CDS) with the CData JDBC Driver for Microsoft Dataverse.
-
Automated Continuous Workday Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Workday replication to OneLake in Microsoft Fabric.
-
Build Voice Agents in ElevenLabs with access to Live CSV Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live CSV/TSV Files.
-
Model QuickBooks Time Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and QuickBooks Time, enabling the direct import of real-time QuickBooks Time.
-
Query Keap Data in ColdFusion
Write standard ColdFusion data access code to connect to Keap.
-
Integrating Dataiku with Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Oracle Database.
-
Analyze AlloyDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google AlloyDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect and Visualize Live Oracle Financials Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Financials Cloud into the Databricks platform and create visualization dashboards with real-time Oracle Financials Cloud.
-
Integrating Codex CLI with Flowlu 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.
-
Connecting Mastra with Slack Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Slack, no replication required.
-
How to Connect the Power BI Service to AdRoll: Complete Guide
Connect to the CData Software Power BI Connector for AdRoll from PowerBI.com to provide real-time AdRoll across the organization.
-
Automate IBM Informix Data Replication to Azure Synapse
Use CData Sync to customize and automate IBM Informix replication to Azure Synapse.
-
Create Informatica Mappings From/To a JDBC Data Source for Dynamics 365
Create Dynamics 365 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Open WebUI with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Cvent from within the chat interface.
-
Automate PabblySubscriptions Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PabblySubscriptions from PowerShell? This article demonstrates how to utilize the PabblySubscriptions Cmdlets for tasks like connecting to PabblySubscriptions, automating operations, downloading data, and more.
-
How to Access Live Perigon Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Perigon enables you to integrate Perigon into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to TigerGraph Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to TigerGraph. Leverage the native support for ODBC in PHP.
-
Visualize Sugar CRM Data in TIBCO Spotfire through OData
Integrate Sugar CRM into dashboards in TIBCO Spotfire.
-
Integrate SAP SuccessFactors with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP SuccessFactors with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP SuccessFactors.
-
Automated Continuous FHIR Replication to IBM DB2
Use CData Sync for automated, continuous, customizable FHIR replication to IBM DB2.
-
Connect to Qualaroo Data in Aqua Data Studio
Access Qualaroo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bidirectional Access to Redis Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Redis in Filemaker Pro for Mac or Windows.
-
Use JayDeBeApi to access Tickspot Data in Python
Use standard Python scripting and the development environment of your choice to access live Tickspot.
-
Manage PDFMonkey Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PDFMonkey.
-
Migrating data from Oracle Sales to Google BigQuery using CData SSIS Components.
Easily push Oracle Sales to Google BigQuery using the CData SSIS Tasks for Oracle Sales and Google BigQuery.
-
How to connect to Zoho Projects Data from IntelliJ
Integrate connectivity to Zoho Projects with wizards in IntelliJ.
-
ETL SQL Server in Oracle Data Integrator
This article shows how to transfer Microsoft SQL Server into a data warehouse using Oracle Data Integrator.
-
Use the CData Software ODBC Driver for Oracle HCM Cloud in MicroStrategy Desktop
Connect to Oracle HCM Cloud in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Automated Continuous HubDB Replication to Vertica
Use CData Sync for automated, continuous, customizable HubDB replication to Vertica.
-
Use the CData Software JDBC Driver for Strava in MicroStrategy Web
Connect to Strava in MicroStrategy Web using the CData Software JDBC Driver for Strava.
-
How to Seamlessly Import SparkPost Data into IBM SPSS Modeler
Integrate SparkPost data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Pipedrive Data from HeidiSQL
Use CData Connect AI to connect to and query live Pipedrive from HeidiSQL.
-
Access Live SingleStore Data in Coginiti Pro
Connect to and query live SingleStore from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Back Up Azure Cosmos DB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cosmos DB. In this article, we will employ an SSIS workflow to populate a database with Azure Cosmos DB data.
-
Connect to Adobe Commerce in SpagoBI
Create reports featuring live Adobe Commerce in SpagoBI Studio. Host Adobe Commerce reports on SpagoBI Server.
-
Getting Started with the CData JDBC Driver for Miro
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Miro.
-
Connect to YouTube Analytics Data in Jaspersoft Studio
Execute SQL to remote YouTube Analytics in Jaspersoft Studio.
-
Automated Continuous Invoiced Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Invoiced replication to IBM DB2.
-
How to Connect Amazon S3 Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Amazon S3 data in real time using natural language.
-
View Reports on Real-Time Supabase Data in Power BI Report Server
Use the CData ODBC Driver for Supabase to visualize Supabase in Power BI Desktop and then publish them to Power BI Report Server.