CData Software - Knowledge Base
Recent Articles
-
Integrating Kiro with Sybase IQ 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.
-
Connect to and Query SAP HANA Data in QlikView over ODBC
Create data visualizations with SAP HANA data in QlikView.
-
How to import Humanity Data into Apache Solr
Use the CData Software JDBC Driver for Humanity in Data Import Handler and create an automated import of Humanity data to Apache Solr Enterprise Search platform.
-
Connect and Query Live Typeform Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Typeform data into Databricks and enable direct, live querying and analysis without replication.
-
How to Work with Insightly Data in ETL Validator JDBC
Connect to Insightly from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Stripe Replication to SQL Server
Use CData Sync for automated, continuous, customizable Stripe replication to SQL Server.
-
How to Connect DBeaver to PostgreSQL via a JDBC Driver
Manage PostgreSQL data with visual tools in DBeaver like the query browser.
-
Connect to Act-On Data in CloverDX (formerly CloverETL)
Transfer Act-On data using the visual workflow in the CloverDX data integration tool.
-
Visualize Amazon DynamoDB Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon DynamoDB data.
-
Visualize JobNimbus Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to JobNimbus data.
-
Build Dashboards with PDFMonkey Data in Dundas BI
Create dynamic dashboards and perform analytics based on PDFMonkey data in Dundas BI.
-
Analyze Azure Data Lake Storage Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Data Lake Storage data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Toggl Data in AWS Lambda
Connect to live Toggl data in AWS Lambda using the CData JDBC Driver.
-
Integrate Retently with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Retently with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Retently data.
-
Create Oracle HCM Cloud Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle HCM Cloud from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Opsgenie 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 Opsgenie data into TIBCO Spotfire.
-
Automated Continuous Facebook Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Facebook Ads replication to SQL Server.
-
Visualize Live ZohoSubscriptions Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoSubscriptions data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Operational Reporting on SAP Business Warehouse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business Warehouse data.
-
Feed SingleStore Data into FineReport
How to set SingleStore data as a JDBC data source in FineReport.
-
Query Live Snapchat Ads 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 Snapchat Ads data directly from the development environment.
-
Build Dashboards with Sage Intacct Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage Intacct data in Dundas BI.
-
Connect to Act-On Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Act-On and the SQL Gateway to access Act-On data from Google Apps Script.
-
Visualize Live Microsoft Planner Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Planner data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to CSV Data from IntelliJ
Integrate connectivity to CSV data with wizards in IntelliJ.
-
How to create an RPA flow for SAP ByDesign Data in UiPath Studio
Use the SAP ByDesign ODBC Driver to create workflows that access real-time SAP ByDesign data without any coding.
-
Automated Continuous PolarTeamPro Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Apache Kafka.
-
How to Seamlessly Import Oracle Financials Cloud Data into IBM SPSS Modeler
Integrate Oracle Financials Cloud data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Mistral AI Data as a MySQL Database in Node.js
Execute MySQL queries against Mistral AI data from Node.js.
-
Trigger QuickBooks IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for QuickBooks with standard wizards in Logic Apps.
-
How to Seamlessly Import Mocean Data into IBM SPSS Modeler
Integrate Mocean data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData ODBC Driver for Wrike from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Wrike to connect to Wrike data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Wrike data in Excel.
-
Connect to CloudConvert Data in CloverDX (formerly CloverETL)
Transfer CloudConvert data using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Slack to Databricks using CData SSIS Components.
Easily push Slack data to Databricks using the CData SSIS Tasks for Slack and Databricks.
-
Connect to Yelp Data in JRuby
Create a simple JRuby app with access to live Yelp data.
-
DataBind Controls to Superchat Data in Delphi
DataBind to Superchat data in Delphi with standard data access components and controls.
-
Use ChatGPT to Talk to Your OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your OneNote data for you.
-
Access Live JDBC-ODBC Bridge Data in AWS Lambda
Connect to live JDBC-ODBC Bridge data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Phoenix Replication to SQL Server
Use CData Sync for automated, continuous, customizable Phoenix replication to SQL Server.
-
Build Data Flows from SQL Server to Snapchat Ads through SSIS
Easily push SQL Server data to Snapchat Ads using the CData SSIS Tasks for Snapchat Ads.
-
Model, Search, and Visualize Live API Data in ThoughtSpot
Use CData Connect AI to connect to live API data for modeling, searching, and visualizing.
-
Getting Started with the CData ODBC Driver for Insightly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Insightly.
-
Access Live LinkedIn Ads Data in TIBCO Data Virtualization
Use the LinkedIn Ads Tibco DV Adapter to create a LinkedIn Ads data data source in TIBCO Data Virtualization Studio and gain access to live LinkedIn Ads data from your TDV Server.
-
Query, Visualize, and Share live Cassandra Data in Redash
Use CData Connect AI to connect to live Cassandra data in Redash for querying, visualizing, and sharing.
-
Integrate Google's Antigravity Agent with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Ads data using the Model Context Protocol.
-
Create HubDB-Connected Business Apps in AppSheet
Connect to HubDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to HubDB data.
-
Choosing the Best Method to Connect Microsoft Entra ID to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Entra ID data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Migrating data from MailerSend to Google BigQuery using CData SSIS Components.
Easily push MailerSend data to Google BigQuery using the CData SSIS Tasks for MailerSend and Google BigQuery.
-
How to connect to Mocean Data from Spring Boot
Connect to Mocean in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating Cursor with ShipEngine 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.
-
Access Live Stripe Data in Coginiti Pro
Connect to and query live Stripe data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to create Visio diagrams from SAP Netweaver Gateway Data
Automatically update SAP Netweaver Gateway data with the changes you make to Visio master shapes.
-
Import Real-Time Testmonitor Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Testmonitor data in ColdFusion.
-
How to Connect to Live Microsoft Dataverse 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 Microsoft Dataverse data for you.
-
Use the CData Software JDBC Driver for Mouseflow in MicroStrategy Web
Connect to Mouseflow data in MicroStrategy Web using the CData Software JDBC Driver for Mouseflow.
-
Integrating Codex with Dynamics NAV 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.
-
Connect to Dynamics 365 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 to connect to Dynamics 365 data and execute queries in PowerBuilder.
-
Query ZohoMarketingHub Data in DataGrip
Create a Data Source for ZohoMarketingHub in DataGrip and use SQL to query live ZohoMarketingHub data.
-
How to Seamlessly Import Webflow Data into IBM SPSS Modeler
Integrate Webflow data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Impala-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Impala data and build web apps with connectivity to live Impala data.
-
Connect to FHIR Data in CloverDX (formerly CloverETL)
Transfer FHIR data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Pipeliner CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to SQLite.
-
Connect to Aha! Data in JRuby
Create a simple JRuby app with access to live Aha! data.
-
Manage PagerDuty Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PagerDuty.
-
Query Humanity Data in ColdFusion
Write standard ColdFusion data access code to connect to Humanity data.
-
Integrate Nethunt with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Nethunt with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Nethunt data.
-
Access Stack Exchange Data from MySQL in PHP
Connect to Stack Exchange through the standard MySQL libraries in PHP.
-
Connect to BigCommerce Data in Ruby
Connect to BigCommerce data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Automated LDAP-Connected Workflows in Zapier
Use CData Connect AI to connect to live LDAP objects and build automated workflows in Zapier.
-
Automated Continuous Invoiced Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Invoiced replication to AlloyDB.
-
Visualize Microsoft Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Ads data.
-
How to Connect to & Open Float Data in Microsoft Excel
This article uses the CData ODBC driver for Float to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Link Pinecone with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pinecone data in Filemaker Pro for Mac or Windows.
-
How to import Pingdom Data into Apache Solr
Use the CData Software JDBC Driver for Pingdom in Data Import Handler and create an automated import of Pingdom data to Apache Solr Enterprise Search platform.
-
Integrating GitHub Copilot with Rebilly 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 Informatica Mappings From/To a JDBC Data Source for PabblySubscriptions
Create PabblySubscriptions data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous CouchDB Replication to Oracle
Use CData Sync for automated, continuous, customizable CouchDB replication to Oracle.
-
Access Placid Data from MySQL in PHP
Connect to Placid through the standard MySQL libraries in PHP.
-
Connect to and Query Amazon DynamoDB Data in QlikView over ODBC
Create data visualizations with Amazon DynamoDB data in QlikView.
-
Automate Zoho Recruit Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Recruit data replication to Azure Data Lake.
-
Getting Started with the CData Tableau Connector for FHIR
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for FHIR.
-
Connect to Demio Data in HULFT Integrate
Connect to Demio as a JDBC data source in HULFT Integrate
-
Create Power BI Reports on Real-Time Google Drive Data
Use the CData ODBC Driver for Google Drive to visualize Google Drive data in Power BI Desktop.
-
Integrate Dify with Live Zoho Books Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Zoho Books data.
-
Build Avalara AvaTax-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Avalara AvaTax data.
-
Access Dotmailer Data from MySQL in Amazon QuickSight
Connect to Dotmailer and build visualizations of Dotmailer data using a MySQL Connection in Amazon QuickSight.
-
Integrate Real-Time Access to Acumatica in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Acumatica data in real time.
-
Automated Continuous ZendeskSell Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Apache Cassandra.
-
Automated Continuous Azure Data Catalog Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Apache Kafka.
-
Explore Geographical Relationships in SageHR Data with Power Map
Create data visualizations with SageHR data in Power Map.
-
Connect to Live SAP Ariba Source Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Ariba Source Data in CData Connect AI and connect to your SAP Ariba Source data from MicroStrategy.
-
Query Suadeo Data as a MySQL Database in Node.js
Execute MySQL queries against Suadeo data from Node.js.
-
How to Connect to Live MailerLite 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 MailerLite data for you.
-
Access PingOne 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 PingOne data.
-
Use the CData Software JDBC Driver for Telegram in MicroStrategy Web
Connect to Telegram data in MicroStrategy Web using the CData Software JDBC Driver for Telegram.
-
Use Biml to Build SSIS Tasks to Replicate Aha! Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Aha! data to SQL Server.
-
Build Apps with Live Excel Online Data Using the Low-Code Development Platform of Mendix
Connect Excel Online data with Mendix to build apps using the CData JDBC Driver for Excel Online.
-
Getting Started with the CData Power BI Connector for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating Claude Code CLI with Amazon DynamoDB 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 Azure Data Lake Storage Data Replication to Teradata
Use CData Sync to Customize and automate Azure Data Lake Storage data replication to Teradata.