CData Software - Knowledge Base
Recent Articles
-
How to integrate Metabase with Google Search Results
Use CData Connect AI to connect to live Google Search results and create an interactive dashboard in Metabase from Google Search results.
-
A PostgreSQL Interface for FTP Data using the CData ODBC Driver
Use the SQL Gateway and FTP ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access HelloSign Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HelloSign data from your Oracle system.
-
Use Dash to Build Web Apps on Salesforce Data 360 Data via CData Connect AI
Build interactive Dash web apps on live Salesforce Data 360 data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Insightly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Insightly replication to SingleStore.
-
Connect to Mouseflow Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mouseflow data using standard SQL.
-
Replicate Samanage Data to Multiple Databases via the CData Sync CLI
Replicate Samanage data to disparate databases with a single configuration.
-
Getting Started with the CData Connect AI Python SDK for Google Search
Install the CData Connect AI Python SDK to read live Google Search results with standard DB-API 2.0 Python code.
-
Rapidly Develop Templated-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Templated.
-
Connecting Mastra with Authorize.Net 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 Authorize.Net data, no replication required.
-
Connect to SAP Fieldglass Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Fieldglass data from PowerBuilder using the SAP Fieldglass JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Typeform
Provide connectivity to Typeform data through an SAP BusinessObjects universe.
-
Query, Visualize, and Share live QuickBooks Online Data in Redash
Use CData Connect AI to connect to live QuickBooks Online data in Redash for querying, visualizing, and sharing.
-
Natively Connect to SAP SuccessFactors LMS Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP SuccessFactors LMS data. Leverage the native support for ODBC in PHP.
-
Integrate Goose with Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live iContact data from within the local AI agent.
-
Automated Continuous Nethunt Replication to Oracle
Use CData Sync for automated, continuous, customizable Nethunt replication to Oracle.
-
Automated Continuous Sybase IQ Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Snowflake.
-
Create SuiteCRM-Connected Nintex Workflows
Use CData Connect AI to connect to SuiteCRM Data from Nintex Workflow Cloud and build custom workflows using live SuiteCRM data.
-
Building Dynamic Web Pages with Dynamics CRM Data Using AngularJS
Create single-page applications with live connectivity to Dynamics CRM using the CData API Server.
-
Getting Started with the CData Connect AI Python SDK for SAP HANA XS Advanced
Install the CData Connect AI Python SDK to read live SAP HANA XS Advanced data with standard DB-API 2.0 Python code.
-
Use CData Connect AI to Access Zoho Books Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho Books data in the Power Pivot business intelligence tool.
-
Create Datasets from Exa in Domo Workbench and Build Visualizations of Exa Data in Domo
Use the CData Software ODBC Driver for Exa to create datasets from Exa data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Excel Add-In for Elorus
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Elorus.
-
Interact with Live MariaDB Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live MariaDB data.
-
Use Manus AI to Talk to Your Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Sheets data.
-
Create Power BI Reports on Real-Time Adobe Experience Manager Data
Use the CData ODBC Driver for Adobe Experience Manager to visualize Adobe Experience Manager data in Power BI Desktop.
-
Build IBM Cloud Object Storage-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live IBM Cloud Object Storage data.
-
Migrating data from Bullhorn CRM to Google BigQuery using CData SSIS Components.
Easily push Bullhorn CRM data to Google BigQuery using the CData SSIS Tasks for Bullhorn CRM and Google BigQuery.
-
Integrate with live Box Data in Jitterbit
Use CData Connect AI to connect to and integrate live Box data in Jitterbit.
-
Connect MariaDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MariaDB data using the CData Python MCP Server.
-
Build Data Flows from Facebook Ads to SQL Server using SSIS
Easily back up Facebook Ads data to SQL Server using the SSIS components for Facebook Ads.
-
Automated Continuous Oracle Financials Cloud Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Snowflake.
-
How to Connect DBeaver to Impala via a JDBC Driver
Manage Impala data with visual tools in DBeaver like the query browser.
-
Import Campaigner Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Campaigner Data and provide access to live Campaigner data for custom reports in the Power BI Service.
-
Build Jira-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Jira data without replication.
-
Connect to ZohoSubscriptions 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 ZohoSubscriptions data.
-
Query Asana Data in DataGrip
Create a Data Source for Asana in DataGrip and use SQL to query live Asana data.
-
Automated Continuous Excel Online Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Excel Online replication to Apache Kafka.
-
Publish Jodoo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Jodoo data.
-
Integrate Tickspot Data in the Pentaho Report Designer
Publish reports based on Tickspot data in the Pentaho BI tool.
-
Using Microsoft Query in Excel to Connect to Salesforce
This article uses the CData ODBC driver for Salesforce to execute SQL with Microsoft Query in Excel. It will also demonstrate using parameters.
-
How to connect to EnterpriseDB Data from IntelliJ
Integrate connectivity to EnterpriseDB data with wizards in IntelliJ.
-
Query Keap Data in DataGrip
Create a Data Source for Keap in DataGrip and use SQL to query live Keap data.
-
Connect to Certinia Data in CloverDX (formerly CloverETL)
Transfer Certinia data using the visual workflow in the CloverDX data integration tool.
-
Use Agno to Talk to Your CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your CouchDB data for you.
-
How to integrate Google Tasks with Apache Airflow
Access and process Google Tasks data in Apache Airflow using the CData JDBC Driver.
-
How to integrate Todoist with Apache Airflow
Access and process Todoist data in Apache Airflow using the CData JDBC Driver.
-
Connect Rootly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Rootly with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Gumroad Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Gumroad data.
-
Create Informatica Mappings From/To an ODBC Data Source for Freshdesk
Create an ODBC connection to Freshdesk in Informatica and browse and transfer Freshdesk data.
-
DataBind Controls to Planio Data in C++Builder
DataBind to Planio data in C++Builder with standard components and controls.
-
Enable the SendPulse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SendPulse data.
-
Automate ClickUp Data Replication to Couchbase
Use CData Sync to Customize and automate ClickUp data replication to Couchbase.
-
Connect to Zendesk Data in DBArtisan
Use wizards in DBArtisan to configure Zendesk data as a data source.
-
Access SAP Netweaver Gateway Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Netweaver Gateway data from your Oracle system.
-
How to connect to NetSuite Data from Spring Boot
Connect to NetSuite in a Spring Boot Application using the CData JDBC Driver for NetSuite
-
How to connect to Dotmailer Data with Squirrel SQL client
Connect to Dotmailer data and execute queries in the Squirrel SQL Client.
-
Visualize Live Sage Intacct Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage Intacct data into custom reports in Power BI.
-
Integrating OpenCode with ConstantContact 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Exa
Provide connectivity to Exa data through an SAP BusinessObjects universe.
-
Getting Started with the CData Connect AI Python SDK for Dynamics 365
Install the CData Connect AI Python SDK to read and write live Dynamics 365 data with standard DB-API 2.0 Python code.
-
Provide OData Services of Microsoft Exchange Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Exchange data by developing a WCF Service Application.
-
Connect to XML Data from AWS Glue
Use CData Connect AI to gain access to live XML data from your AWS Glue jobs.
-
How to load Sage Intacct data into Elasticsearch via Logstash
Introducing a simple method to load Sage Intacct data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to use SQLAlchemy ORM to access Azure Data Catalog Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Data Catalog data.
-
Connect to Oracle Sales Data from a Connection Pool in Jetty
The Oracle Sales JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Sales data from Web apps in Jetty.
-
Create Data Visualizations Based On Dynamics NAV Data in Mode
Use CData Connect AI to connect to Dynamics NAV Data from Mode and build visualizations using live Dynamics NAV data.
-
Choosing the Best Method to Connect Neo4J to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Neo4J data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Databricks Agent Bricks to Talk to Your Blackbaud FE NXT Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Blackbaud FE NXT data for you.
-
How to integrate Neo4J with Apache Airflow
Access and process Neo4J data in Apache Airflow using the CData JDBC Driver.
-
Connect to Float from a Connection Pool in WebLogic
Use the CData JDBC Driver for Float to connect to Float data from Web applications running on WebLogic.
-
Easily Integrate Google Calendar Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Calendar data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Dynamics 365 Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to MySQL.
-
Perform Batch Operations with Office 365 Data in Apache NiFi
Connect to Office 365 data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Process & Analyze Gumroad Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Gumroad Data.
-
How to Create Power BI Visual Reports with Real-Time Grafana Data
Use CData Power BI Connectors to visualize Grafana data in Power BI.
-
How to Connect to Live ActiveCampaign 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 ActiveCampaign data through natural language.
-
How to Connect to Live ZohoExpense 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 ZohoExpense data through natural language.
-
How to connect Amazon QuickSight to Sage Intacct Data
Create a connection to Sage Intacct data in CData Connect AI and insert Sage Intacct data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Freshservice 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 Freshservice data.
-
Integrating Kiro with Flowlu 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.
-
CData AWS Glue Connector Trial
You can test and build out Proofs-of-Concept for the CData AWS Glue Connectors using the CData JDBC Drivers.
-
Integrate Clio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Clio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Clio data.
-
Building Dynamic Web Pages with Airtable Data Using AngularJS
Create single-page applications with live connectivity to Airtable using the CData API Server.
-
Automated Continuous LeadDesk Replication to Vertica
Use CData Sync for automated, continuous, customizable LeadDesk replication to Vertica.
-
Build Semantic Layer Views for Paymo Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Paymo data.
-
Create Tavily Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tavily data access from reports, embedded analytics, and more.
-
Connect Clockify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Clockify with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect the Power BI Service to Mailjet: Complete Guide
Connect to the CData Software Power BI Connector for Mailjet from PowerBI.com to provide real-time Mailjet data across the organization.
-
How to Visualize OnePageCrm Data in Python with pandas
Use pandas and other modules to analyze and visualize live OnePageCrm data in Python.
-
Automated Continuous Azure Synapse Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Azure SQL Database.
-
Getting Started with the CData Connect AI Python SDK for GitHub
Install the CData Connect AI Python SDK to read and write live GitHub data with standard DB-API 2.0 Python code.
-
Connect to and Visualize Live Scrapfly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Scrapfly data.
-
Migrating data from Certinia to Databricks using CData SSIS Components.
Easily push Certinia data to Databricks using the CData SSIS Tasks for Certinia and Databricks.
-
Prepare, Blend, and Analyze Humanity Data in Alteryx Designer (ODBC)
Build workflows to access live Humanity data for self-service data analytics.
-
Connect to Google Ad Manager Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Ad Manager data from Filemaker Pro on Mac.
-
Getting Started with the CData ODBC Driver for Basecamp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Basecamp.
-
Establish a Live Connection with Humanity Data using Tableau Bridge
The CData ODBC Driver for Humanity enables you to integrate live Humanity data into Tableau Cloud dashboards using the Tableau Bridge.
-
Natively Connect to Microsoft OneDrive Data in PHP
The CData ODBC driver for Microsoft OneDrive enables you to create PHP applications with connectivity to Microsoft OneDrive data. Leverage the native support for ODBC in PHP.
-
Integrate ZohoSubscriptions Data in Pentaho Data Integration
Build ETL pipelines based on ZohoSubscriptions data in the Pentaho Data Integration tool.