CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Aweber Data in Informatica PowerCenter
Create a simple Workflow for Aweber in Informatica PowerCenter.
-
Create IBM Informix-Connected Nintex Workflows
Use CData Connect AI to connect to IBM Informix Data from Nintex Workflow Cloud and build custom workflows using live IBM Informix.
-
Integrating Cursor CLI with Browserless 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.
-
Connecting Pipedream with BigQuery Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on BigQuery data in real time.
-
Getting Started with the CData JDBC Driver for PayPal
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PayPal.
-
Connect to and Query Scrapfly Data in QlikView over ODBC
Create data visualizations with Scrapfly in QlikView.
-
Import Real-Time BigCommerce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use BigCommerce in ColdFusion.
-
Create Invoiced Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Invoiced data access from reports, embedded analytics, and more.
-
Query Dynamics 365 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Dynamics 365 from Node.js.
-
Import HBase Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to HBase Data and provide access to live Apache HBase for custom reports in the Power BI Service.
-
How to integrate Metabase with SAP Ariba Procurement Data
Use CData Connect AI to connect to live SAP Ariba Procurement and create an interactive dashboard in Metabase from SAP Ariba Procurement.
-
Automated Continuous JSON Services Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable JSON replication to OneLake in Microsoft Fabric.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SurveyMonkey
Provide connectivity to SurveyMonkey through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Telegram in MicroStrategy Desktop
Connect to Telegram in MicroStrategy Desktop using the CData Software JDBC Driver for Telegram.
-
Integrating Kiro CLI with Hacker News 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.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SAP Hybris C4C actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Query Google Drive Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Drive from Node.js.
-
Automate YouTube Analytics Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live YouTube Analytics and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Data Flows from Salesloft to SQL Server using SSIS
Easily back up Salesloft to SQL Server using the SSIS components for Salesloft.
-
How to create ZendeskSell federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ZendeskSell in MySQL .
-
Analyze Square Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Square from Power Pivot. You will use the Table Import Wizard to load Square. You can visually build the import query or use any SQL supported by the driver.
-
Build Data Flows from Stack Exchange to SQL Server using SSIS
Easily back up Stack Exchange to SQL Server using the SSIS components for Stack Exchange.
-
How to load ZarMoney data into Elasticsearch via Logstash
Introducing a simple method to load ZarMoney data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Kintone Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Kintone from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Kintone.
-
Getting Started with the CData ODBC Driver for Freshteam
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Freshteam.
-
Replicate Multiple Odoo Accounts via the CData Sync CLI
Replicate multiple Odoo accounts to one or many databases.
-
Access Live SparkPost Data in AWS Lambda
Connect to live SparkPost in AWS Lambda using the CData JDBC Driver.
-
How to Easily Query AgileCRM Data in OpenOffice Base
Connect to AgileCRM data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Typeform Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Typeform and work with Typeform in your FileMaker applications.
-
Integrating OpenCode Terminal with Reply.io 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.
-
Create Reports from SAP SuccessFactors Data in Looker Studio
Use CData Connect AI to gain access to live SAP SuccessFactors and create custom reports in Looker Studio.
-
Process & Analyze Google Analytics Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Analytics Data.
-
Connect to and Query Supabase Data in QlikView over ODBC
Create data visualizations with Supabase in QlikView.
-
Work with Live Square Data in Power Query
Use CData Connect AI to connect to Square and work with live Square in Microsoft Power Query.
-
Analyze FreshBooks Data in Looker
Use CData Connect AI to connect to FreshBooks Data from Looker and build custom apps using live FreshBooks.
-
Getting Started with the CData Tableau Connector for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure Data Lake Storage.
-
Integrating Microsoft Ads Data in Talend Cloud Data Management Platform
Connect Microsoft Ads Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft Ads.
-
How to Connect DBeaver to Bitly via a JDBC Driver
Manage Bitly with visual tools in DBeaver like the query browser.
-
How to Access Pinecone Data Using Entity Framework
This article shows how to access Pinecone using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect the Power BI Service to Amazon DynamoDB: Complete Guide
Connect to the CData Software Power BI Connector for Amazon DynamoDB from PowerBI.com to provide real-time Amazon DynamoDB across the organization.
-
Integrating Antigravity CLI with Mixpanel via CData CLI
Connect Mixpanel to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Tavily Data from a Connection Pool in Jetty
The Tavily JDBC Driver supports connection pooling: This article shows how to connect faster to Tavily from Web apps in Jetty.
-
Explore Geographical Relationships in Greenhouse Data with Power Map
Create data visualizations with Greenhouse in Power Map.
-
Query PolarTeamPro Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PolarTeamPro from Node.js.
-
Connect to Phoenix from Asprova with CData Software ODBC Driver for Phoenix
This article shows how to connect faster to Phoenix data from Asprova.
-
Stream Exa Data into Apache Kafka Topics
Access and stream Exa in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Vertica Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Vertica replication to Azure SQL Database.
-
Integrating Antigravity CLI with Apache HDFS via CData CLI
Connect Apache HDFS to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Dashboards and Visualize Live Email Data in Geckoboard
Use CData Connect AI to connect to live Email and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Sentry Data in RazorSQL
Connect to Sentry from wizards and query Sentry from the GUI in the RazorSQL database management tool.
-
Automated Continuous Sendwithus Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sendwithus replication to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time JotForm Data
Use CData Power BI Connectors to visualize JotForm in Power BI.
-
Visualize Live Raisers Edge NXT Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Raisers Edge NXT into custom reports in Power BI.
-
Integrating OpenCode Terminal with Mailjet 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.
-
Integrating Boomi Agentstudio with SAP SuccessFactors Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP SuccessFactors, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Access Live Zoho Inventory Data in Visual Studio Code via Cline
Run CData MCP Server for Zoho Inventory on Windows Subsytem for Linux (WSL) and connect to live Zoho Inventory from the Cline extension in Visual Studio Code.
-
Visualize Live Oracle SCM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle SCM.
-
Replicate HCL Domino Data from PowerShell
Write a quick PowerShell script to query HCL Domino. Use connectivity to the live data to replicate HCL Domino to SQL Server.
-
Create SSAS Tabular Models from Wave Financial Data
How to build a SQL Server Analysis Service Tabular Model from Wave Financial using CData drivers.
-
Visualize Suadeo Data in TIBCO Spotfire through OData
Integrate Suadeo into dashboards in TIBCO Spotfire.
-
Integrating Facebook Ads Data in Talend Cloud Data Management Platform
Connect Facebook Ads Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Facebook Ads.
-
How to Connect to Live Amazon Athena Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon Athena securely in real time.
-
Access Live Google Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ads from your Excel spreadsheets.
-
Create a Data Access Object for SAP Fieldglass Data using JDBI
A brief overview of creating a SQL Object API for SAP Fieldglass in JDBI.
-
Query Live SAP SuccessFactors Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP SuccessFactors directly from the development environment.
-
Use the CData Software JDBC Driver for Snowflake in MicroStrategy
Connect to Snowflake in MicroStrategy Developer using the CData Software JDBC Driver for Snowflake.
-
How to Connect to RabbitMQ Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to RabbitMQ. Leverage the pyodbc module for ODBC in Python.
-
Build a Simple VCL Application for Greenplum Data
How to build a simple VCL Application to view Pivotal GreenPlum in RAD Studio using the CData ODBC Driver for Greenplum.
-
How to Work with Jumpseller Data in AWS Glue Jobs Using JDBC
Connect to Jumpseller from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Migrating data from Figshare to Snowflake using CData SSIS Components.
Easily push Figshare to Snowflake using the CData SSIS Tasks for Figshare and Snowflake.
-
Getting Started with the CData SSIS Components for FreeAgent
Complete guide to installing, licensing, and connecting with the CData SSIS Components for FreeAgent.
-
Access Live Freshdesk Data in Coginiti Pro
Connect to and query live Freshdesk from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Extract, Transform, and Load Certinia Data in Informatica PowerCenter
Create a simple Workflow for Certinia in Informatica PowerCenter.
-
Integrating Boomi Agentstudio with Google Calendar Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Calendar, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to integrate Oracle with Apache Airflow
Access and process Oracle Database in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Dynamics CRM.
-
Rapidly Develop Redshift-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 Redshift.
-
Use the CData Software JDBC Driver for Scrapfly in MicroStrategy Web
Connect to Scrapfly in MicroStrategy Web using the CData Software JDBC Driver for Scrapfly.
-
Build Dashboards with HCL Domino Data in Dundas BI
Create dynamic dashboards and perform analytics based on HCL Domino in Dundas BI.
-
Create Dynamic Workday Grids Using the Infragistics XamDataGrid
Learn how you can connect Workday to Infragistics XamDataGrid to build dynamic grids.
-
Seamlessly Bring Neo4J Data into Retool Using CData Connect AI
Integrate Neo4J data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use Dash to Build to Web Apps on Snowflake Data
Create Python applications that use pandas and Dash to build Snowflake-connected web apps.
-
How to Connect to Live JSON Services 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 JSON for you.
-
How to work with AlloyDB Data in Apache Spark using SQL
Access and process AlloyDB Data in Apache Spark using the CData Software JDBC Driver.
-
Build Twilio Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Twilio and build visualizations in Tableau.
-
Connect Nethunt Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Nethunt using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Customer.io Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Customer.io in the Denodo Virtual DataPort Administrator.
-
Connect to Suadeo Data in HULFT Integrate
Connect to Suadeo as a JDBC data source in HULFT Integrate
-
How to Connect to Live Couchbase 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 Couchbase without replication.
-
How to connect to Microsoft Exchange Data in DBVisualizer
Integrate Microsoft Exchange with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Tasks in Power Automate Using the CData API Server
Automate Klaviyo actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Freshteam Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Freshteam replication to Google BigQuery.
-
How to publish and share XML Data dashboards with Tableau Server
The CData ODBC driver for XML enables you integrate XML Files into Tableau dashboards.
-
Connect to ChargeOver Data in CloverDX (formerly CloverETL)
Transfer ChargeOver using the visual workflow in the CloverDX data integration tool.
-
View Reports on Real-Time ZohoPeople Data in Power BI Report Server
Use the CData ODBC Driver for ZohoPeople to visualize ZohoPeople in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect and process OpenWeatherMap from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live OpenWeatherMap.
-
Model Acumatica Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Acumatica, enabling the direct import of real-time Acumatica ERP.
-
DataBind Teradata Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Teradata with the DevExpress Windows Forms and Web controls to provide Teradata to a chart.
-
Query Printify Data in ColdFusion
Write standard ColdFusion data access code to connect to Printify.
-
Prepare, Blend, and Analyze Google Campaign Manager 360 Data in Alteryx Designer (ODBC)
Build workflows to access live Google Campaign Manager 360 for self-service data analytics.