CData Software - Knowledge Base
Recent Articles
-
Create ADP-Connected Business Apps in AppSheet
Connect to ADP Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ADP.
-
Choosing the Best Method to Connect ZendeskSell to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZendeskSell from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations in Cognos BI with Teamwork Data
Access Teamwork as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Zoho Projects Data in Tableau
The CData ODBC driver for Zoho Projects enables you integrate Zoho Projects into Tableau dashboards.
-
Build SAS xpt-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAS xpt to explore live SAS xpt Data in Cursor to assist with building SAS xpt-powered applications.
-
Build Pipelines with Live Sybase Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sybase from Google Cloud Data Fusion, enabling the integration of live Sybase into the building and management of effective data pipelines.
-
Connect to SpaceX Data in CloverDX (formerly CloverETL)
Transfer SpaceX using the visual workflow in the CloverDX data integration tool.
-
Use the CData ODBC Driver for Google Drive in Microsoft Power Query
You can use the CData Google Drive ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Drive into Microsoft Power Query.
-
Integrate Oracle HCM Cloud Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle HCM Cloud and integrate live Oracle HCM Cloud into your Power Automate tasks.
-
How to connect to Facebook Data from IntelliJ
Integrate connectivity to Facebook with wizards in IntelliJ.
-
Connect to ChargeOver Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ChargeOver and the SQL Gateway to access ChargeOver from Google Apps Script.
-
Build QuickBooks Online-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks Online.
-
Integrate with Excel Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Excel to a JSON file on disk.
-
Connect to Azure DevOps from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure DevOps, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate ZohoPeople Data to Multiple Databases via the CData Sync CLI
Replicate ZohoPeople to disparate databases with a single configuration.
-
Use the CData Software ODBC Driver for Azure Synapse in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Synapse in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Synapse.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Ads
Provide connectivity to Microsoft Ads through an SAP BusinessObjects universe.
-
Connect to ConstantContact Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ConstantContact as an External Source in Dremio.
-
How to Work with WordPress Data in ETL Validator JDBC
Connect to WordPress from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Hive Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Hive data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Reports with Vercel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Vercel.
-
DataBind Controls to PingOne Data in Delphi
DataBind to PingOne in Delphi with standard data access components and controls.
-
Integrating Cursor CLI with Flowlu 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.
-
How to load Vercel data into Elasticsearch via Logstash
Introducing a simple method to load Vercel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Instagram Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Instagram.
-
How to Connect to Live Email Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Email through natural language.
-
Integrate Open WebUI with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Ads from within the chat interface.
-
Automate Facebook Data Replication to Couchbase
Use CData Sync to Customize and automate Facebook replication to Couchbase.
-
Connect SAP ByDesign Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Business ByDesign using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Spotify Data from PowerBuilder via JDBC
This article demonstrates how to access Spotify from PowerBuilder using the Spotify JDBC Driver.
-
Use Dash to Build to Web Apps on Coda Data
Create Python applications that use pandas and Dash to build Coda-connected web apps.
-
Connect to Real-Time HBase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HBase and Dataflow to import and use Apache HBase in Power Apps.
-
Analyze Microsoft OneDrive Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft OneDrive from Power Pivot. You will use the Table Import Wizard to load Microsoft OneDrive. You can visually build the import query or use any SQL supported by the driver.
-
How to use SQLAlchemy ORM to access Azure Synapse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Synapse.
-
Eventbrite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Eventbrite facts in real time.
-
Enable the SharePoint JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft SharePoint.
-
How to Connect to Live Highrise Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Highrise CRM for you.
-
How to Connect to Live Gong Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Gong for you.
-
Analyze Avaza Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Avaza from Power Pivot. You will use the Table Import Wizard to load Avaza. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software ODBC Driver for Trello in MicroStrategy
Connect to Trello in MicroStrategy Developer using the CData Software ODBC Driver for Trello.
-
How to Build an ETL App for Epicor Kinetic Data in Python with CData Connect AI
Build ETL pipelines that read and write live Epicor Kinetic in Python with petl and the CData Connect AI Python SDK.
-
Build Amazon Athena-Connected Apps in Choreo
Use CData Connect AI to connect to Amazon Athena Data from Choreo and build custom apps using live Amazon Athena.
-
Migrating data from Dynamics 365 to Databricks using CData SSIS Components.
Easily push Microsoft Dynamics 365 to Databricks using the CData SSIS Tasks for Dynamics 365 and Databricks.
-
Integrate with Slack Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Slack to a JSON file on disk.
-
Automate Presto Data Replication to Couchbase
Use CData Sync to Customize and automate Presto replication to Couchbase.
-
Create SSAS Tabular Models from EnterpriseDB Data
How to build a SQL Server Analysis Service Tabular Model from EnterpriseDB using CData drivers.
-
Import Real-Time Airtable Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Airtable in ColdFusion.
-
How to Connect the Power BI Service to Instagram: Complete Guide
Connect to the CData Software Power BI Connector for Instagram from PowerBI.com to provide real-time Instagram across the organization.
-
How to Connect to Live IBM Informix Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live IBM Informix without replication.
-
Migrating data from Parquet to Google BigQuery using CData SSIS Components.
Easily push Apache Parquet to Google BigQuery using the CData SSIS Tasks for Parquet and Google BigQuery.
-
Automate MariaDB Data Replication to SAP HANA
Use CData Sync to customize and automate MariaDB replication to SAP HANA.
-
Import and Visualize GetResponse Data in Power View
Create data visualizations based on GetResponse in Excel.
-
Create Reports from SendGrid Data in Looker Studio
Use CData Connect AI to gain access to live SendGrid and create custom reports in Looker Studio.
-
Use the CData Software ODBC Driver for Hugging Face in MicroStrategy Web
Connect to Hugging Face in MicroStrategy Web using the CData Software ODBC Driver for Hugging Face.
-
Extract, Transform, and Load Simplesat Data in Informatica PowerCenter
Create a simple Workflow for Simplesat in Informatica PowerCenter.
-
How to Query Live LinkedIn Ads Data in Claude Desktop
Connect to and query live LinkedIn Ads Data in Claude Desktop using CData MCP Server.
-
Build Dashboards with Cassandra Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Cassandra in Dundas BI.
-
How to connect to PagerDuty Data in DBVisualizer
Integrate PagerDuty with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Excel Add-In for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Netweaver Gateway.
-
Extend Google Sheets with Salesforce Pardot Data
Make calls to Salesforce Pardot from Google Apps Script via the API Server.
-
How to Work with Coinbase Data in AWS Glue Jobs Using JDBC
Connect to Coinbase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to ChartMogul Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ChartMogul using standard SQL.
-
Replicate Printful Data to Multiple Databases via the CData Sync CLI
Replicate Printful to disparate databases with a single configuration.
-
Automated Continuous Testmonitor Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Testmonitor replication to Apache Cassandra.
-
Getting Started with the CData Tableau Connector for Vimeo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Work with GraphQL Data in FoxPro
Load GraphQL into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Lakebase Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Lakebase through MCP integration.
-
Viewing Bugsnag Data in RAD Studio Data Explorer
How to view Bugsnag in RAD Studio Data Explorer using the CData ODBC Driver for Bugsnag.
-
Connect to PivotalTracker from a Connection Pool in WebLogic
Use the CData JDBC Driver for PivotalTracker to connect to PivotalTracker from Web applications running on WebLogic.
-
Access Freshservice 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 Freshservice.
-
How to create an RPA flow for PhantomBuster Data in UiPath Studio
Use the PhantomBuster ODBC Driver to create workflows that access real-time PhantomBuster without any coding.
-
Build an OLAP Cube in SSAS from HCL Domino Data
Establish a connection to HCL Domino data from SQL Server Analysis Services, and use the HCL Domino Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to load Amazon DynamoDB data into Elasticsearch via Logstash
Introducing a simple method to load Amazon DynamoDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live SurveyMonkey Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SurveyMonkey to Blue Prism using the CData ODBC Driver for SurveyMonkey to create automated workflows for repetitive business tasks.
-
Use CData Connect AI to Access Google Calendar Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Calendar in the Power Pivot business intelligence tool.
-
How to create Visio diagrams from Highrise Data
Automatically update Highrise CRM with the changes you make to Visio master shapes.
-
Visualize Live FHIR Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live FHIR using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Klaviyo Data in Heroku for Use in Salesforce Connect
Replicate Klaviyo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Office 365 Data in Tableau
The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.
-
Automated Continuous AdRoll Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable AdRoll replication to PostgreSQL.
-
Visualize SQL Server 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 Microsoft SQL Server into TIBCO Spotfire.
-
Automated Continuous Google Cloud Storage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Apache Kafka.
-
Design BIRT Reports on Stripe Data
Provide current Stripe to your embedded analytics.
-
Connect to Vertica Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Vertica from Filemaker Pro on Mac.
-
Stream SAP Business Warehouse Data into Apache Kafka Topics
Access and stream SAP Business Warehouse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize Dynamics 365 Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Microsoft Dynamics 365 in Python.
-
Enable the Campaigner JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Campaigner.
-
How to connect to Postmark Data from Spring Boot
Connect to Postmark in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Live Printful Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Printful to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Freshdesk Replication to MySQL
Use CData Sync for automated, continuous, customizable Freshdesk replication to MySQL.
-
How to Connect to Live DB2 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live IBM DB2 securely in real time.
-
Visualize MailerLite 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 MailerLite into TIBCO Spotfire.
-
Load Brex Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Brex to a database.
-
Design BIRT Reports on Google Directory Data
Provide current Google Directory to your embedded analytics.
-
Integrating Boomi Agentstudio with JSON Services via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to JSON, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Suadeo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Suadeo.
-
Automated Continuous SAS xpt Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAS xpt replication to Apache Cassandra.
-
Connect to Outreach.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to LinkedIn Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LinkedIn using standard SQL.
-
Replicate Multiple Bugsnag Accounts via the CData Sync CLI
Replicate multiple Bugsnag accounts to one or many databases.