CData Software - Knowledge Base
Recent Articles
-
Connect to and Visualize Live Email Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Email data.
-
How to Connect to Google Contacts Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Contacts data. Leverage the pyodbc module for ODBC in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for ZarMoney
Create ZarMoney data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Freshdesk Data as a SQL Server Database in Node.js
Execute SQL Server queries against Freshdesk data from Node.js.
-
Build Oracle Sales-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Sales data and build web apps with connectivity to live Oracle Sales data.
-
Replicate CampaignMonitor Data in Heroku for Use in Salesforce Connect
Replicate CampaignMonitor data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query VWO Data in QlikView over ODBC
Create data visualizations with VWO data in QlikView.
-
Integrating PostgreSQL Data in Talend Cloud Data Management Platform
Connect PostgreSQL Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PostgreSQL.
-
How to import Kintone Data into Apache Solr
Use the CData Software JDBC Driver for Kintone in Data Import Handler and create an automated import of Kintone data to Apache Solr Enterprise Search platform.
-
Trigger SAP SuccessFactors IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP SuccessFactors with standard wizards in Logic Apps.
-
How to Connect the Power BI Service to Microsoft OneDrive: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft OneDrive from PowerBI.com to provide real-time Microsoft OneDrive data across the organization.
-
Integrate with Gumroad Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Gumroad data to a JSON file on disk.
-
A PostgreSQL Interface for Acumatica Data (MySQL Remoting via JDBC)
Use the Remoting features of the Acumatica JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import ServiceDesk Plus Data Using Azure Data Factory
Use CData Connect AI to connect to ServiceDesk Plus Data from Azure Data Factory and import live ServiceDesk Plus data.
-
Connecting Mastra with Highrise Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Highrise data, no replication required.
-
LINQ to Figshare Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Figshare Data Provider.
-
Build Zoho Recruit-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Recruit data.
-
How to connect to DocuSign Data with Squirrel SQL client
Connect to DocuSign data and execute queries in the Squirrel SQL Client.
-
DataBind Charts to Superchat Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Superchat data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Design BIRT Reports on eBay Data
Provide current eBay data to your embedded analytics.
-
Connect to and Visualize Live OpenWeatherMap Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live OpenWeatherMap data.
-
Connect and Visualize Live Shippo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Shippo data into the Databricks platform and create visualization dashboards with real-time Shippo data.
-
Connect to Toggl Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Toggl and the SQL Gateway to access Toggl data from Google Apps Script.
-
Create Jira Assets-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Jira Assets Data from Klipfolio and build custom visualizations using live Jira Assets data.
-
Analyze Live Anaplan Data in SAS Viya
Use CData Connect AI to connect to Anaplan data from SAS Viya and deploy self-service analytics using live Anaplan data.
-
How to load Testmonitor data into Elasticsearch via Logstash
Introducing a simple method to load Testmonitor data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build a PostgreSQL Interface for Insightly Data using the CData JDBC Driver
Use the Remoting features of the Insightly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query, Visualize, and Share live Phoenix Data in Redash
Use CData Connect AI to connect to live Phoenix data in Redash for querying, visualizing, and sharing.
-
Create Data Visualizations in Cognos BI with SharePoint Data
Access SharePoint data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Kintone Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Kintone and the SQL Gateway to access Kintone data from Google Apps Script.
-
Access Live SAP Ariba Source Data in AWS Lambda
Connect to live SAP Ariba Source data in AWS Lambda using the CData JDBC Driver.
-
Connect to Opsgenie Data in RazorSQL
Connect to Opsgenie from wizards and query Opsgenie data from the GUI in the RazorSQL database management tool.
-
Automated Continuous ZohoSubscriptions Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Vertica.
-
Build GetResponse-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to GetResponse Data from Zoho Analytics and import live GetResponse data.
-
Visualize HCL Domino Data in TIBCO Spotfire through ADO.NET
Integrate HCL Domino data into dashboards in TIBCO Spotfire.
-
Integrating Claude Code CLI with Oracle Eloqua 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 Continuous PayPal Replication to Snowflake
Use CData Sync for automated, continuous, customizable PayPal replication to Snowflake.
-
Object-Relational Mapping (ORM) with Clockify Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Clockify data into a Java-based ORM framework, Hibernate.
-
Extract, Transform, and Load Splunk Data in Informatica PowerCenter
Create a simple Workflow for Splunk data in Informatica PowerCenter.
-
Integrate Invoiced Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Invoiced data from Informatica Cloud.
-
DataBind Contentful Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Contentful data to a chart.
-
Build Visualizations of Factorial Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Factorial data in Birst.
-
Publish Crystal Reports on Hive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Hive data.
-
How to publish and share Google Translate Data dashboards with Tableau Server
The CData ODBC driver for Google Translate enables you integrate Google Translate data into Tableau dashboards.
-
How to Connect to Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data for you.
-
Getting Started with the CData Power BI Connector for Asana
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Asana.
-
Use the CData Software ODBC Driver for Wave Financial in SAS for Real-Time Reporting and Analytics
Connect to real-time Wave Financial data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Wave Financial.
-
Use the CData ODBC Driver for Greenplum in Microsoft Power Query
You can use the CData Greenplum ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Greenplum data into Microsoft Power Query.
-
Analyze FTP Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze FTP data in Microsoft R Open.
-
Create iContact-Connected Business Apps in AppSheet
Connect to iContact Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to iContact data.
-
Create PayPal-Connected Nintex Workflows
Use CData Connect AI to connect to PayPal Data from Nintex Workflow Cloud and build custom workflows using live PayPal data.
-
Connecting Agentforce with DocuSign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your DocuSign data for you.
-
Using the CData Software ODBC Driver for Google Forms in PyCharm
Connect to Google Forms as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Forms.
-
Analyze Jodoo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Jodoo from Power Pivot. You will use the Table Import Wizard to load Jodoo data. You can visually build the import query or use any SQL supported by the driver.
-
Build Apps with Live Copper Data Using the Low-Code Development Platform of Mendix
Connect Copper data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Avro with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Avro with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Avro data.
-
Connect to SuiteCRM Data in CloverDX (formerly CloverETL)
Transfer SuiteCRM data using the visual workflow in the CloverDX data integration tool.
-
Analyze HBase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HBase data with the CData JDBC Driver for HBase.
-
Analyze Optimizely Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Optimizely data in Microsoft R Open.
-
Connect to MYOB AccountRight Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MYOB AccountRight Data and connect to MYOB AccountRight data in Akorbi Digital RunMyProcess.
-
Integrating Kiro with Odoo 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.
-
Integrate Jira with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jira with External Services.
-
Connect to Yelp from Asprova with CData Software ODBC Driver for Yelp
This article shows how to connect faster to Yelp data from Asprova.
-
Connect to SingleStore Data from AWS Glue
Use CData Connect AI to gain access to live SingleStore data from your AWS Glue jobs.
-
Automated Continuous API Replication to IBM DB2
Use CData Sync for automated, continuous, customizable API replication to IBM DB2.
-
Integrate XML with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate XML with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to XML data.
-
How to Connect to Live SAP SuccessFactors LMS Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP SuccessFactors LMS data for you.
-
Build Charts with Mailjet Data in Clear Analytics
Create dynamic charts and perform analytics based on Mailjet data in Clear Analytics.
-
Automated Continuous Oracle HCM Cloud Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for Twitter Ads
Create an ODBC connection to Twitter Ads in Informatica and browse and transfer Twitter Ads data.
-
Build Apps with Live Google Campaign Manager 360 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Campaign Manager 360 data into the Adalo platform and build custom mobile and web applications with real-time Google Campaign Manager 360 data.
-
Access SurveyMonkey Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SurveyMonkey data from your Oracle system.
-
Access Procore Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Procore data from your Oracle system.
-
Use Claude to Talk to Your Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Blackbaud FE NXT data for you.
-
Automate Cvent Data Replication to SAP HANA
Use CData Sync to customize and automate Cvent data replication to SAP HANA.
-
DataBind Controls to Paddle Data in Delphi
DataBind to Paddle data in Delphi with standard data access components and controls.
-
Connect to SAP Concur Data in DBeaver
Use the CData ODBC Driver to connect to SAP Concur data in DBeaver.
-
How to connect and process GitLab data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live GitLab data.
-
Rapidly Develop Avalara AvaTax-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 Avalara AvaTax.
-
Build CockroachDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live CockroachDB data and build CockroachDB-connected web apps with Axios.
-
Create Informatica Mappings From/To a JDBC Data Source for Sybase
Create Sybase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData ODBC Driver for Omnisend in Microsoft Power Query
You can use the CData Omnisend ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Omnisend data into Microsoft Power Query.
-
How to Connect to Live Apollo 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 Apollo data through natural language.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Recruit
Provide connectivity to Zoho Recruit data through an SAP BusinessObjects universe.
-
How to work with PayPal Data in Apache Spark using SQL
Access and process PayPal Data in Apache Spark using the CData Software JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Outlook Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Outlook data to SQL Server.
-
Operational Reporting on PolarTeamPro Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PolarTeamPro data.
-
Getting Started with the CData ODBC Driver for Templated
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Templated.
-
Import Google Contacts Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Contacts Data and provide access to live Google Contacts data for custom reports in the Power BI Service.
-
Integrate Live MYOB AccountRight Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MYOB AccountRight from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MYOB AccountRight data.
-
Integrate Google's Antigravity Agent with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Business One data using the Model Context Protocol.
-
Connect to Neo4J from Asprova with CData Software ODBC Driver for Neo4J
This article shows how to connect faster to Neo4J data from Asprova.
-
Create Data Visualizations in Cognos BI with FHIR Data
Access FHIR data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create SAP ByDesign-Connected Dashboards in Grafana
Connect to SAP ByDesign Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP ByDesign data.
-
How to connect and process SurveyMonkey data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SurveyMonkey data.
-
ServiceNow Reporting in OBIEE with the ServiceNow JDBC Driver
Deploy the ServiceNow JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Stack Exchange 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 Stack Exchange data into TIBCO Spotfire.
-
Automate Salesforce Marketing Data Replication to Couchbase
Use CData Sync to Customize and automate Salesforce Marketing data replication to Couchbase.
-
Connect to Mailgun from Asprova with CData Software ODBC Driver for Mailgun
This article shows how to connect faster to Mailgun data from Asprova.
-
Feed Pipedrive Data into FineReport
How to set Pipedrive data as a JDBC data source in FineReport.