CData Software - Knowledge Base
Recent Articles
-
How to Visualize Lakebase 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 Lakebase in Python.
-
How to Build an ETL App for OpenWeatherMap Data in Python with CData
Create ETL applications and real-time data pipelines for OpenWeatherMap in Python with petl.
-
Create Oracle Eloqua Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Eloqua data access from reports, embedded analytics, and more.
-
Import SingleStore Data Using Azure Data Factory
Use CData Connect AI to connect to SingleStore Data from Azure Data Factory and import live SingleStore.
-
Use Claude to Talk to Your CSV 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 CSV/TSV Files for you.
-
Enable the eBay Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with eBay Analytics.
-
Connect to MessageBird Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to MessageBird and work with MessageBird in your FileMaker applications.
-
Import Zoho CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoho CRM Data and provide access to live Zoho CRM for custom reports in the Power BI Service.
-
Connect to Facebook Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live Facebook Ads from Crystal Reports.
-
Build Semantic Layer Views for Certinia Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Certinia.
-
Working with Clari Data in LINQPad
Execute LINQ queries to Clari in LINQPad.
-
Automated Continuous Facebook Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Amazon S3.
-
Build Automated Amazon Marketplace-Connected Workflows in Zapier
Use CData Connect AI to connect to live Amazon Marketplace and build automated workflows in Zapier.
-
DataBind Controls to Sage Intacct Data in Delphi
DataBind to Sage Intacct in Delphi with standard data access components and controls.
-
How to Visualize Sentry Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sentry in Python.
-
Create a Data Access Object for NetSuite Data using JDBI
A brief overview of creating a SQL Object API for NetSuite CRM & ERP in JDBI.
-
Access Live Gorgias Data in AWS Lambda
Connect to live Gorgias in AWS Lambda using the CData JDBC Driver.
-
Connect to Teamgate Data in NetBeans
Connect to Teamgate in NetBeans with the data source configuration wizard.
-
Consume ServiceNow OData Feeds in PowerBuilder
This article demonstrates how to consume ServiceNow as OData feeds from PowerBuilder using the API Server.
-
How to Connect Flowise AI Agents to Live Email Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Email without replication.
-
Build Pipelines with Live FTP Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to FTP from Google Cloud Data Fusion, enabling the integration of live FTP Servers into the building and management of effective data pipelines.
-
How to Use a Microsoft Access Database to Update Basecamp Data in Real Time
Update Basecamp data by creating a linked table in Microsoft Access with the CData Basecamp ODBC Driver.
-
Provide OData Services of BigQuery Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google BigQuery by developing a WCF Service Application.
-
Getting Started with the CData JDBC Driver for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Stack Exchange.
-
Connect SendGrid to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SendGrid using the CData Python MCP Server.
-
Analyze SQL Analysis Services Data in Cognos Analytics
Use CData Connect AI to connect to SQL Analysis Services Data from Cognos Analytics and analyze live SQL Analysis Services.
-
Build Power BI XMLA-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Power BI XMLA to explore live Power BI XMLA Data in GitHub Copilot to assist with building Power BI XMLA-powered applications.
-
How to Connect the Power BI Service to Stack Exchange: Complete Guide
Connect to the CData Software Power BI Connector for Stack Exchange from PowerBI.com to provide real-time Stack Exchange across the organization.
-
Access Live Oracle Financials Cloud 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 Oracle Financials Cloud through MCP integration.
-
Automated Continuous Shortcut Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Shortcut replication to Amazon S3.
-
How to Access ElevenLabs Data Using Entity Framework
This article shows how to access ElevenLabs using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build MVC Applications with Connectivity to Mocean Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mocean from an ASP.NET MVC application.
-
Integrate SendInBlue with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SendInBlue with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SendInBlue.
-
Prepare, Blend, and Analyze Brex Data in Alteryx Designer (ODBC)
Build workflows to access live Brex for self-service data analytics.
-
Visualize Live Wistia Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Wistia.
-
Use the CData Software JDBC Driver for Reckon in MicroStrategy
Connect to Reckon in MicroStrategy Developer using the CData Software JDBC Driver for Reckon.
-
Create QuickBooks Online Dataflows on PowerBI.com
Connect to the CData Power BI Connector for QuickBooks Online from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Raisers Edge NXT Data in Sisense
Create an ElastiCube in Sisense app with access to Raisers Edge NXT.
-
Back Up Opsgenie 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 Opsgenie data.
-
Integrate SAS Data Sets with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAS Data Sets with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAS Data Sets.
-
Publish Avaza-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Avaza.
-
Create Sage Intacct Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sage Intacct from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for Jira Assets in MicroStrategy Desktop
Connect to Jira Assets in MicroStrategy Desktop using the CData Software ODBC Driver for Jira Assets.
-
Query Oracle Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Database.
-
Bidirectional Access to Sentry Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sentry in Filemaker Pro for Mac or Windows.
-
Automated Continuous EnterpriseDB Replication to Vertica
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Vertica.
-
Connect to Twilio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Twilio and the SQL Gateway to access Twilio from Google Apps Script.
-
Connect to Mouseflow Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mouseflow from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to integrate Metabase with Zoho CRM Data
Use CData Connect AI to connect to live Zoho CRM and create an interactive dashboard in Metabase from Zoho CRM.
-
Analyze Avaza Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Avaza with the CData JDBC Driver for Avaza.
-
Create Oracle Sales-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle Sales Data from Nintex Workflow Cloud and build custom workflows using live Oracle Sales.
-
Connect to HCL Domino Data in CloverDX (formerly CloverETL)
Transfer HCL Domino using the visual workflow in the CloverDX data integration tool.
-
Use the CData ODBC Driver for Cloudflare from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cloudflare to connect to Cloudflare from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Cloudflare in Excel.
-
Integrate ZohoInvoice Data in Pentaho Data Integration
Build ETL pipelines based on ZohoInvoice in the Pentaho Data Integration tool.
-
Google Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Analytics through CData Connect AI using different applications and tools.
-
Operational Reporting on PabblySubscriptions Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PabblySubscriptions.
-
Connect to Dropbox Data in RazorSQL
Connect to Dropbox from wizards and query Dropbox from the GUI in the RazorSQL database management tool.
-
Create SQL Analysis Services-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SQL Analysis Services Data from Klipfolio and build custom visualizations using live SQL Analysis Services.
-
Extract, Transform, and Load MySQL Data in Informatica PowerCenter
Create a simple Workflow for MySQL in Informatica PowerCenter.
-
Query Phoenix Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache Phoenix.
-
Replicate Timely Data to Multiple Databases via the CData Sync CLI
Replicate Timely to disparate databases with a single configuration.
-
Create Apps from Exact Online Data in Qlik Sense Cloud
Use CData Connect AI to connect to Exact Online Data and build apps from live Exact Online in Qlik Sense Cloud.
-
How to Access Live Oracle SCM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle SCM enables you to integrate Oracle SCM into workflows built using Microsoft Power Automate Desktop.
-
Build Automated Workflows with Live Paylocity Data in Workato
Use CData Connect AI to connect to live Paylocity and build automated workflows in Workato.
-
Integrate with Sage Intacct Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sage Intacct to a JSON file on disk.
-
Build Dashboards with Teamwork Data in Dundas BI
Create dynamic dashboards and perform analytics based on Teamwork in Dundas BI.
-
Replicate Multiple Mailjet Accounts
Replicate multiple Mailjet accounts to one or many databases.
-
Migrating data from Datadog to Snowflake using CData SSIS Components.
Easily push Datadog to Snowflake using the CData SSIS Tasks for Datadog and Snowflake.
-
Integrate Cursor with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Concur from within the editor.
-
Connect to OpenWeatherMap Data in JRuby
Create a simple JRuby app with access to live OpenWeatherMap.
-
Build a Simple VCL Application for PostgreSQL Data
How to build a simple VCL Application to view PostgreSQL in RAD Studio using the CData ODBC Driver for PostgreSQL.
-
Query Eventbrite Data in ColdFusion
Write standard ColdFusion data access code to connect to Eventbrite.
-
Build Salesforce CRM Analytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce CRM Analytics Data and create custom apps in Bubble.
-
Import Freshdesk Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Freshdesk Data and provide access to live Freshdesk for custom reports in the Power BI Service.
-
Integrate Theia IDE with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create Reports with SendInBlue Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SendInBlue.
-
How to Connect Oracle 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 Oracle data in real time using natural language.
-
How to publish and share LDAP Objects dashboards with Tableau Server
The CData ODBC driver for LDAP enables you integrate LDAP into Tableau dashboards.
-
Getting Started with the CData SSIS Components for Reply.io
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Reply.io.
-
Connect to Egnyte Data from a Connection Pool in JBoss
Integrate Egnyte into Java servlets: Use the Management Console in JBoss to install the Egnyte JDBC Driver.
-
How to connect and process Auth0 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Auth0.
-
Access Live Asana Data in Excel 365 Online (Excel for the web)
Connect to Asana from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate RabbitMQ with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate RabbitMQ with External Services.
-
Build MVC Applications with Connectivity to ZohoExpense Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoExpense from an ASP.NET MVC application.
-
Automated Continuous CData Connect AI Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Amazon S3.
-
Create Cosmos DB-Connected Business Apps in AppSheet
Connect to Cosmos DB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Cosmos DB.
-
Connect to SFTP Data in JRuby
Create a simple JRuby app with access to live SFTP.
-
Build Eventbrite-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Eventbrite.
-
Create EnterpriseDB-Connected Nintex Workflows
Use CData Connect AI to connect to EnterpriseDB Data from Nintex Workflow Cloud and build custom workflows using live EnterpriseDB.
-
How to Connect to Live SAP Ariba Source 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 SAP Ariba Source through natural language.
-
Prepare, Blend, and Analyze Trello Data in Alteryx Designer (Connect AI)
Build workflows to access live Trello for self-service data analytics.
-
Getting Started with the CData ODBC Driver for Coda
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Coda.
-
Connect to Grafana Data in Ruby
Connect to Grafana in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Salesforce Replication to SQLite
Use CData Sync for automated, continuous, customizable Salesforce replication to SQLite.
-
Integrating GitHub Copilot CLI with Google Campaign Manager 360 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 PagerDuty Data in NetBeans
Connect to PagerDuty in NetBeans with the data source configuration wizard.
-
Automated Continuous Raisers Edge NXT Replication to SQL Server
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to SQL Server.
-
Natively Connect to Workday Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Workday. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Raisers Edge NXT 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 Raisers Edge NXT for you.
-
Visualize Zoho Books Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho Books.