CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from SQL Server to Google Calendar through SSIS
Easily push SQL Server data to Google Calendar using the CData SSIS Tasks for Google Calendar.
-
Access Samanage Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Samanage data.
-
Integrate Live Shopify Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Shopify from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Shopify data.
-
Load SendGrid Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SendGrid data to a database.
-
Working with Campaigner Data in LINQPad
Execute LINQ queries to Campaigner data in LINQPad.
-
Getting Started with the CData ODBC Driver for Clio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Clio.
-
Validate Avaza Data with QuerySurge
Access and validate Avaza data in QuerySurge using the CData JDBC Driver.
-
Analyze Elasticsearch Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Elasticsearch data with the CData JDBC Driver for Elasticsearch.
-
Create Supabase-Connected Business Apps in AppSheet
Connect to Supabase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Supabase data.
-
Automated Continuous OnePageCrm Replication to AlloyDB
Use CData Sync for automated, continuous, customizable OnePageCrm replication to AlloyDB.
-
Analyze SAP Fieldglass Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Fieldglass data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate LibreChat with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoom data from within the chat interface.
-
How to connect PolyBase to SAP SuccessFactors
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP SuccessFactors data.
-
How to Seamlessly Import Quickbase Data into IBM SPSS Modeler
Integrate Quickbase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Google's Vertex AI Agent with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Redis data within intelligent workflows.
-
Connect to and Query Sybase Data in QlikView over ODBC
Create data visualizations with Sybase data in QlikView.
-
Moving Data from Spotify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Spotify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Reports with Testmonitor Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Testmonitor data.
-
Prepare, Blend, and Analyze Oracle Eloqua Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle Eloqua data for self-service data analytics.
-
How to Connect to & Open Exact Online Data in Microsoft Excel
This article uses the CData ODBC driver for Exact Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Design BIRT Reports on PagerDuty Data
Provide current PagerDuty data to your embedded analytics.
-
Connect to Azure Table Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Table Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Salesforce Marketing Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Salesforce Marketing data and integrate live Salesforce Marketing data into your Power Automate tasks.
-
Create Data Visualizations in Cognos BI with Aha! Data
Access Aha! data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Azure Synapse Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure Synapse replication to AlloyDB.
-
How to Build an ETL App for Webex Data in Python with CData
Create ETL applications and real-time data pipelines for Webex data in Python with petl.
-
Create Dynamic Freshdesk Grids Using the Infragistics XamDataGrid
Learn how you can connect Freshdesk to Infragistics XamDataGrid to build dynamic grids.
-
How to create an RPA flow for Adobe Commerce Data in UiPath Studio
Use the Adobe Commerce ODBC Driver to create workflows that access real-time Adobe Commerce data without any coding.
-
Connect to Simplesat Data from PowerBuilder via JDBC
This article demonstrates how to access Simplesat data from PowerBuilder using the Simplesat JDBC Driver.
-
Integrating Dataiku with Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Kintone data.
-
Object-Relational Mapping (ORM) with Planio 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 Planio data into a Java-based ORM framework, Hibernate.
-
Connect to Apify Data in DBeaver
Use the CData ODBC Driver to connect to Apify data in DBeaver.
-
How to connect to Clari Data from Spring Boot
Connect to Clari in a Spring Boot Application using the CData API Driver for JDBC
-
Create Power BI Reports on Real-Time Zoho Recruit Data
Use the CData ODBC Driver for Zoho Recruit to visualize Zoho Recruit data in Power BI Desktop.
-
How to work with Discourse Data in Apache Spark using SQL
Access and process Discourse Data in Apache Spark using the CData Software JDBC Driver.
-
How to integrate Jodoo with Apache Airflow
Access and process Jodoo data in Apache Airflow using the CData JDBC Driver.
-
How to Connect Moosend 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 Moosend data in real time using natural language.
-
Connect and Query Live Bannerbear Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Bannerbear data into Databricks and enable direct, live querying and analysis without replication.
-
ShipStation Reporting in OBIEE with the ShipStation JDBC Driver
Deploy the ShipStation JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to import QuickBooks Data into Apache Solr
Use the CData Software JDBC Driver for QuickBooks in Data Import Handler and create an automated import of QuickBooks data to Apache Solr Enterprise Search platform.
-
Integrating Antigravity CLI with Jira Assets data via CData CLI
Connect Jira Assets data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Add Salesforce CRM Analytics Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce CRM Analytics with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Cursor with Neo4J 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.
-
Automated Continuous Beeminder Replication to SQL Server
Use CData Sync for automated, continuous, customizable Beeminder replication to SQL Server.
-
Replicate Tally Data from PowerShell
Write a quick PowerShell script to query Tally data. Use connectivity to the live data to replicate Tally data to SQL Server.
-
Configure the CData JDBC Driver for Bitly in a Connection Pool in Tomcat
Connect to Bitly data from a connection pool in Tomcat.
-
Automated Continuous Power BI XMLA Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Apache Cassandra.
-
Replicate Retently Data in Heroku for Use in Salesforce Connect
Replicate Retently data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Amazon S3 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon S3 data from your Oracle system.
-
How to Connect to Keap Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Keap data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous SQL Server Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SQL Server replication to delimited files (CSV/TSV).
-
Connect to Parquet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Parquet to connect to Parquet data from Web applications running on WebLogic.
-
Build Pipelines with Live Mailgun Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Mailgun from Google Cloud Data Fusion, enabling the integration of live Mailgun data into the building and management of effective data pipelines.
-
Automated Continuous eBay Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable eBay replication to PostgreSQL.
-
Automate Flowlu Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Flowlu data from PowerShell? This article demonstrates how to utilize the Flowlu Cmdlets for tasks like connecting to Flowlu data, automating operations, downloading data, and more.
-
Stream MongoDB Data into Apache Kafka Topics
Access and stream MongoDB data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to work with CSV Data in Apache Spark using SQL
Access and process CSV Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to SpaceX Data in DBArtisan
Use wizards in DBArtisan to configure SpaceX data as a data source.
-
Connect to Google Spanner Data in DBeaver
Use the CData ODBC Driver to connect to Google Spanner data in DBeaver.
-
Integrating Cohere Data in Talend Cloud Data Management Platform
Connect Cohere Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Facebook Ads Data in RazorSQL
Connect to Facebook Ads from wizards and query Facebook Ads data from the GUI in the RazorSQL database management tool.
-
Integrate Live Discord Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Discord data from within the IDE.
-
Import Real-Time ActiveCampaign Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ActiveCampaign data in ColdFusion.
-
Visualize Live Figshare Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Figshare data into custom reports in Power BI.
-
Connect Accelo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Accelo data using the CData Python MCP Server.
-
Visualize SuiteCRM Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SuiteCRM data into TIBCO Spotfire.
-
Seamlessly Bring Salesforce CRM Analytics Data into Retool Using CData Connect AI
Integrate Salesforce CRM Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to LinkedIn Ads Data in NetBeans
Connect to LinkedIn Ads data in NetBeans with the data source configuration wizard.
-
Rapidly Develop Epicor Kinetic-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 Epicor Kinetic.
-
A PostgreSQL Interface for PingOne Data (MySQL Remoting via JDBC)
Use the Remoting features of the PingOne JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Cursor with SAP SuccessFactors 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.
-
Replicate Multiple Campaigner Accounts
Replicate multiple Campaigner accounts to one or many databases.
-
Integrate Live Avro Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Avro from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Avro data.
-
Replicate Facebook Ads Data from PowerShell
Write a quick PowerShell script to query Facebook Ads data. Use connectivity to the live data to replicate Facebook Ads data to SQL Server.
-
How to create Twitter Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Twitter Ads data in MySQL .
-
Build Data Flows from Outreach.io to SQL Server using SSIS
Easily back up Outreach.io data to SQL Server using the SSIS components for Outreach.io.
-
Integrate BigCommerce Data into Power Automate Desktop using CData Connect
CData Connect for BigCommerce Data enables you to integrate BigCommerce data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Google Spanner Accounts
Replicate multiple Google Spanner accounts to one or many databases.
-
Connect to Real-Time Rootly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Rootly data in Power Apps.
-
How to Connect DBeaver to Suadeo via a JDBC Driver
Manage Suadeo data with visual tools in DBeaver like the query browser.
-
Create Drip Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Drip data access from reports, embedded analytics, and more.
-
Integrating Dataiku with Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Impala data.
-
Prepare, Blend, and Analyze Clio Data in Alteryx Designer (ODBC)
Build workflows to access live Clio data for self-service data analytics.
-
Connect to SAP Netweaver Gateway in SpagoBI
Create reports featuring live SAP Netweaver Gateway data in SpagoBI Studio. Host SAP Netweaver Gateway reports on SpagoBI Server.
-
Perform Batch Operations with Avalara AvaTax Data in Apache NiFi
Connect to Avalara AvaTax data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build a Singer.io Tap for Wave Financial With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Wave Financial data using the CData Python Connector.
-
Connect to Google Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Ads data from HeidiSQL.
-
Analyze Aweber Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Aweber data and visualize live Aweber data in Infragistics Reveal.
-
Connect to Highrise from Asprova with CData Software ODBC Driver for Highrise
This article shows how to connect faster to Highrise data from Asprova.
-
Automated Continuous PolarTeamPro Replication to SingleStore
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to SingleStore.
-
Integrate Devin with Live Redshift Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Redshift data.
-
Automated Continuous Clari Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Clari replication to Apache Kafka.
-
Automated Continuous Acumatica Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Acumatica replication to Google BigQuery.
-
DataBind Controls to WooCommerce Data in C++Builder
DataBind to WooCommerce data in C++Builder with standard components and controls.
-
Connect to Amazon Marketplace Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon Marketplace Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Authorize.Net Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Authorize.Net data.
-
Connect to Asana Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Asana data.
-
Stream Couchbase Data into Apache Kafka Topics
Access and stream Couchbase data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Oracle Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle data and integrate live Oracle data into your Power Automate tasks.
-
Integrate Nethunt Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Nethunt data from Informatica Cloud.