CData Software - Knowledge Base
Recent Articles
-
Create Reports with Stripe Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stripe.
-
How to Create Power BI Visual Reports with Real-Time MarkLogic Data
Use CData Power BI Connectors to visualize MarkLogic in Power BI.
-
Integrate HDFS with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate HDFS with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache HDFS.
-
Access Google Ad Manager Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Ad Manager from HeidiSQL.
-
Explore Geographical Relationships in Google Campaign Manager 360 Data with Power Map
Create data visualizations with Google Campaign Manager 360 in Power Map.
-
Publish Google Campaign Manager 360-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Campaign Manager 360.
-
Build AI/ML Models with Live Retently Data using Dataiku
Connect Retently Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect Flowise AI Agents to Live Slack Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Slack without replication.
-
Publish Reports with Zuora Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zuora.
-
Use Dash to Build to Web Apps on Elasticsearch Data
Create Python applications that use pandas and Dash to build Elasticsearch-connected web apps.
-
Connect to DB2 Data in DBeaver
Use the CData ODBC Driver to connect to IBM DB2 in DBeaver.
-
Integrate Instagram Data in the Pentaho Report Designer
Publish reports based on Instagram in the Pentaho BI tool.
-
Use JayDeBeApi to access GitLab Data in Python
Use standard Python scripting and the development environment of your choice to access live GitLab.
-
Manage Front Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Front.
-
Migrating data from Paddle to Google BigQuery using CData SSIS Components.
Easily push Paddle to Google BigQuery using the CData SSIS Tasks for Paddle and Google BigQuery.
-
Edit and Search External Square Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Square to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Square Data objects that you can access from apps and the dashboard.
-
Consume Zoho Creator OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zoho Creator feeds that reflect any changes in SAP Lumira.
-
Analyze Quickbase Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Quickbase and visualize live Quickbase in Infragistics Reveal.
-
Build Snowflake Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Snowflake and build visualizations in Tableau.
-
Clari Reporting in OBIEE with the Clari JDBC Driver
Deploy the Clari JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Using DirectQuery in Power BI with CData Power BI Connectors
CData Power BI Connectors support the DirectQuery connection mode in Power BI, allowing users to query large datasets in real-time without having to import the data locally.
-
Create Informatica Mappings From/To an ODBC Data Source for Figshare
Create an ODBC connection to Figshare in Informatica and browse and transfer Figshare.
-
Build Automated WooCommerce-Connected Workflows in Zapier
Use CData Connect AI to connect to live WooCommerce and build automated workflows in Zapier.
-
Publish Reports with Google Search Results in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Search.
-
DataBind ZendeskSell Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZendeskSell to a chart.
-
Prepare, Blend, and Analyze Odoo Data in Alteryx Designer (ODBC)
Build workflows to access live Odoo ERP for self-service data analytics.
-
Create Google Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Ads Data from Klipfolio and build custom visualizations using live Google Ads.
-
Build Apollo-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apollo.
-
How to Create Power BI Visual Reports with Real-Time Couchbase Data
Use CData Power BI Connectors to visualize Couchbase in Power BI.
-
Integrate with Blackbaud FE NXT Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Blackbaud FE NXT to a JSON file on disk.
-
Access Live Opsgenie Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Opsgenie into the statistical analysis tools available in SAS JMP. This article shows how to use Opsgenie in the Graph Builder and Query Builder.
-
How to Connect Sybase Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sybase data in real time using natural language.
-
How to Build an ETL App for Snapchat Ads Data in Python with CData Connect AI
Build ETL pipelines that read and write live Snapchat Ads in Python with petl and the CData Connect AI Python SDK.
-
Create Monday.com-Connected Dashboards in Grafana
Connect to Monday.com Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Monday.com.
-
Create Data Visualizations in Cognos BI with Airtable Data
Access Airtable as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Provide OData Services of Jodoo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Jodoo by developing a WCF Service Application.
-
Create Placid Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Placid data access from reports, embedded analytics, and more.
-
Access Live LDAP Objects in AWS Lambda (with IntelliJ IDEA)
Connect to live LDAP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Prepare, Blend, and Analyze Everhour Data in Alteryx Designer (ODBC)
Build workflows to access live Everhour for self-service data analytics.
-
Analyze AgileCRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze AgileCRM in Microsoft R Open.
-
Getting Started with the CData ADO.NET Provider for HelloSign
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Choosing the Best Method to Connect Clio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Clio from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Vimeo from Asprova with CData Software ODBC Driver for Vimeo
This article shows how to connect faster to Vimeo data from Asprova.
-
DataBind Epicor Kinetic Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Epicor Kinetic with the DevExpress Windows Forms and Web controls to provide Epicor Kinetic to a chart.
-
Build Visualizations of Front Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Front in Birst.
-
Configure the CData JDBC Driver for PolarTeamPro in a Connection Pool in Tomcat
Connect to PolarTeamPro from a connection pool in Tomcat.
-
Use the CData ODBC Driver for GitLab from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for GitLab to connect to GitLab from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring GitLab in Excel.
-
Access Live GraphQL 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 GraphQL through MCP integration.
-
Automated NetSuite Data Replication to Teradata
Use CData Sync to Customize and automate NetSuite CRM & ERP replication to Teradata.
-
Connect to Todoist Data from PowerBuilder via JDBC
This article demonstrates how to access Todoist from PowerBuilder using the Todoist JDBC Driver.
-
Extract, Transform, and Load Highrise Data in Informatica PowerCenter
Create a simple Workflow for Highrise CRM in Informatica PowerCenter.
-
Create Apps from Microsoft Teams Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Teams Data and build apps from live Microsoft Teams in Qlik Sense Cloud.
-
Create Power BI Reports on Real-Time Mode Data
Use the CData ODBC Driver for Mode to visualize Mode in Power BI Desktop.
-
Visualize Calendly 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 Calendly into TIBCO Spotfire.
-
ETL BigCommerce in Oracle Data Integrator
This article shows how to transfer BigCommerce into a data warehouse using Oracle Data Integrator.
-
Analyze ServiceNow Data in Looker
Use CData Connect AI to connect to ServiceNow Data from Looker and build custom apps using live ServiceNow.
-
How to Query Oracle Sales Data in MySQL Workbench
Execute MySQL queries against live Oracle Sales from MySQL Workbench.
-
Analyze Microsoft OneDrive Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft OneDrive in Microsoft R Open.
-
Replicate SendPulse Data to Multiple Databases
Replicate SendPulse to disparate databases with a point-and-click configuration.
-
Access Quickbase Data from MySQL in Amazon QuickSight
Connect to Quickbase and build visualizations of Quickbase using a MySQL Connection in Amazon QuickSight.
-
Import and Visualize Salesforce Data 360 Data in Power View
Create data visualizations based on Salesforce Data 360 in Excel.
-
Import ADP Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ADP. In this article, you will use the OData format to import ADP into Microsoft Power Query.
-
How to use SQLAlchemy ORM to access Adobe Commerce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Adobe Commerce.
-
Create SSAS Tabular Models from Kintone Data
How to build a SQL Server Analysis Service Tabular Model from Kintone using CData drivers.
-
How to import Yelp Data into Apache Solr
Use the CData Software JDBC Driver for Yelp in Data Import Handler and create an automated import of Yelp to Apache Solr Enterprise Search platform.
-
Write a Simple Go Application to work with Suadeo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Suadeo.
-
Stream Teamgate Data into Apache Kafka Topics
Access and stream Teamgate in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Supabase Data with Squirrel SQL client
Connect to Supabase and execute queries in the Squirrel SQL Client.
-
Model, Search, and Visualize Live Redshift Data in ThoughtSpot
Use CData Connect AI to connect to live Amazon Redshift for modeling, searching, and visualizing.
-
Integrating GitHub Copilot CLI with Lakebase 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 Box Data Replication to Couchbase
Use CData Sync to Customize and automate Box replication to Couchbase.
-
Build a PostgreSQL Interface for LinkedIn Ads Data using the CData JDBC Driver
Use the Remoting features of the LinkedIn Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with LinkedIn Data in JReport Designer
Create charts and reports based on LinkedIn in JReport Designer.
-
Visualize Live Cassandra Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache Cassandra using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with Cvent Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Cvent to a JSON file on disk.
-
Seamlessly Bring Google Analytics Data into Retool Using CData Connect AI
Integrate Google Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Splunk Data as a SQL Server Database in Node.js
Execute SQL Server queries against Splunk from Node.js.
-
Access Live Redis 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 Redis through MCP integration.
-
How to Seamlessly Import SAP Ariba Procurement Data into IBM SPSS Modeler
Integrate SAP Ariba Procurement data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for Avro in MicroStrategy Web
Connect to Apache Avro in MicroStrategy Web using the CData Software ODBC Driver for Avro.
-
Build Agents in Relevance AI with Access to Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Database within intelligent agent workflows.
-
Migrating data from AdRoll to Snowflake using CData SSIS Components.
Easily push AdRoll to Snowflake using the CData SSIS Tasks for AdRoll and Snowflake.
-
Azure Table Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure Table Storage through CData Connect AI using different applications and tools.
-
Working with ClickTime Data in LINQPad
Execute LINQ queries to ClickTime in LINQPad.
-
Connect to EmailOctopus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to EmailOctopus and work with EmailOctopus in your FileMaker applications.
-
How to create an RPA flow for Onfleet Data in UiPath Studio
Use the Onfleet ODBC Driver to create workflows that access real-time Onfleet without any coding.
-
Connect to JSON Services from a Connection Pool in Jetty
The JSON JDBC Driver supports connection pooling: This article shows how to connect faster to JSON from Web apps in Jetty.
-
Integrating Workable Data in Talend Cloud Data Management Platform
Connect Workable Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Bridge Zuora Connectivity with Apache NiFi
Access and process Zuora in Apache NiFi using the CData JDBC Driver.
-
A PostgreSQL Interface for Excel Online Data using the CData ODBC Driver
Use the SQL Gateway and Excel Online ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for Amazon Athena Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Amazon Athena.
-
A PostgreSQL Interface for SAP Hybris C4C Data using the CData ODBC Driver
Use the SQL Gateway and SAP Hybris C4C ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Databricks Data in HULFT Integrate
Connect to Databricks as a JDBC data source in HULFT Integrate
-
Connect to Vault CRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Vault CRM Data and connect to Veeva Vault & Vault CRM in Akorbi Digital RunMyProcess.
-
Update Your Smartsheet Connections Before June 3rd, 2026
Smartsheet is retiring legacy API endpoints on June 3rd, 2026. Update your CData Smartsheet driver and set UseLegacyAPI=False to avoid service disruption.
-
Automated Continuous Google Calendar Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Calendar replication to IBM DB2.
-
Connecting Pipedream with Dropbox 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 Dropbox data in real time.
-
Explore Geographical Relationships in ServiceDesk Plus Data with Power Map
Create data visualizations with ServiceDesk Plus in Power Map.
-
Rapidly Develop CouchDB-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 CouchDB.
-
Connect to Freshdesk Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital