CData Software - Knowledge Base
Recent Articles
-
Publish Cloudflare-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Cloudflare.
-
How to integrate HDFS with Apache Airflow
Access and process Apache HDFS 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 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 for you.
-
How to load LionDesk data into Elasticsearch via Logstash
Introducing a simple method to load LionDesk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
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.
-
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 Microsoft Dynamics NAV 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 Apache Avro 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 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 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Perform Batch Operations with EnterpriseDB Data in Apache NiFi
Connect to EnterpriseDB 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 using CData drivers.
-
Prepare, Blend, and Analyze NASA Data in Alteryx Designer (ODBC)
Build workflows to access live NASA for self-service data analytics.
-
Connect to Excel Online Data in JRuby
Create a simple JRuby app with access to live Microsoft Excel Online.
-
Query SFTP Data in ColdFusion
Write standard ColdFusion data access code to connect to SFTP.
-
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 CLI 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 from your AWS Glue jobs.
-
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.
-
Replicate MongoDB Data in Heroku for Use in Salesforce Connect
Replicate MongoDB 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 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 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 IBM Cloudant using a MySQL Connection in Amazon QuickSight.
-
Analyze LionDesk Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LionDesk in Microsoft R Open.
-
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 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 into the statistical analysis tools available in SAS JMP. This article shows how to use PDFMonkey 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.
-
Integrate with Productboard Data in JReport Designer
Create charts and reports based on Productboard in JReport Designer.
-
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 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 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 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 Microsoft SharePoint in MySQL .
-
Access Smartsheet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Smartsheet 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. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Delighted 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 Delighted into a Java-based ORM framework, Hibernate.
-
Analyze Live QuickBooks Online Data in SAS Viya
Use CData Connect AI to connect to QuickBooks Online from SAS Viya and deploy self-service analytics using live QuickBooks Online.
-
Integrating Antigravity CLI with Discord via CData CLI
Connect Discord 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 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.
-
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 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 Perplexity Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Perplexity.
-
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.
-
Configure the CData JDBC Driver for Reckon in a Connection Pool in Tomcat
Connect to Reckon from a connection pool in Tomcat.
-
ETL GraphQL in Oracle Data Integrator
This article shows how to transfer GraphQL into a data warehouse using Oracle Data Integrator.
-
Prepare, Blend, and Analyze Airtable Data in Alteryx Designer (ODBC)
Build workflows to access live Airtable 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! to a database.
-
Query Neo4J Data in ColdFusion
Write standard ColdFusion data access code to connect to Neo4J.
-
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.
-
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.
-
Connect to Salesloft Data in Jaspersoft Studio
Execute SQL to remote Salesloft 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 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).
-
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 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 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 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 Accounting in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Xero.
-
Extend Google Sheets with XML Data
Make calls to XML from Google Apps Script via the API Server.
-
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 Servers by developing a WCF Service Application.
-
Query SendGrid Data in ColdFusion
Write standard ColdFusion data access code to connect to SendGrid.
-
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 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 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 from MicroStrategy.
-
Visualize xBase Data in TIBCO Spotfire through OData
Integrate xBase into dashboards in TIBCO Spotfire.
-
How to Design Salesforce CRM Analytics Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Salesforce CRM Analytics from mobile and tablet Power Apps.
-
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 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 and execute queries in PowerBuilder.
-
Extract, Transform, and Load Oracle Eloqua Reporting Data in Informatica PowerCenter
Create a simple Workflow for Oracle Eloqua Reporting in Informatica PowerCenter.
-
How to connect Amazon QuickSight to LinkedIn Data
Create a connection to LinkedIn in CData Connect AI and insert LinkedIn into Amazon QuickSight SPICE to build interactive dashboards.
-
Consume Xero OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Xero feeds that reflect any changes in SAP Lumira.
-
Connect to SAP HANA XS Advanced Data in RazorSQL
Connect to SAP HANA XS Advanced from wizards and query SAP HANA XS Advanced from the GUI in the RazorSQL database management tool.
-
Perform Batch Operations with Highrise Data in Apache NiFi
Connect to Highrise CRM and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Azure Synapse Data in AWS Lambda
Connect to live Azure Synapse in AWS Lambda using the CData JDBC Driver.
-
How to connect and process MariaDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MariaDB.
-
Automated Continuous GitLab Replication to SQL Server
Use CData Sync for automated, continuous, customizable GitLab replication to SQL Server.
-
Replicate Redis Data in Heroku for Use in Salesforce Connect
Replicate Redis to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to CircleCI Data from IntelliJ
Integrate connectivity to CircleCI with wizards in IntelliJ.
-
Use Dash to Build to Web Apps on Square Data
Create Python applications that use pandas and Dash to build Square-connected web apps.
-
Build Strava-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Strava.
-
How to Query Webex Data in MySQL Workbench
Execute MySQL queries against live Webex from MySQL Workbench.
-
Use the CData Software ODBC Driver for Toggl in SAS for Real-Time Reporting and Analytics
Connect to real-time Toggl in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Toggl.
-
Automated Continuous Google Calendar Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to PostgreSQL.
-
Build Apps with Live TigerGraph Data Using the Low-Code Development Platform of Mendix
Connect TigerGraph with Mendix to build apps using the CData JDBC Driver for TigerGraph.
-
Build Semantic Layer Views for Impala Data in APOS Live Data Gateway
Use the CData Connector for Impala in APOS Live Data Gateway to build Semantic Layer Views for Apache Impala.
-
How to connect to SQL Analysis Services Data from Spring Boot
Connect to SQL Analysis Services in a Spring Boot Application using the CData JDBC Driver for SQL Analysis Services
-
Automated Continuous Lakebase Replication to MongoDB
Use CData Sync for automated, continuous, customizable Lakebase replication to MongoDB.