CData Software - Knowledge Base
Recent Articles
-
Add Avro Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Avro with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Visualize Vimeo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Vimeo in Python.
-
Visualize Live FormSite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live FormSite using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to integrate Metabase with Google Search Results
Use CData Connect AI to connect to live Google Search and create an interactive dashboard in Metabase from Google Search.
-
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 from your Oracle system.
-
Import Redshift Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Amazon Redshift. In this article, you will use the OData format to import Amazon Redshift into Microsoft Power Query.
-
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 using standard SQL.
-
Replicate Samanage Data to Multiple Databases via the CData Sync CLI
Replicate Samanage 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 and write live Google Search 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, no replication required.
-
Connect to SAP Fieldglass Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Fieldglass from PowerBuilder using the SAP Fieldglass JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Typeform
Provide connectivity to Typeform 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 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. Leverage the native support for ODBC in PHP.
-
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.
-
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.
-
Use CData Connect AI to Access Zoho Books Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho Books 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 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.
-
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.
-
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 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.
-
Migrating data from Bullhorn CRM to Google BigQuery using CData SSIS Components.
Easily push Bullhorn CRM 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 in Jitterbit.
-
Build CockroachDB-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for CockroachDB to explore live CockroachDB Data in GitHub Copilot to assist with building CockroachDB-powered applications.
-
Connect MariaDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MariaDB using the CData Python MCP Server.
-
Build Data Flows from Facebook Ads to SQL Server using SSIS
Easily back up Facebook Ads 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 Apache Impala with visual tools in DBeaver like the query browser.
-
Query Asana Data in DataGrip
Create a Data Source for Asana in DataGrip and use SQL to query live Asana.
-
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.
-
Integrate Tickspot Data in the Pentaho Report Designer
Publish reports based on Tickspot 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 with wizards in IntelliJ.
-
Query Keap Data in DataGrip
Create a Data Source for Keap in DataGrip and use SQL to query live Keap.
-
Connect to Certinia Data in CloverDX (formerly CloverETL)
Transfer Certinia 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 Apache CouchDB for you.
-
How to integrate Google Tasks with Apache Airflow
Access and process Google Tasks in Apache Airflow using the CData JDBC Driver.
-
How to integrate Todoist with Apache Airflow
Access and process Todoist 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Freshdesk
Create an ODBC connection to Freshdesk in Informatica and browse and transfer Freshdesk.
-
DataBind Controls to Planio Data in C++Builder
DataBind to Planio 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.
-
Automate ClickUp Data Replication to Couchbase
Use CData Sync to Customize and automate ClickUp replication to Couchbase.
-
Connect to Zendesk Data in DBArtisan
Use wizards in DBArtisan to configure Zendesk 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 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 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 into custom reports in Power BI.
-
How to Query Live OData Services in Perplexity MacOS Desktop
Connect to and query live OData Services in Perplexity Desktop using CData MCP Server.
-
Integrating OpenCode Terminal 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 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 Microsoft Dynamics 365 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 by developing a WCF Service Application.
-
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.
-
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 from Web apps in Jetty.
-
Choosing the Best Method to Connect Neo4J to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Neo4J 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 for you.
-
How to integrate Neo4J with Apache Airflow
Access and process Neo4J 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 from Web applications running on WebLogic.
-
Easily Integrate Google Calendar Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Calendar 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 Microsoft Office 365 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 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 through natural language.
-
How to connect Amazon QuickSight to Sage Intacct Data
Create a connection to Sage Intacct in CData Connect AI and insert Sage Intacct 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.
-
Integrating Kiro CLI 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.
-
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 Spark-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Spark to explore live Spark Data in GitHub Copilot to assist with building Spark-powered applications.
-
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 Design Stripe Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Stripe from mobile and tablet Power Apps.
-
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 across the organization.
-
How to Visualize OnePageCrm Data in Python with pandas
Use pandas and other modules to analyze and visualize live OnePageCrm 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 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.
-
Migrating data from Certinia to Databricks using CData SSIS Components.
Easily push Certinia 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 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 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 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. Leverage the native support for ODBC in PHP.
-
Integrate ZohoSubscriptions Data in Pentaho Data Integration
Build ETL pipelines based on ZohoSubscriptions in the Pentaho Data Integration tool.
-
Build Adobe Commerce-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Adobe Commerce to explore live Adobe Commerce Data in Claude Code to assist with building Adobe Commerce-powered applications.
-
Integrate Theia IDE with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Connect to Live Google Ads 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 Google Ads for you.
-
Use Dash to Build to Web Apps on iContact Data
Create Python applications that use pandas and Dash to build iContact-connected web apps.