CData Software - Knowledge Base
Recent Articles
-
Visualize Live Twitter Ads Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Twitter Ads data.
-
Integrate Devin with Live Snowflake 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 Snowflake data.
-
Create SAP Ariba Source-Connected Dashboards in Grafana
Connect to SAP Ariba Source Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Ariba Source data.
-
Build Charts with Zendesk Data in Clear Analytics
Create dynamic charts and perform analytics based on Zendesk data in Clear Analytics.
-
Build MariaDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MariaDB data and build MariaDB-connected web apps with Axios.
-
Create Informatica Mappings From/To a JDBC Data Source for ClickTime
Create ClickTime data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
DataBind Controls to Zuora Data in C++Builder
DataBind to Zuora data in C++Builder with standard components and controls.
-
Configure the CData JDBC Driver for ClickTime in a Connection Pool in Tomcat
Connect to ClickTime data from a connection pool in Tomcat.
-
Connect to Email Data from Crystal Reports
Use CData Connect AI to connect to and report on live Email data from Crystal Reports.
-
How to create MySQL federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MySQL data in MySQL .
-
Connect to Marketo Data in RapidMiner
Integrate Marketo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with live SendGrid Data in Jitterbit
Use CData Connect AI to connect to and integrate live SendGrid data in Jitterbit.
-
Integrate Live Exa 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 Exa data from within the IDE.
-
How to Connect the Power BI Service to SAS xpt: Complete Guide
Connect to the CData Software Power BI Connector for SAS xpt from PowerBI.com to provide real-time SAS xpt data across the organization.
-
How to connect to Zoho Books Data from IntelliJ
Integrate connectivity to Zoho Books data with wizards in IntelliJ.
-
Visualize Sage 300 Data in TIBCO Spotfire through ADO.NET
Integrate Sage 300 data into dashboards in TIBCO Spotfire.
-
Use CData Connect AI to Access Bright Data Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Bright Data data in the Power Pivot business intelligence tool.
-
Automated Continuous Office 365 Replication to Vertica
Use CData Sync for automated, continuous, customizable Office 365 replication to Vertica.
-
How to use SQLAlchemy ORM to access Azure Analysis Services Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Analysis Services data.
-
Connect to Adobe Target Data in Aqua Data Studio
Access Adobe Target data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Data Flows from Shortcut to SQL Server using SSIS
Easily back up Shortcut data to SQL Server using the SSIS components for Shortcut.
-
Build Charts with Onfleet Data in Clear Analytics
Create dynamic charts and perform analytics based on Onfleet data in Clear Analytics.
-
Validate Airtable Data with QuerySurge
Access and validate Airtable data in QuerySurge using the CData JDBC Driver.
-
Build Dashboards with Vault CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Vault CRM data in DBxtra.
-
Provide OData Services of LaunchDarkly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LaunchDarkly data by developing a WCF Service Application.
-
Connect to MarkLogic Data from a Connection Pool in Jetty
The MarkLogic JDBC Driver supports connection pooling: This article shows how to connect faster to MarkLogic data from Web apps in Jetty.
-
How to Work with SFTP Data in AWS Glue Jobs Using JDBC
Connect to SFTP from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access SAP SuccessFactors LMS Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP SuccessFactors LMS data from your Oracle system.
-
How to Access Live WordPress Data in Power Automate Desktop via ODBC
The CData ODBC Driver for WordPress enables you to integrate WordPress data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Printify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Printify data replication to OneLake in Microsoft Fabric.
-
How to load Klaviyo data into Elasticsearch via Logstash
Introducing a simple method to load Klaviyo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to load Jira Assets data into Elasticsearch via Logstash
Introducing a simple method to load Jira Assets data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate OpenCode with Live Zendesk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zendesk data from within your AI coding agent.
-
Connect to Microsoft Planner Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Planner to connect to Microsoft Planner data and execute queries in PowerBuilder.
-
Access Live PostgreSQL Data in AWS Lambda
Connect to live PostgreSQL data in AWS Lambda using the CData JDBC Driver.
-
Integrating Google Cloud Storage Data in Talend Cloud Data Management Platform
Connect Google Cloud Storage Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Cloud Storage.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Cloud Storage
Create an ODBC connection to Google Cloud Storage in Informatica and browse and transfer Google Cloud Storage data.
-
Connect to Spark Data from HeidiSQL
Use CData Connect AI to connect to and query live Spark data from HeidiSQL.
-
Automated Continuous Highrise Replication to SingleStore
Use CData Sync for automated, continuous, customizable Highrise replication to SingleStore.
-
Create Salesforce Data 360-Connected Dashboards in Grafana
Connect to Salesforce Data 360 Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Salesforce Data 360 data.
-
Query, Visualize, and Share live Tally Data in Redash
Use CData Connect AI to connect to live Tally data in Redash for querying, visualizing, and sharing.
-
Model, Search, and Visualize Live Excel Online Data in ThoughtSpot
Use CData Connect AI to connect to live Excel Online data for modeling, searching, and visualizing.
-
Automate Google Campaign Manager 360 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Campaign Manager 360 data replication to Azure Data Lake.
-
Import Typeform Data Using Azure Data Factory
Use CData Connect AI to connect to Typeform Data from Azure Data Factory and import live Typeform data.
-
Integrate with Moosend Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Moosend data to a JSON file on disk.
-
Migrating data from Instagram to Snowflake using CData SSIS Components.
Easily push Instagram data to Snowflake using the CData SSIS Tasks for Instagram and Snowflake.
-
Integrate Live HDFS 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 HDFS data from within the IDE.
-
Connect to Real-Time Reckon Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Reckon and Dataflow to import and use Reckon data in Power Apps.
-
Build Semantic Layer Views for HDFS Data in APOS Live Data Gateway
Use the CData Connector for HDFS in APOS Live Data Gateway to build Semantic Layer Views for HDFS data.
-
Getting Started with the CData SSIS Components for Accelo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Accelo.
-
Access Onfleet Data from MySQL in Amazon QuickSight
Connect to Onfleet and build visualizations of Onfleet data using a MySQL Connection in Amazon QuickSight.
-
Build Simplesat-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Simplesat data and build web apps with connectivity to live Simplesat data.
-
Building Dynamic Web Pages with SAS Data Sets Data Using AngularJS
Create single-page applications with live connectivity to SAS Data Sets using the CData API Server.
-
Import Real-Time ChartMogul Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ChartMogul data in ColdFusion.
-
A PostgreSQL Interface for CampaignMonitor Data (MySQL Remoting via JDBC)
Use the Remoting features of the CampaignMonitor JDBC Driver to create a PostgreSQL entry-point for data access.
-
Viewing Scrapfly Data in RAD Studio Data Explorer
How to view Scrapfly data in RAD Studio Data Explorer using the CData ODBC Driver for Scrapfly.
-
Use Biml to Build SSIS Tasks to Replicate Moosend Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Moosend data to SQL Server.
-
Rapidly Develop Excel Online-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 Excel Online.
-
Natively Connect to Autopilot Data in PHP
The CData ODBC driver for Autopilot enables you to create PHP applications with connectivity to Autopilot data. Leverage the native support for ODBC in PHP.
-
Build Dashboards with OneNote Data in DBxtra
Create dynamic dashboards and perform analytics based on OneNote data in DBxtra.
-
Visualize Live Anaplan Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Anaplan data.
-
Getting Started with the CData Tableau Connector for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SharePoint Excel Services.
-
Integrating Vercel Data in Talend Cloud Data Management Platform
Connect Vercel Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Feed Quickbase Data into FineReport
How to set Quickbase data as a JDBC data source in FineReport.
-
Perform Batch Operations with Sybase IQ Data in Apache NiFi
Connect to Sybase IQ data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to AfterShip Data in CloverDX (formerly CloverETL)
Transfer AfterShip data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous QuickBooks Online Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to delimited files (CSV/TSV).
-
Create Informatica Mappings From/To a JDBC Data Source for Adobe Commerce
Create Adobe Commerce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Antigravity CLI with Google Spanner data via CData CLI
Connect Google Spanner data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to QuickBooks Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for QuickBooks data in Airbyte.
-
Build Data Flows from LeadDesk to SQL Server using SSIS
Easily back up LeadDesk data to SQL Server using the SSIS components for LeadDesk.
-
Integrate Google's Vertex AI Agent with Live Mode 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 Mode data within intelligent workflows.
-
Process & Analyze Superchat Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Superchat Data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Typeform
Provide connectivity to Typeform data through an SAP BusinessObjects universe.
-
Access Live Google Campaign Manager 360 Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Campaign Manager 360 data from your Google Sheets.
-
Access Live Egnyte 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 Egnyte data through MCP integration.
-
Connect to Live Samanage Data in MicroStrategy through CData Connect AI
Create a live connection to Samanage Data in CData Connect AI and connect to your Samanage data from MicroStrategy.
-
Integrate Devin with Live Oracle Financials Cloud 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 Oracle Financials Cloud data.
-
Analyze Amazon DynamoDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Amazon DynamoDB from Power Pivot. You will use the Table Import Wizard to load Amazon DynamoDB data. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from Tickspot to Google BigQuery using CData SSIS Components.
Easily push Tickspot data to Google BigQuery using the CData SSIS Tasks for Tickspot and Google BigQuery.
-
Analyze ServiceDesk Plus Data in Looker
Use CData Connect AI to connect to ServiceDesk Plus Data from Looker and build custom apps using live ServiceDesk Plus data.
-
Integrate CircleCI Data in the Pentaho Report Designer
Publish reports based on CircleCI data in the Pentaho BI tool.
-
How to Connect to Live Salesforce 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 Salesforce data for you.
-
Build Data Flows from Twitter Ads to SQL Server using SSIS
Easily back up Twitter Ads data to SQL Server using the SSIS components for Twitter Ads.
-
Visualize Live Zoho Projects Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Projects data.
-
How to load Sybase IQ data into Elasticsearch via Logstash
Introducing a simple method to load Sybase IQ data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Oracle Eloqua Data in TIBCO Data Virtualization
Use the Oracle Eloqua Tibco DV Adapter to create a Oracle Eloqua data data source in TIBCO Data Virtualization Studio and gain access to live Oracle Eloqua data from your TDV Server.
-
How to Use a Microsoft Access Database to Update SendGrid Data in Real Time
Update SendGrid data by creating a linked table in Microsoft Access with the CData SendGrid ODBC Driver.
-
How to create Spotify federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Spotify data in MySQL .
-
Process & Analyze Mocean Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mocean Data.
-
Deploy the ADO.NET Provider for Greenhouse on an SSRS Report Server
Connect to Greenhouse data 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 an OLAP Cube in SSAS from Zendesk Data
Establish a connection to Zendesk data data from SQL Server Analysis Services, and use the Zendesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Twilio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Twilio facts in real time.
-
Getting Started with the CData ADO.NET Provider for BambooHR
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to ShipStation from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ShipStation data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Use a Microsoft Access Database to Update Oracle Sales Data in Real Time
Update Oracle Sales data by creating a linked table in Microsoft Access with the CData Oracle Sales ODBC Driver.
-
Build Oracle Financials Cloud-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle Financials Cloud Data and create custom apps in Mendix.
-
Connect to Zoho Projects Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Projects and the Script function in FileMaker Pro to connect to Zoho Projects and work with Zoho Projects data in your FileMaker application.
-
Automated Brex Data Replication to Teradata
Use CData Sync to Customize and automate Brex data replication to Teradata.
-
Visualize Tally Data in Sisense
Create an ElastiCube in Sisense app with access to Tally data.