CData Software - Knowledge Base
Recent Articles
-
Connect to SAS Data Sets Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAS Data Sets data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Teams
Provide connectivity to Microsoft Teams data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Service Cloud
Create Oracle Service Cloud data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Qualaroo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Qualaroo replication to Snowflake.
-
Use the CData Software JDBC Driver for Box in MicroStrategy
Connect to Box data in MicroStrategy Developer using the CData Software JDBC Driver for Box.
-
Integrate Theia IDE with Live Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Shortcut data from within the development environment.
-
Connect to AgileCRM Data in HULFT Integrate
Connect to AgileCRM as a JDBC data source in HULFT Integrate
-
Connect to Landbot Data in Ruby
Connect to Landbot data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Amazon DynamoDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Amazon DynamoDB Data and create custom apps in Bubble.
-
Migrating data from SAP Hybris C4C to Google BigQuery using CData SSIS Components.
Easily push SAP Hybris C4C data to Google BigQuery using the CData SSIS Tasks for SAP Hybris C4C and Google BigQuery.
-
Connect to OData Services in DBeaver
Use the CData ODBC Driver to connect to OData services in DBeaver.
-
Design BIRT Reports on Google Ads Data
Provide current Google Ads data to your embedded analytics.
-
Automate Superchat Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Superchat data from PowerShell? This article demonstrates how to utilize the Superchat Cmdlets for tasks like connecting to Superchat data, automating operations, downloading data, and more.
-
Publish Cloudflare-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Cloudflare data.
-
How to integrate HDFS with Apache Airflow
Access and process HDFS data in Apache Airflow using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Mistral AI Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mistral AI data to SQL Server.
-
How to Seamlessly Import BigQuery Data into IBM SPSS Modeler
Integrate BigQuery 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 SAP Hybris C4C 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 SAP Hybris C4C data for you.
-
Build Voice Agents in ElevenLabs with access to Live Google Spanner Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Spanner data.
-
Integrate with Dynamics NAV Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics NAV data to a JSON file on disk.
-
Create Datasets from Avro in Domo Workbench and Build Visualizations of Avro Data in Domo
Use the CData Software ODBC Driver for Avro to create datasets from Avro data in Domo Workbench and then build visualizations in the Domo service.
-
Process & Analyze SAP Netweaver Gateway Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Netweaver Gateway Data.
-
Automated Continuous Clockify Replication to Vertica
Use CData Sync for automated, continuous, customizable Clockify replication to Vertica.
-
Integrate Cohere Data in Pentaho Data Integration
Build ETL pipelines based on Cohere data in the Pentaho Data Integration tool.
-
Automated Continuous API Replication to MySQL
Use CData Sync for automated, continuous, customizable API replication to MySQL.
-
Connect to Copper Data in Ruby
Connect to Copper data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Perform Batch Operations with EnterpriseDB Data in Apache NiFi
Connect to EnterpriseDB data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create SSAS Tabular Models from xBase Data
How to build a SQL Server Analysis Service Tabular Model from xBase data using CData drivers.
-
Prepare, Blend, and Analyze NASA Data in Alteryx Designer (ODBC)
Build workflows to access live NASA data for self-service data analytics.
-
Connect to Excel Online Data in JRuby
Create a simple JRuby app with access to live Excel Online data.
-
Query SFTP Data in ColdFusion
Write standard ColdFusion data access code to connect to SFTP data.
-
Integrating ZohoSubscriptions Data in Talend Cloud Data Management Platform
Connect ZohoSubscriptions Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrating Cursor with Excel 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 Salesloft Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesloft replication to MongoDB.
-
Connect to CockroachDB Data from AWS Glue
Use CData Connect AI to gain access to live CockroachDB data from your AWS Glue jobs.
-
Query, Visualize, and Share live Anaplan Data in Redash
Use CData Connect AI to connect to live Anaplan data in Redash for querying, visualizing, and sharing.
-
How to Seamlessly Import Confluence Data into IBM SPSS Modeler
Integrate Confluence data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Live Salesforce Data 360 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Salesforce Data 360 in CData Connect AI and connect to your Salesforce Data 360 data from PostgreSQL.
-
Use Databricks Agent Bricks to Talk to Your AfterShip Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your AfterShip data for you.
-
Replicate MongoDB Data in Heroku for Use in Salesforce Connect
Replicate MongoDB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Controls to QuickBooks Time Data in Delphi
DataBind to QuickBooks Time data in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time Adobe Experience Manager Data
Use CData Power BI Connectors to visualize Adobe Experience Manager data in Power BI.
-
Moving Data from XML to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live XML data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Cloudant Data from MySQL in Amazon QuickSight
Connect to Cloudant and build visualizations of Cloudant data using a MySQL Connection in Amazon QuickSight.
-
Object-Relational Mapping (ORM) with Coda 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 Coda data into a Java-based ORM framework, Hibernate.
-
Access Live PDFMonkey Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PDFMonkey data into the statistical analysis tools available in SAS JMP. This article shows how to use PDFMonkey data in the Graph Builder and Query Builder.
-
Create MongoDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MongoDB Data from Klipfolio and build custom visualizations using live MongoDB data.
-
Integrate with Productboard Data in JReport Designer
Create charts and reports based on Productboard data in JReport Designer.
-
Automated Continuous Perigon Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Perigon replication to Google BigQuery.
-
Automated Continuous Harvest Replication to SQL Server
Use CData Sync for automated, continuous, customizable Harvest replication to SQL Server.
-
Stream Tavily Data into Apache Kafka Topics
Access and stream Tavily data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Okta Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Okta data in Microsoft R Open.
-
How to Create Power BI Visual Reports with Real-Time Google Ads Data
Use CData Power BI Connectors to visualize Google Ads data in Power BI.
-
How to create SharePoint federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SharePoint data in MySQL .
-
Access Smartsheet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Smartsheet data from your Oracle system.
-
Natively Connect to SendInBlue Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SendInBlue data. Leverage the native support for ODBC in PHP.
-
Use Claude to Talk to Your AfterShip 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 AfterShip data for you.
-
Analyze Live QuickBooks Online Data in SAS Viya
Use CData Connect AI to connect to QuickBooks Online data from SAS Viya and deploy self-service analytics using live QuickBooks Online data.
-
Integrating Antigravity CLI with Discord data via CData CLI
Connect Discord data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Exa Data from PowerBuilder via JDBC
This article demonstrates how to access Exa data from PowerBuilder using the Exa JDBC Driver.
-
Connect to Sugar CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sugar CRM data.
-
Integrate with Jumpseller Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Jumpseller data to a JSON file on disk.
-
Using the CData Software ODBC Driver for Outreach.io in PyCharm
Connect to Outreach.io as an ODBC data source in PyCharm using the CData Software ODBC Driver for Outreach.io.
-
Visualize Live SAP Business Warehouse Data in the Power BI Service
Use CData Connect AI to connect to live SAP Business Warehouse data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Perplexity Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Perplexity data.
-
Automated Continuous Sage Cloud Accounting Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to SingleStore.
-
Create Apollo-Connected Applications in Appsmith
Connect to Apollo Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Apollo data.
-
Integrating LlamaIndex with Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Jumpseller data in real time.
-
Configure the CData JDBC Driver for Reckon in a Connection Pool in Tomcat
Connect to Reckon data from a connection pool in Tomcat.
-
ETL GraphQL in Oracle Data Integrator
This article shows how to transfer GraphQL data into a data warehouse using Oracle Data Integrator.
-
Prepare, Blend, and Analyze Airtable Data in Alteryx Designer (ODBC)
Build workflows to access live Airtable data for self-service data analytics.
-
Load Aha! Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Aha! data to a database.
-
Query Neo4J Data in ColdFusion
Write standard ColdFusion data access code to connect to Neo4J data.
-
How to load Hacker News data into Elasticsearch via Logstash
Introducing a simple method to load Hacker News data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create eBay-Connected Nintex Workflows
Use CData Connect AI to connect to eBay Data from Nintex Workflow Cloud and build custom workflows using live eBay data.
-
Model ActiveCampaign Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ActiveCampaign, enabling the direct import of real-time ActiveCampaign data.
-
Connect to Salesloft Data in Jaspersoft Studio
Execute SQL to remote Salesloft data in Jaspersoft Studio.
-
Build Agents in Relevance AI with Access to Live MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MySQL data within intelligent agent workflows.
-
Automated Continuous ShipEngine Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ShipEngine replication to delimited files (CSV/TSV).
-
Build Pipelines with Live Adobe Experience Manager Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Adobe Experience Manager from Google Cloud Data Fusion, enabling the integration of live Adobe Experience Manager data into the building and management of effective data pipelines.
-
How to Connect to & Open Bannerbear Data in Microsoft Excel
This article uses the CData ODBC driver for Bannerbear to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate GetResponse Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live GetResponse data from Informatica Cloud.
-
Connect to LinkedIn Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LinkedIn Ads data in the Denodo Virtual DataPort Administrator.
-
Connect Teamwork Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Teamwork data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software ODBC Driver for Xero in SAS for Real-Time Reporting and Analytics
Connect to real-time Xero data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Xero.
-
A PostgreSQL Interface for PolarTeamPro Data using the CData ODBC Driver
Use the SQL Gateway and PolarTeamPro ODBC Driver to create a PostgreSQL entry-point for data access.
-
Provide OData Services of FTP Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for FTP data by developing a WCF Service Application.
-
Query SendGrid Data in ColdFusion
Write standard ColdFusion data access code to connect to SendGrid data.
-
Getting Started with the CData ADO.NET Provider for LeadDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
A PostgreSQL Interface for Oracle Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time SAP SuccessFactors LMS Data in Power BI Report Server
Use the CData ODBC Driver for SAP SuccessFactors LMS to visualize SAP SuccessFactors LMS data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software JDBC Driver for Gorgias in MicroStrategy
Connect to Gorgias data in MicroStrategy Developer using the CData Software JDBC Driver for Gorgias.
-
GraphQL Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on GraphQL facts in real time.
-
Connect to Live Okta Data in MicroStrategy through CData Connect AI
Create a live connection to Okta Data in CData Connect AI and connect to your Okta data from MicroStrategy.
-
Visualize xBase Data in TIBCO Spotfire through OData
Integrate xBase data into dashboards in TIBCO Spotfire.
-
Integrate Dify with Live SendGrid Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SendGrid data.
-
Connect to LinkedIn Ads Data from a Connection Pool in Jetty
The LinkedIn Ads JDBC Driver supports connection pooling: This article shows how to connect faster to LinkedIn Ads data from Web apps in Jetty.
-
Connect to TigerGraph Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for TigerGraph to connect to TigerGraph data and execute queries in PowerBuilder.
-
Extract, Transform, and Load Oracle Eloqua Reporting Data in Informatica PowerCenter
Create a simple Workflow for Oracle Eloqua Reporting data in Informatica PowerCenter.
-
How to connect Amazon QuickSight to LinkedIn Data
Create a connection to LinkedIn data in CData Connect AI and insert LinkedIn data into Amazon QuickSight SPICE to build interactive dashboards.