CData Software - Knowledge Base
Recent Articles
-
Integrating PostgreSQL Data in Talend Cloud Data Management Platform
Connect PostgreSQL Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PostgreSQL.
-
Use Grok to Talk to Your Databricks 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 Databricks for you.
-
Back Up OnePageCrm 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 OnePageCrm data.
-
Migrating data from Onfleet to Databricks using CData SSIS Components.
Easily push Onfleet to Databricks using the CData SSIS Tasks for Onfleet and Databricks.
-
Connect to and Query GitHub Data in QlikView over ODBC
Create data visualizations with GitHub in QlikView.
-
Integrating Codex CLI with Outlook 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 an SAP BusinessObjects Universe on the CData ODBC Driver for AgileCRM
Provide connectivity to AgileCRM through an SAP BusinessObjects universe.
-
Connect to Everhour in SpagoBI
Create reports featuring live Everhour in SpagoBI Studio. Host Everhour reports on SpagoBI Server.
-
Connect to SAP BusinessObjects BI Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP BusinessObjects BI from Filemaker Pro on Mac.
-
Create MessageBird Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MessageBird data access from reports, embedded analytics, and more.
-
Build Apps with Live Amazon Athena Data Using the Low-Code Development Platform of Mendix
Connect Amazon Athena with Mendix to build apps using the CData JDBC Driver for Amazon Athena.
-
Configure the CData JDBC Driver for Workday in a Connection Pool in Tomcat
Connect to Workday from a connection pool in Tomcat.
-
How to Query Live OData Services in Claude Desktop
Connect to and query live OData Services in Claude Desktop using CData MCP Server.
-
Import Real-Time Parallel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Parallel in ColdFusion.
-
Analyze Cassandra Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cassandra from Power Pivot. You will use the Table Import Wizard to load Apache Cassandra. You can visually build the import query or use any SQL supported by the driver.
-
Configure the CData JDBC Driver for Authorize.Net in a Connection Pool in Tomcat
Connect to Authorize.Net from a connection pool in Tomcat.
-
Build Semantic Layer Views for Tally Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Tally ERP.
-
Build a PostgreSQL Interface for SQL Analysis Services Data using the CData JDBC Driver
Use the Remoting features of the SQL Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze GitLab Data in Alteryx Designer (ODBC)
Build workflows to access live GitLab for self-service data analytics.
-
Choosing the Best Method to Connect HBase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache HBase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with Dotmailer Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dotmailer.
-
Connect to FTP Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FTP and the SQL Gateway to access FTP Servers from Google Apps Script.
-
Viewing SAP Ariba Source Data in RAD Studio Data Explorer
How to view SAP Ariba Source in RAD Studio Data Explorer using the CData ODBC Driver for SAP Ariba Source.
-
Feed Monday.com Data into FineReport
How to set Monday.com as a JDBC data source in FineReport.
-
Connect to Azure Analysis Services Data in RapidMiner
Integrate Azure Analysis Services with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Dash to Build to Web Apps on LionDesk Data
Create Python applications that use pandas and Dash to build LionDesk-connected web apps.
-
How to connect to Campaigner Data in DBVisualizer
Integrate Campaigner with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for BenchmarkEmail in MicroStrategy Desktop
Connect to BenchmarkEmail in MicroStrategy Desktop using the CData Software ODBC Driver for BenchmarkEmail.
-
Integrate Microsoft OneDrive Data in the Pentaho Report Designer
Publish reports based on Microsoft OneDrive in the Pentaho BI tool.
-
Automated Continuous Jodoo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jodoo replication to AlloyDB.
-
Object-Relational Mapping (ORM) with Clockify 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 Clockify into a Java-based ORM framework, Hibernate.
-
Integrating Cursor CLI with Paymo 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 Visualizations of Pinterest Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pinterest in Birst.
-
Build ZohoInvoice-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoInvoice and build web apps with connectivity to live ZohoInvoice.
-
How to connect to Pingdom Data in DBVisualizer
Integrate Pingdom with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Crystal Reports on Hive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Hive.
-
Connect to Real-Time Redis Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Redis and Dataflow to import and use Redis in Power Apps.
-
Build Dashboards with Microsoft Exchange Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Exchange in DBxtra.
-
Analyze Trello Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Trello and visualize Trello in SAP Analytics Cloud.
-
Connect to Act-On Data in NetBeans
Connect to Act-On in NetBeans with the data source configuration wizard.
-
Use Biml to Build SSIS Tasks to Replicate Rootly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Rootly to SQL Server.
-
Build Dashboards with NetSuite Data in Dundas BI
Create dynamic dashboards and perform analytics based on NetSuite CRM & ERP in Dundas BI.
-
Create Power BI Reports on Real-Time ElevenLabs Data
Use the CData ODBC Driver for ElevenLabs to visualize ElevenLabs in Power BI Desktop.
-
Connect to Spotify Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Publish Shippo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Shippo.
-
Build Semantic Layer Views for Basecamp Data in APOS Live Data Gateway
Use the CData Connector for Basecamp in APOS Live Data Gateway to build Semantic Layer Views for Basecamp.
-
Connect to SAP Hybris C4C Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Hybris C4C from Crystal Reports.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google BigQuery to Power BI dashboards. Simply drag and drop Google BigQuery into data visuals on the Power BI canvas.
-
Operational Reporting on Rootly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Rootly.
-
How to Connect to Live SAS Data Sets Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAS Data Sets for you.
-
Use the CData Software ODBC Driver for Paddle in MicroStrategy Web
Connect to Paddle in MicroStrategy Web using the CData Software ODBC Driver for Paddle.
-
Integrate with EmailOctopus Data in JReport Designer
Create charts and reports based on EmailOctopus in JReport Designer.
-
How to Connect the Power BI Service to iContact: Complete Guide
Connect to the CData Software Power BI Connector for iContact from PowerBI.com to provide real-time iContact across the organization.
-
How to Connect to & Open Gorgias Data in Microsoft Excel
This article uses the CData ODBC driver for Gorgias to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Concur using the Model Context Protocol.
-
Access EmailOctopus Data from MySQL in Amazon QuickSight
Connect to EmailOctopus and build visualizations of EmailOctopus using a MySQL Connection in Amazon QuickSight.
-
Use Biml to Build SSIS Tasks to Replicate ElevenLabs Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ElevenLabs to SQL Server.
-
Connecting Supabase to CData Connect AI
Learn how to connect a Supabase PostgreSQL database to CData Connect AI so your AI tools and agents can query live data using natural language.
-
Connect to Trello 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 Trello.
-
Analyze Gong Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gong in Microsoft R Open.
-
Integrate Jira with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jira with External Services.
-
Automated Continuous API Replication to IBM DB2
Use CData Sync for automated, continuous, customizable API replication to IBM DB2.
-
Build Oracle Eloqua-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle Eloqua Data and create custom apps in Mendix.
-
Automated Continuous Klaviyo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Klaviyo replication to Google Cloud SQL.
-
How to Connect to Live SAP SuccessFactors LMS Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP SuccessFactors LMS for you.
-
How to Build an ETL App for Twilio Data in Python with CData
Create ETL applications and real-time data pipelines for Twilio in Python with petl.
-
Trigger Zendesk IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zendesk with standard wizards in Logic Apps.
-
Automated Continuous Salesforce CRM Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Google BigQuery.
-
Manage Todoist Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Todoist.
-
Connect CampaignMonitor to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CampaignMonitor with IBM WebSphere for seamless data integration and connectivity.
-
Back Up AgileCRM 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 AgileCRM data.
-
Connect to Bright Data Data in Aqua Data Studio
Access Bright Data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to SAP BusinessObjects BI Data from AWS Glue
Use CData Connect AI to gain access to live SAP BusinessObjects BI from your AWS Glue jobs.
-
How to connect PolyBase to NetSuite
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live NetSuite CRM & ERP.
-
Provide OData Services of Odoo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Odoo ERP by developing a WCF Service Application.
-
Automated Continuous Sendwithus Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sendwithus replication to Amazon S3.
-
Build Instagram-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Instagram to explore live Instagram Data in Cursor to assist with building Instagram-powered applications.
-
Integrate Live Intercom Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Intercom to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Replicate HubSpot Data to Multiple Databases
Replicate HubSpot to disparate databases with a point-and-click configuration.
-
Create SSAS Tabular Models from Sage Intacct Data
How to build a SQL Server Analysis Service Tabular Model from Sage Intacct using CData drivers.
-
Connect to and Visualize Live Quickbase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Quickbase.
-
Automated Continuous Stripe Replication to Snowflake
Use CData Sync for automated, continuous, customizable Stripe replication to Snowflake.
-
Access Live SAP Fieldglass Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Fieldglass through MCP integration.
-
Connect to SAP Concur Data in DBeaver
Use the CData ODBC Driver to connect to SAP Concur in DBeaver.
-
Automated Continuous Kintone Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Kintone replication to Apache Kafka.
-
Establish a Live Connection with Cloudant Data using Tableau Bridge
The CData ODBC Driver for Cloudant enables you to integrate live IBM Cloudant into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Act-On Data in the Pentaho Report Designer
Publish reports based on Act-On in the Pentaho BI tool.
-
Natively Connect to EnterpriseDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to EnterpriseDB. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Missive
Provide connectivity to Missive through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for Templated
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Templated.
-
How to Connect to Live Oracle HCM Cloud 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 Oracle HCM Cloud for you.
-
Connecting GenSpark with Smartsheet Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Smartsheet without any replication or custom integration required.
-
How to Create Power BI Visual Reports with Real-Time JSON Services
Use CData Power BI Connectors to visualize JSON in Power BI.
-
Use the CData Software ODBC Driver for Excel in MicroStrategy
Connect to Microsoft Excel in MicroStrategy Developer using the CData Software ODBC Driver for Excel.
-
Build Presto-Connected Apps in Choreo
Use CData Connect AI to connect to Presto Data from Choreo and build custom apps using live Presto.
-
Analyze Google Cloud Storage Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Cloud Storage and visualize live Google Cloud Storage in Infragistics Reveal.
-
Connect to SAP SuccessFactors Data in NetBeans
Connect to SAP SuccessFactors in NetBeans with the data source configuration wizard.
-
Access Google Translate Data from MySQL in PHP
Connect to Google Translate through the standard MySQL libraries in PHP.
-
Connect to CampaignMonitor Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CampaignMonitor as an External Source in Dremio.
-
Access Live Kintone Data in TIBCO Data Virtualization
Use the Kintone Tibco DV Adapter to create a Kintone data source in TIBCO Data Virtualization Studio and gain access to live Kintone from your TDV Server.