CData Software - Knowledge Base
Recent Articles
-
Automate Jumpseller Data Replication to SAP HANA
Use CData Sync to customize and automate Jumpseller replication to SAP HANA.
-
Integrating Kiro CLI 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 in QlikView.
-
Import Google Spanner Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Spanner. In this article, you will use the OData format to import Google Spanner into Microsoft Power Query.
-
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 to Apache Solr Enterprise Search platform.
-
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 with visual tools in DBeaver like the query browser.
-
Connect to Act-On Data in CloverDX (formerly CloverETL)
Transfer Act-On 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.
-
Visualize JobNimbus Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to JobNimbus.
-
Build Dashboards with PDFMonkey Data in Dundas BI
Create dynamic dashboards and perform analytics based on PDFMonkey 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 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Toggl Data in AWS Lambda
Connect to live Toggl 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.
-
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 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 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.
-
Feed SingleStore Data into FineReport
How to set SingleStore 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 directly from the development environment.
-
Build Dashboards with Sage Intacct Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage Intacct 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 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 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/TSV Files 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 Business ByDesign 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 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Wrike in Excel.
-
Connect to CloudConvert Data in CloverDX (formerly CloverETL)
Transfer CloudConvert using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Slack to Databricks using CData SSIS Components.
Easily push Slack 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.
-
DataBind Controls to Superchat Data in Delphi
DataBind to Superchat 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 Microsoft OneNote for you.
-
Access Live JDBC-ODBC Bridge Data in AWS Lambda
Connect to live JDBC-ODBC Bridge 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 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 source in TIBCO Data Virtualization Studio and gain access to live LinkedIn Ads from your TDV Server.
-
Query, Visualize, and Share live Cassandra Data in Redash
Use CData Connect AI to connect to live Apache Cassandra in Redash for querying, visualizing, and sharing.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Ads using the Model Context Protocol.
-
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 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 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 CLI 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 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 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 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 (CDS) for you.
-
Use the CData Software JDBC Driver for Mouseflow in MicroStrategy Web
Connect to Mouseflow in MicroStrategy Web using the CData Software JDBC Driver for Mouseflow.
-
Integrating Codex CLI with Microsoft Dynamics NAV 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 Microsoft Dynamics 365 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.
-
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 Apache Impala and build web apps with connectivity to live Apache Impala.
-
Connect to FHIR Data in CloverDX (formerly CloverETL)
Transfer FHIR 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!.
-
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.
-
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.
-
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 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
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.
-
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.
-
Bidirectional Access to Pinecone Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pinecone 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 to Apache Solr Enterprise Search platform.
-
Integrating GitHub Copilot CLI with Rebilly 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 in QlikView.
-
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 in Power BI Desktop.
-
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.
-
Access Dotmailer Data from MySQL in Amazon QuickSight
Connect to Dotmailer and build visualizations of Dotmailer 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 ERP 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 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 from MicroStrategy.
-
Query Suadeo Data as a MySQL Database in Node.js
Execute MySQL queries against Suadeo from Node.js.
-
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.
-
Use the CData Software JDBC Driver for Telegram in MicroStrategy Web
Connect to Telegram 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! to SQL Server.
-
Build Apps with Live Excel Online Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Excel Online 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 replication to Teradata.
-
Create Apps from Cassandra Data in Qlik Sense Cloud
Use CData Connect AI to connect to Cassandra Data and build apps from live Apache Cassandra in Qlik Sense Cloud.
-
Easily Integrate Drift Data in Lazarus Pascal IDE
Learn how to easily integrate live Drift in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software ODBC Driver for eBay Analytics in SAS for Real-Time Reporting and Analytics
Connect to real-time eBay Analytics in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for eBay Analytics.
-
Create Reports with Paymo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paymo.