CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Parallel Data in Informatica PowerCenter
Create a simple Workflow for Parallel data in Informatica PowerCenter.
-
How to work with Billsby Data in Apache Spark using SQL
Access and process Billsby Data in Apache Spark using the CData Software JDBC Driver.
-
Build Pipelines with Live Teradata Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Teradata from Google Cloud Data Fusion, enabling the integration of live Teradata data into the building and management of effective data pipelines.
-
Create Foursquare Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Foursquare data access from reports, embedded analytics, and more.
-
How to connect to SAP Hybris C4C Data from Spring Boot
Connect to SAP Hybris C4C in a Spring Boot Application using the CData JDBC Driver for SAP Hybris C4C
-
Integrate Live Workday Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Workday data from within the IDE.
-
Integrate Excel Data in Pentaho Data Integration
Build ETL pipelines based on Excel data in the Pentaho Data Integration tool.
-
Integrate Guru Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Guru data from Informatica Cloud.
-
Build AI Agents with Adobe Target Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Adobe Target data through CData Connect AI.
-
Getting Started with the CData ADO.NET Provider for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft Ads.
-
DataBind Controls to Jodoo Data in C++Builder
DataBind to Jodoo data in C++Builder with standard components and controls.
-
How to Build an ETL App for Mailgun Data in Python with CData Connect AI
Extract and transform live Mailgun data in Python with petl and the CData Connect AI Python SDK.
-
Connect to and Visualize Live Oracle Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle data.
-
View Reports on Real-Time ServiceDesk Plus Data in Power BI Report Server
Use the CData ODBC Driver for ServiceDesk Plus to visualize ServiceDesk Plus data in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Amazon Athena Data from PowerShell
Write a quick PowerShell script to query Amazon Athena data. Use connectivity to the live data to replicate Amazon Athena data to SQL Server.
-
Replicate SuiteCRM Data from PowerShell
Write a quick PowerShell script to query SuiteCRM data. Use connectivity to the live data to replicate SuiteCRM data to SQL Server.
-
Connect to Mistral AI Data in NetBeans
Connect to Mistral AI data in NetBeans with the data source configuration wizard.
-
Visualize Live SAP ByDesign Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP ByDesign data.
-
Extract, Transform, and Load SharePoint Data in Informatica PowerCenter
Create a simple Workflow for SharePoint data in Informatica PowerCenter.
-
Integrating Gumloop with Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Epicor Kinetic data within automated workflows.
-
Connect to HDFS Data in Claris FileMaker Pro
Use the CData ODBC Driver for HDFS in FileMaker Pro to connect to HDFS and work with HDFS data in your FileMaker applications.
-
Use the CData Software JDBC Driver for Avaza in MicroStrategy
Connect to Avaza data in MicroStrategy Developer using the CData Software JDBC Driver for Avaza.
-
Query, Visualize, and Share live PolarTeamPro Data in Redash
Use CData Connect AI to connect to live PolarTeamPro data in Redash for querying, visualizing, and sharing.
-
Create Informatica Mappings From/To an ODBC Data Source for Cloudant
Create an ODBC connection to Cloudant in Informatica and browse and transfer Cloudant data.
-
Replicate Invoiced Data in Heroku for Use in Salesforce Connect
Replicate Invoiced data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a Simple VCL Application for Datadog Data
How to build a simple VCL Application to view Datadog data in RAD Studio using the CData ODBC Driver for Datadog.
-
Integrate Google's Vertex AI Agent with Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Discord data within intelligent workflows.
-
Integrate with Sage 300 Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage 300 data in SnapLogic.
-
Build Microsoft Dataverse-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Dataverse data and build Microsoft Dataverse-connected web apps with Axios.
-
DataBind Charts to Scrapfly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Scrapfly 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.
-
Getting Started with the CData SSIS Components for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho CRM.
-
How to Connect the Power BI Service to Elorus: Complete Guide
Connect to the CData Software Power BI Connector for Elorus from PowerBI.com to provide real-time Elorus data across the organization.
-
How to Work with Foursquare Data in ETL Validator JDBC
Connect to Foursquare from ETL Validator jobs using the CData Software JDBC Driver.
-
Establish a Live Connection with PabblySubscriptions Data using Tableau Bridge
The CData ODBC Driver for PabblySubscriptions enables you to integrate live PabblySubscriptions data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create SparkPost-Connected Applications in Appsmith
Connect to SparkPost Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SparkPost data.
-
Build Sage Intacct Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sage Intacct data and build visualizations in Tableau.
-
Automated Continuous Helpscout Replication to Databricks
Use CData Sync for automated, continuous, customizable Helpscout replication to Databricks.
-
Trigger Microsoft Exchange IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Exchange with standard wizards in Logic Apps.
-
Prepare, Blend, and Analyze Sendwithus Data in Alteryx Designer (Connect AI)
Build workflows to access live Sendwithus data for self-service data analytics.
-
Using the CData JDBC drivers with the Pentaho Report Designer
The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce in Pentaho (a BI tool) to publish reports based on Salesforce data. A similar approach can be used with any other CData JDBC Driver.
-
Model Salesforce Marketing Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce Marketing, enabling the direct import of real-time Salesforce Marketing data.
-
Import and Visualize PingOne Data in Power View
Create data visualizations based on PingOne data in Excel.
-
Integrate Google Translate Data in the Pentaho Report Designer
Publish reports based on Google Translate data in the Pentaho BI tool.
-
Create Reports with Beeminder Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Beeminder data.
-
Moving Data from ConvertAPI to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ConvertAPI data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect to Klaviyo Data from IntelliJ
Integrate connectivity to Klaviyo data with wizards in IntelliJ.
-
Access TaxJar 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 TaxJar data.
-
Build MVC Applications with Connectivity to Jumpseller Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jumpseller from an ASP.NET MVC application.
-
Manage Webflow Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Webflow.
-
Getting Started with the CData Tableau Connector for Auth0
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect DBeaver to Azure Table via a JDBC Driver
Manage Azure Table data with visual tools in DBeaver like the query browser.
-
Access Live Oracle SCM Data in TIBCO Data Virtualization
Use the Oracle SCM Tibco DV Adapter to create a Oracle SCM data data source in TIBCO Data Virtualization Studio and gain access to live Oracle SCM data from your TDV Server.
-
Build an OLAP Cube in SSAS from Paymo Data
Establish a connection to Paymo data data from SQL Server Analysis Services, and use the Paymo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Translate
Provide connectivity to Google Translate data through an SAP BusinessObjects universe.
-
Getting Started with the CData JDBC Driver for MySQL
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MySQL.
-
Provide OData Services of Oracle HCM Cloud Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle HCM Cloud data by developing a WCF Service Application.
-
How to Query Campaigner Data in MySQL Workbench
Execute MySQL queries against live Campaigner data from MySQL Workbench.
-
Connect and Visualize Live SAS Data Sets Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAS Data Sets data into the Databricks platform and create visualization dashboards with real-time SAS Data Sets data.
-
How to Connect ZohoExpense 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 ZohoExpense data in real time using natural language.
-
Integrating OpenCode with ADP 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.
-
Use the CData ODBC Driver for Trello from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Trello to connect to Trello data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Trello data in Excel.
-
Connect to Paddle Data in Ruby
Connect to Paddle data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData ADO.NET Provider for Shortcut
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Prepare, Blend, and Analyze Instantly Data in Alteryx Designer (ODBC)
Build workflows to access live Instantly data for self-service data analytics.
-
Automated Continuous Shopify Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Shopify replication to Azure SQL Database.
-
How to Connect to Live Reckon Accounts Hosted Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Reckon Accounts Hosted data for you.
-
Connecting Moonlit Workflow with SAP Ariba Procurement Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Ariba Procurement data in real time.
-
How to Work with Calendly Data in AWS Glue Jobs Using JDBC
Connect to Calendly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect Flowise AI Agents to Live Timely 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 Timely data without replication.
-
Write a Simple Go Application to work with Google Campaign Manager 360 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Campaign Manager 360 data.
-
Import and Visualize Aircall Data in Power View
Create data visualizations based on Aircall data in Excel.
-
Explore Geographical Relationships in ZeroBounce Data with Power Map
Create data visualizations with ZeroBounce data in Power Map.
-
Automated Continuous Salesloft Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesloft replication to Amazon S3.
-
Integrate OpenCode with Live Procore Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Procore data from within your AI coding agent.
-
Build a PostgreSQL Interface for ServiceDesk Plus Data using the CData JDBC Driver
Use the Remoting features of the ServiceDesk Plus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Square to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Square with IBM WebSphere for seamless data integration and connectivity.
-
Work with Twilio Data in FoxPro
Load Twilio data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Splunk-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Splunk data without replication.
-
Query Brex Data in DataGrip
Create a Data Source for Brex in DataGrip and use SQL to query live Brex data.
-
Build Discord-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Discord Data and create custom apps in Bubble.
-
Object-Relational Mapping (ORM) with Microsoft Ads 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 Microsoft Ads data into a Java-based ORM framework, Hibernate.
-
Integrating Email Data in Talend Cloud Data Management Platform
Connect Email Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Email.
-
Connect to Datadog Data in RapidMiner
Integrate Datadog data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Power BI Connector for Vault CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Vault CRM.
-
Use the CData ODBC Driver for Cassandra from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cassandra to connect to Cassandra data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Cassandra data in Excel.
-
How to Easily Query HDFS Data in OpenOffice Base
Connect to HDFS data in OpenOffice Base using the CData ODBC Driver for HDFS and generate reports with live data insights.
-
Build a Singer.io Tap for Freshteam With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Freshteam data using the CData Python Connector.
-
Feed Deel Data into FineReport
How to set Deel data as a JDBC data source in FineReport.
-
Access Live Outreach.io Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Outreach.io data from your Excel spreadsheets.
-
Integrate CouchDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CouchDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CouchDB data.
-
Visualize CockroachDB 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 CockroachDB data into TIBCO Spotfire.
-
Access Live Dynamics 365 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dynamics 365 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Design BIRT Reports on SuiteCRM Data
Provide current SuiteCRM data to your embedded analytics.
-
How to load Sendwithus data into Elasticsearch via Logstash
Introducing a simple method to load Sendwithus data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Stripe-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Stripe Data and create custom apps in Bubble.
-
Migrating data from CapsuleCRM to Snowflake using CData SSIS Components.
Easily push CapsuleCRM data to Snowflake using the CData SSIS Tasks for CapsuleCRM and Snowflake.
-
Manage Campaigner Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Campaigner.
-
How to Work with TigerGraph Data in ETL Validator JDBC
Connect to TigerGraph from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Automated Workflows with Live Shortcut Data in Workato
Use CData Connect AI to connect to live Shortcut data and build automated workflows in Workato.
-
Configure the CData JDBC Driver for Cosmos DB in a Connection Pool in Tomcat
Connect to Cosmos DB data from a connection pool in Tomcat.