CData Software - Knowledge Base
Recent Articles
-
Create Oracle Financials Cloud-Connected Applications in Appsmith
Connect to Oracle Financials Cloud Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Financials Cloud.
-
Query Intercom Data in DataGrip
Create a Data Source for Intercom in DataGrip and use SQL to query live Intercom.
-
Automated Continuous Hive Replication to MongoDB
Use CData Sync for automated, continuous, customizable Hive replication to MongoDB.
-
Connect to Salesforce Pardot Data in JRuby
Create a simple JRuby app with access to live Salesforce Pardot.
-
Build Workday-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Workday to explore live Workday Data in Cursor to assist with building Workday-powered applications.
-
Connect to Epicor Kinetic 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 Epicor Kinetic.
-
Build AI/ML Models with Live CSV Data using Dataiku
Connect CSV Data with Dataiku using the CData JDBC Driver for CSV.
-
Integrate with Dynamics 365 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Dynamics 365 to a JSON file on disk.
-
How to Visualize Zoho Projects Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Projects in Python.
-
A PostgreSQL Interface for Adobe Commerce Data (MySQL Remoting via JDBC)
Use the Remoting features of the Adobe Commerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Paylocity Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Paylocity to connect to Paylocity and execute queries in PowerBuilder.
-
How to Query Live Drip Data in Claude Desktop
Connect to and query live Drip Data in Claude Desktop using CData MCP Server.
-
Bind Live Brex Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Brex data
-
Integrating Presto Data in Talend Cloud Data Management Platform
Connect Presto Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Presto.
-
Integrating LangGraph with SQL Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SQL Analysis Services within automated workflows.
-
Build AI/ML Models with Live Stack Exchange Data using Dataiku
Connect Stack Exchange Data with Dataiku using the CData API Driver for JDBC.
-
How to Query Live ZohoInvoice Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoInvoice data in natural language using Python.
-
Using the CData Software ODBC Driver for Twilio in PyCharm
Connect to Twilio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Twilio.
-
Replicate Google Spanner Data to Multiple Databases via the CData Sync CLI
Replicate Google Spanner to disparate databases with a single configuration.
-
Mistral AI Reporting in OBIEE with the Mistral AI JDBC Driver
Deploy the Mistral AI JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zoho CRM to Power BI dashboards. Simply drag and drop Zoho CRM into data visuals on the Power BI canvas.
-
Configure the CData JDBC Driver for OpenWeatherMap in a Connection Pool in Tomcat
Connect to OpenWeatherMap from a connection pool in Tomcat.
-
LINQ to Vimeo Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Vimeo Data Provider.
-
How to use SQLAlchemy ORM to access ZohoPeople Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZohoPeople.
-
Working with MailerLite Data in LINQPad
Execute LINQ queries to MailerLite in LINQPad.
-
Automated Continuous SAP HANA Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP HANA replication to Apache Kafka.
-
Integrate with Live BigQuery Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BigQuery from the MuleSoft Anypoint Platform to integrate live Google BigQuery into custom reports and dashboards.
-
Access SAP SuccessFactors Data from MySQL in Amazon QuickSight
Connect to SAP SuccessFactors and build visualizations of SAP SuccessFactors using a MySQL Connection in Amazon QuickSight.
-
Access Live Bullhorn CRM 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 Bullhorn CRM through MCP integration.
-
Connect to Adobe Analytics Data in RapidMiner
Integrate Adobe Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Prepare, Blend, and Analyze MailerSend Data in Alteryx Designer (ODBC)
Build workflows to access live MailerSend for self-service data analytics.
-
Publish Telegram-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Telegram.
-
Load Float Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Float to a database.
-
Replicate Multiple iContact Accounts
Replicate multiple iContact accounts to one or many databases.
-
Automate Rootly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Rootly from PowerShell? This article demonstrates how to utilize the Rootly Cmdlets for tasks like connecting to Rootly, automating operations, downloading data, and more.
-
Connecting Moonlit Workflow with Google Contacts Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Contacts in real time.
-
Using the CData Software ODBC Driver for LaunchDarkly in PyCharm
Connect to LaunchDarkly as an ODBC data source in PyCharm using the CData Software ODBC Driver for LaunchDarkly.
-
Connect to Amazon Athena Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon Athena in Airbyte.
-
Connect to Zoho Projects Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import and Visualize Office 365 Data in Power View
Create data visualizations based on Microsoft Office 365 in Excel.
-
Migrating data from Todoist to Databricks using CData SSIS Components.
Easily push Todoist to Databricks using the CData SSIS Tasks for Todoist and Databricks.
-
How to Easily Query VWO Data in OpenOffice Base
Connect to VWO data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Operational Reporting on Teamwork Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Teamwork.
-
Automated Continuous ZohoDesk Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoDesk replication to SQLite.
-
Connect to Raisers Edge NXT Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Google Directory Data from a Connection Pool in JBoss
Integrate Google Directory into Java servlets: Use the Management Console in JBoss to install the Google Directory JDBC Driver.
-
Prepare, Blend, and Analyze Bannerbear Data in Alteryx Designer (ODBC)
Build workflows to access live Bannerbear for self-service data analytics.
-
Publish Reports with MailChimp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailChimp.
-
Create Power BI Reports on Real-Time Google Ads Data
Use the CData ODBC Driver for Google Ads to visualize Google Ads in Power BI Desktop.
-
How to Use a Microsoft Access Database to Update Acumatica Data in Real Time
Update Acumatica data by creating a linked table in Microsoft Access with the CData Acumatica ODBC Driver.
-
Access EmailOctopus Data from MySQL in PHP
Connect to EmailOctopus through the standard MySQL libraries in PHP.
-
Connect to Amazon S3 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon S3 in FileMaker Pro to connect to Amazon S3 and work with Amazon S3 in your FileMaker applications.
-
How to Easily Query Brex Data in OpenOffice Base
Connect to Brex data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect DBeaver to CircleCI via a JDBC Driver
Manage CircleCI with visual tools in DBeaver like the query browser.
-
Create Informatica Mappings From/To a JDBC Data Source for Coinbase
Create Coinbase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Twitter Ads Data in Talend Cloud Data Management Platform
Connect Twitter Ads Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Twitter Ads.
-
Automated Continuous Trello Replication to MySQL
Use CData Sync for automated, continuous, customizable Trello replication to MySQL.
-
Migrating data from BigCommerce to Google BigQuery using CData SSIS Components.
Easily push BigCommerce to Google BigQuery using the CData SSIS Tasks for BigCommerce and Google BigQuery.
-
How to Connect the Power BI Service to Google Tasks: Complete Guide
Connect to the CData Software Power BI Connector for Google Tasks from PowerBI.com to provide real-time Google Tasks across the organization.
-
Build Sybase-Connected Apps in Choreo
Use CData Connect AI to connect to Sybase Data from Choreo and build custom apps using live Sybase.
-
Prepare, Blend, and Analyze Sage Cloud Accounting Data in Alteryx Designer (ODBC)
Build workflows to access live Sage Business Cloud Accounting for self-service data analytics.
-
Connect to Testmonitor Data from PowerBuilder via JDBC
This article demonstrates how to access Testmonitor from PowerBuilder using the Testmonitor JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Dynamics CRM using the Model Context Protocol.
-
Use Biml to Build SSIS Tasks to Replicate Dynamics 365 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Dynamics 365 to SQL Server.
-
Connect to Delighted Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Delighted in the Denodo Virtual DataPort Administrator.
-
Analyze Stripe Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Stripe and visualize Stripe in SAP Analytics Cloud.
-
Connect to Google Translate Data in RazorSQL
Connect to Google Translate from wizards and query Google Translate from the GUI in the RazorSQL database management tool.
-
Build Raisers Edge NXT-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Raisers Edge NXT and build Raisers Edge NXT-connected web apps with Axios.
-
Analyze Microsoft Entra ID Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Entra ID and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Publish Reports with Dropbox Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dropbox.
-
Model, Search, and Visualize Live IBM Informix Data in ThoughtSpot
Use CData Connect AI to connect to live IBM Informix for modeling, searching, and visualizing.
-
Analyze Factorial Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Factorial and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with MailerLite Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailerLite to a JSON file on disk.
-
Getting Started with the CData Excel Add-In for SAP
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP.
-
Build Oracle Eloqua-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Eloqua Data from Zoho Analytics and import live Oracle Eloqua.
-
Visualize xBase Data in Tableau
The CData ODBC driver for xBase enables you integrate xBase into Tableau dashboards.
-
Build Dashboards with Coda Data in Dundas BI
Create dynamic dashboards and perform analytics based on Coda in Dundas BI.
-
Use Databricks Agent Bricks to Talk to Your BigQuery Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google BigQuery for you.
-
Integrate Google Analytics Data Directly with BI, Analytics, and Database Tools with CData
A simple guide for integrating GA4 data directly with BI tools, analytics platforms, and databases using CData GA4 Drivers, enabling advanced analysis and reporting.
-
Acumatica Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Acumatica ERP through CData Connect AI using different applications and tools.
-
How to Query Sage Intacct Data in MySQL Workbench
Execute MySQL queries against live Sage Intacct from MySQL Workbench.
-
DataBind Controls to Highrise Data in Delphi
DataBind to Highrise CRM in Delphi with standard data access components and controls.
-
Integrate with PostgreSQL Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PostgreSQL to a JSON file on disk.
-
Automated SAS xpt Data Replication to Teradata
Use CData Sync to Customize and automate SAS XPORT replication to Teradata.
-
Visualize Jumpseller Data in Tableau
The CData ODBC driver for Jumpseller enables you integrate Jumpseller into Tableau dashboards.
-
Use the CData Software JDBC Driver for Close in MicroStrategy Desktop
Connect to Close in MicroStrategy Desktop using the CData Software JDBC Driver for Close.
-
Using the CData Software ODBC Driver for Omnisend in PyCharm
Connect to Omnisend as an ODBC data source in PyCharm using the CData Software ODBC Driver for Omnisend.
-
Integrate JobNimbus Data in the Pentaho Report Designer
Publish reports based on JobNimbus in the Pentaho BI tool.
-
Automate Tasks in Power Automate Using the CData API Server
Automate MYOB AccountRight actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Validate Oracle HCM Cloud Data with QuerySurge
Access and validate Oracle HCM Cloud in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Nethunt Replication to SQLite
Use CData Sync for automated, continuous, customizable Nethunt replication to SQLite.
-
How to work with ScrapingBee Data in Apache Spark using SQL
Access and process ScrapingBee Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect to PabblySubscriptions Data from Spring Boot
Connect to PabblySubscriptions in a Spring Boot Application using the CData API Driver for JDBC
-
Create Reports from Exact Online Data in Looker Studio
Use CData Connect AI to gain access to live Exact Online and create custom reports in Looker Studio.
-
Access Live Mistral AI Data in Coginiti Pro
Connect to and query live Mistral AI from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to and Visualize Live Access Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Access.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy Web
Connect to Adobe Analytics in MicroStrategy Web using the CData Software ODBC Driver for Adobe Analytics.
-
How to publish and share SAS xpt Data dashboards with Tableau Server
The CData ODBC driver for SAS xpt enables you integrate SAS XPORT into Tableau dashboards.
-
How to Seamlessly Import Procore Data into IBM SPSS Modeler
Integrate Procore data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Azure AI Foundry to Talk to Your SQL Analysis Services 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 SQL Analysis Services for you.