CData Software - Knowledge Base
Recent Articles
-
Connect to Live ADP Data in MicroStrategy through CData Connect AI
Create a live connection to ADP Data in CData Connect AI and connect to your ADP from MicroStrategy.
-
Automated Continuous Basecamp Replication to MySQL
Use CData Sync for automated, continuous, customizable Basecamp replication to MySQL.
-
Visualize Flowlu Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Flowlu.
-
Integrating Gumloop with Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Stripe within automated workflows.
-
A PostgreSQL Interface for ElevenLabs Data (MySQL Remoting via JDBC)
Use the Remoting features of the ElevenLabs JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Exact Online Data in Excel 365 Online (Excel for the web)
Connect to Exact Online from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to MailChimp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MailChimp and the SQL Gateway to access MailChimp from Google Apps Script.
-
How to connect SharePoint with Twilio Data through external lists
Provide Twilio to SharePoint users as an external list.
-
Automated Continuous LaunchDarkly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to IBM DB2.
-
Integrate Email with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Email with External Services.
-
How to load Neo4J data into Elasticsearch via Logstash
Introducing a simple method to load Neo4J data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Migrating data from SpaceX to Databricks using CData SSIS Components.
Easily push SpaceX to Databricks using the CData SSIS Tasks for SpaceX and Databricks.
-
Manage Azure Table Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Table.
-
Automated Continuous LinkedIn Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to SQL Server.
-
Bridge MailChimp Connectivity with Apache NiFi
Access and process MailChimp in Apache NiFi using the CData JDBC Driver.
-
Create Dashboards and Visualize Live Excel Online Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Excel Online and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Reckon Accounts Hosted Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Reckon Accounts Hosted in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live Snapchat Ads Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Snapchat Ads for you.
-
Integrate Google Spanner with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Spanner with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Spanner.
-
Build an OLAP Cube in SSAS from QuickBooks Online Data
Establish a connection to QuickBooks Online data from SQL Server Analysis Services, and use the QuickBooks Online Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to GraphQL Data from IntelliJ
Integrate connectivity to GraphQL with wizards in IntelliJ.
-
How to use SQLAlchemy ORM to access ZohoMarketingHub Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZohoMarketingHub.
-
Freshservice Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Freshservice facts in real time.
-
Use the CData Software ODBC Driver for Cassandra in MicroStrategy Web
Connect to Apache Cassandra in MicroStrategy Web using the CData Software ODBC Driver for Cassandra.
-
How to connect to SendPulse Data from IntelliJ
Integrate connectivity to SendPulse with wizards in IntelliJ.
-
Automated Continuous Elasticsearch Replication to Oracle
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Oracle.
-
Connect to Salesloft Data in HULFT Integrate
Connect to Salesloft as a JDBC data source in HULFT Integrate
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Aircall
Provide connectivity to Aircall through an SAP BusinessObjects universe.
-
Integrate with FreshBooks Data in SnapLogic
Use CData Connect AI to connect to and integrate with live FreshBooks in SnapLogic.
-
Integrating Kiro CLI with Bitbucket 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.
-
Load CSV Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CSV/TSV Files to a database.
-
Connect to OpenWeatherMap Data in Aqua Data Studio
Access OpenWeatherMap from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to ZeroBounce Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZeroBounce to connect to ZeroBounce and execute queries in PowerBuilder.
-
Query Miro Data in DataGrip
Create a Data Source for Miro in DataGrip and use SQL to query live Miro.
-
Migrating data from CockroachDB to Snowflake using CData SSIS Components.
Easily push CockroachDB to Snowflake using the CData SSIS Tasks for CockroachDB and Snowflake.
-
Connect to OData Services in RazorSQL
Connect to OData from wizards and query OData from the GUI in the RazorSQL database management tool.
-
Integrating Kiro CLI with Mixpanel 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.
-
JotForm Reporting in OBIEE with the JotForm JDBC Driver
Deploy the JotForm JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to SAP Business One Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Omnisend Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Omnisend in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
DataBind Controls to SAP Fieldglass Data in Delphi
DataBind to SAP Fieldglass in Delphi with standard data access components and controls.
-
Stream Parquet Data into Apache Kafka Topics
Access and stream Apache Parquet in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Procore Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Procore to connect to Procore and execute queries in PowerBuilder.
-
Process & Analyze Strava Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Strava Data.
-
Publish Crystal Reports on Tanda Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Tanda.
-
Create Avalara AvaTax-Connected Business Apps in AppSheet
Connect to Avalara AvaTax Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Avalara AvaTax.
-
Automated Continuous Impala Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Impala replication to Azure SQL Database.
-
Connect Dynamics NAV to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dynamics NAV with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Dotmailer Data in DBArtisan
Use wizards in DBArtisan to configure Dotmailer as a data source.
-
Connect to Google Spanner Data in HULFT Integrate
Connect to Google Spanner as a JDBC data source in HULFT Integrate
-
Access Live MarkLogic Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live MarkLogic through MCP integration.
-
Build a Singer.io Tap for Phoenix With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Phoenix data using
-
How to Work with LaunchDarkly Data in ETL Validator JDBC
Connect to LaunchDarkly from ETL Validator jobs using the CData Software JDBC Driver.
-
Natively Connect to Dynamics CRM Data in PHP
The CData ODBC driver for Dynamics CRM enables you to create PHP applications with connectivity to Microsoft Dynamics CRM. Leverage the native support for ODBC in PHP.
-
Deploy the ADO.NET Provider for ZohoDesk on an SSRS Report Server
Connect to ZohoDesk from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build SAS Data Sets-Connected Apps in Choreo
Use CData Connect AI to connect to SAS Data Sets Data from Choreo and build custom apps using live SAS Data Sets.
-
Build Charts with CircleCI Data in Clear Analytics
Create dynamic charts and perform analytics based on CircleCI in Clear Analytics.
-
Access Live LinkedIn Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn from your Excel spreadsheets.
-
Build Pipelines with Live Amazon Athena Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Amazon Athena from Google Cloud Data Fusion, enabling the integration of live Amazon Athena into the building and management of effective data pipelines.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Greenplum
Provide connectivity to Pivotal GreenPlum through an SAP BusinessObjects universe.
-
Seamlessly Bring Epicor Kinetic Data into Retool Using CData Connect AI
Integrate Epicor Kinetic data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating GitHub Copilot CLI with Stripe 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.
-
How to Work with Outlook Data in AWS Glue Jobs Using JDBC
Connect to Outlook from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Viewing Redis Data in RAD Studio Data Explorer
How to view Redis in RAD Studio Data Explorer using the CData ODBC Driver for Redis.
-
Use the CData Software ODBC Driver for Jira in SAS for Real-Time Reporting and Analytics
Connect to real-time Atlassian Jira in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jira.
-
How to Seamlessly Import iContact Data into IBM SPSS Modeler
Integrate iContact data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build an OLAP Cube in SSAS from Outreach.io Data
Establish a connection to Outreach.io data from SQL Server Analysis Services, and use the Outreach.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Multiple CouchDB Accounts
Replicate multiple CouchDB accounts to one or many databases.
-
Create Data Visualizations in Cognos BI with Demio Data
Access Demio as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Facebook Ads Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Facebook Ads and perform CRUD operations on Facebook Ads from Node.js.
-
Create SSAS Tabular Models from Google Drive Data
How to build a SQL Server Analysis Service Tabular Model from Google Drive using CData drivers.
-
How to Work with ZendeskSell Data in ETL Validator JDBC
Connect to ZendeskSell from ETL Validator jobs using the CData Software JDBC Driver.
-
Import Real-Time Copper Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Copper in ColdFusion.
-
Visualize Live QuickBooks Online Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live QuickBooks Online.
-
Build Semantic Layer Views for ActiveCampaign Data in APOS Live Data Gateway
Use the CData Connector for ActiveCampaign in APOS Live Data Gateway to build Semantic Layer Views for ActiveCampaign.
-
Feed ElevenLabs Data into FineReport
How to set ElevenLabs as a JDBC data source in FineReport.
-
Integrating Cursor CLI with Productboard 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.
-
Seamlessly Bring Reckon Accounts Hosted Data into Retool Using CData Connect AI
Integrate Reckon Accounts Hosted data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Claude Code CLI with Aha! 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.
-
Use Grok to Talk to Your DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your DocuSign for you.
-
Create SAP HANA-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP HANA Data from Klipfolio and build custom visualizations using live SAP HANA.
-
Integrate LibreChat with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Basecamp from within the chat interface.
-
Automated Continuous Zoho CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho CRM replication to SQL Server.
-
How to Connect to Live DB2 Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your IBM DB2 for you.
-
Connect to Printful Data in Ruby
Connect to Printful in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to SAP Fieldglass Data in JRuby
Create a simple JRuby app with access to live SAP Fieldglass.
-
Analyze Sybase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sybase and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automate Opsgenie Data Replication to Azure Data Lake
Use CData Sync to customize and automate Opsgenie replication to Azure Data Lake.
-
Getting Started with the CData SSIS Components for SFTP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SFTP.
-
Visualize Azure Data Lake Storage Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Data Lake Storage.
-
Connect to Microsoft Exchange Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Exchange in the Denodo Virtual DataPort Administrator.
-
Publish Crystal Reports on Impala Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Impala.
-
Integrating Kiro CLI with Yelp 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.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP HANA using the Model Context Protocol.
-
Connect to Exact Online Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Exact Online Data and connect to Exact Online in Akorbi Digital RunMyProcess.
-
How to Create Power BI Visual Reports with Real-Time Rootly Data
Use CData Power BI Connectors to visualize Rootly in Power BI.
-
Extract, Transform, and Load SAP SuccessFactors Data in Informatica PowerCenter
Create a simple Workflow for SAP SuccessFactors in Informatica PowerCenter.
-
Create Power BI Reports on Real-Time Marketo Data
Use the CData ODBC Driver for Marketo to visualize Marketo in Power BI Desktop.
-
Connect to Azure Analysis Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Analysis Services in the Denodo Virtual DataPort Administrator.
-
Building Dynamic Web Pages with Miro Data Using AngularJS
Create single-page applications with live connectivity to Miro using the CData API Server.