CData Software - Knowledge Base
Recent Articles
-
How to create an RPA flow for SendPulse Data in UiPath Studio
Use the SendPulse ODBC Driver to create workflows that access real-time SendPulse data without any coding.
-
Create Google Campaign Manager 360 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Campaign Manager 360 data access from reports, embedded analytics, and more.
-
Connect to Greenplum Data from a Connection Pool in Jetty
The Greenplum JDBC Driver supports connection pooling: This article shows how to connect faster to Greenplum data from Web apps in Jetty.
-
Use the CData ODBC Driver for SAP SuccessFactors from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP SuccessFactors to connect to SAP SuccessFactors data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP SuccessFactors data in Excel.
-
Connecting GenSpark with Freshservice Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Freshservice data without any replication or custom integration required.
-
Connect to Live SAP Fieldglass Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Fieldglass in CData Connect AI and connect to your SAP Fieldglass data from PostgreSQL.
-
How to work with Shippo Data in Apache Spark using SQL
Access and process Shippo Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Apify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Apify replication to SingleStore.
-
Create Superchat Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Superchat from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous AgileCRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable AgileCRM replication to Apache Cassandra.
-
How to Create Power BI Visual Reports with Real-Time Azure Data Catalog Data
Use CData Power BI Connectors to visualize Azure Data Catalog data in Power BI.
-
Getting Started with the CData SSIS Components for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure DevOps.
-
Use the CData Software ODBC Driver for Email in MicroStrategy Web
Connect to Email data in MicroStrategy Web using the CData Software ODBC Driver for Email.
-
Visualize Dynamics 365 Business Central Data in Sisense
Create an ElastiCube in Sisense app with access to Dynamics 365 Business Central data.
-
Connect to iContact Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to iContact.
-
Build Agents in Relevance AI with Access to Live AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on AfterShip data within intelligent agent workflows.
-
Visualize Teamgate Data in Sisense
Create an ElastiCube in Sisense app with access to Teamgate data.
-
Automated Continuous Confluence Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Confluence replication to Apache Cassandra.
-
Connecting GenSpark with Sugar CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sugar CRM data without any replication or custom integration required.
-
How to Build an ETL App for Salesforce Marketing Data in Python with CData Connect AI
Build ETL pipelines that read and write live Salesforce Marketing data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous GraphQL Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable GraphQL replication to delimited files (CSV/TSV).
-
Extract, Transform, and Load Figshare Data in Informatica PowerCenter
Create a simple Workflow for Figshare data in Informatica PowerCenter.
-
Integrating Claude Code with Shopify Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Shopify data within assisted coding and automated development workflows.
-
How to use SQLAlchemy ORM to access SAP Hybris C4C Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Hybris C4C data.
-
Connect to Spotify Data in Ruby
Connect to Spotify data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
A PostgreSQL Interface for TigerGraph Data (MySQL Remoting via JDBC)
Use the Remoting features of the TigerGraph JDBC Driver to create a PostgreSQL entry-point for data access.
-
Apache Log4j2 Overview
CData is aware of the recently disclosed Apache Log4j2 vulnerability (CVE-2021-44228).
-
Connect to ZendeskSell Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ZendeskSell.
-
How to connect to SFTP Data with Squirrel SQL client
Connect to SFTP data and execute queries in the Squirrel SQL Client.
-
Connect to Opsgenie Data in Ruby
Connect to Opsgenie data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Table
Provide connectivity to Azure Table data through an SAP BusinessObjects universe.
-
Search External Google Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Ads data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Ads Data objects that you can access from apps and the dashboard.
-
Easily Integrate ConstantContact Data in Lazarus Pascal IDE
Learn how to easily integrate live ConstantContact data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Sage 200-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sage 200 Data and create custom apps in Mendix.
-
Replicate Google Directory Data to Multiple Databases via the CData Sync CLI
Replicate Google Directory data to disparate databases with a single configuration.
-
Connecting Pipedream with Dynamics NAV 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 Dynamics NAV data in real time.
-
Visualize Live Telegram Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Telegram data.
-
Connect SharePoint Excel Services to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SharePoint Excel Services data using the CData Python MCP Server.
-
Create a Data Access Object for Microsoft Ads Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Ads data in JDBI.
-
How to Use a Microsoft Access Database to Update BigQuery Data in Real Time
Update BigQuery data by creating a linked table in Microsoft Access with the CData BigQuery ODBC Driver.
-
Access Live Google Forms Data in AWS Lambda
Connect to live Google Forms data in AWS Lambda using the CData JDBC Driver.
-
Extract, Transform, and Load Odoo Data in Informatica PowerCenter
Create a simple Workflow for Odoo data in Informatica PowerCenter.
-
Object-Relational Mapping (ORM) with Google Drive 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 Google Drive data into a Java-based ORM framework, Hibernate.
-
How to connect to Basecamp Data in DBVisualizer
Integrate Basecamp data with visual data analysis tools and data connection wizards in DBVisualizer
-
Edit and Search External Couchbase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Couchbase data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Couchbase Data objects that you can access from apps and the dashboard.
-
Object-Relational Mapping (ORM) with Wrike 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 Wrike data into a Java-based ORM framework, Hibernate.
-
Operational Reporting on Excel Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Excel data.
-
Connect to Zoho Inventory Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho Inventory to connect to Zoho Inventory data and execute queries in PowerBuilder.
-
Load IBM Cloud Object Storage Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load IBM Cloud Object Storage data to a database.
-
Integrate Oracle with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle data.
-
Connecting Moonlit Workflow with Microsoft Entra ID 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 Microsoft Entra ID data in real time.
-
Create Snowflake Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Snowflake data access from reports, embedded analytics, and more.
-
Visualize Procore Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Procore data.
-
How to load ChartMogul data into Elasticsearch via Logstash
Introducing a simple method to load ChartMogul data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dashboards and Visualize Live Zoho Projects Data in Geckoboard
Use CData Connect AI to connect to live Zoho Projects data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Aha! Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Aha! and work with Aha! data in your FileMaker applications.
-
Feed Mixpanel Data into FineReport
How to set Mixpanel data as a JDBC data source in FineReport.
-
Add Mixpanel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mixpanel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Spark-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Spark data.
-
Model, Search, and Visualize Live Google Calendar Data in ThoughtSpot
Use CData Connect AI to connect to live Google Calendar data for modeling, searching, and visualizing.
-
Connect to and Query Zoho Creator Data in QlikView over ODBC
Create data visualizations with Zoho Creator data in QlikView.
-
Integrate Cline with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live MYOB AccountRight data from within your IDE.
-
Excel Spreadsheet Automation on QuickBooks Data with the QUERY Formula
Pull data from QuickBooks, automate spreadsheets, and more with the QUERY formula.
-
Connect to Facebook Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Facebook Ads data from PowerBuilder using the Facebook Ads JDBC Driver.
-
Create Klaviyo-Connected Applications in Appsmith
Connect to Klaviyo Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Klaviyo data.
-
Migrating data from Templated to Google BigQuery using CData SSIS Components.
Easily push Templated data to Google BigQuery using the CData SSIS Tasks for Templated and Google BigQuery.
-
Bind Live CSV Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live CSV data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Import and Visualize Vimeo Data in Power View
Create data visualizations based on Vimeo data in Excel.
-
Visualize Blackbaud FE NXT Data in TIBCO Spotfire through ADO.NET
Integrate Blackbaud FE NXT data into dashboards in TIBCO Spotfire.
-
Integrate Live Asana Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Asana from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Asana data.
-
Getting Started with the CData Power BI Connector for Paylocity
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Paylocity.
-
Extract, Transform, and Load Parallel Data in Informatica PowerCenter
Create a simple Workflow for Parallel data in Informatica PowerCenter.
-
Integrate Live Snapchat Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Snapchat Ads data and integrate live Snapchat Ads data into apps built in Microsoft Power Apps.
-
Model, Search, and Visualize Live Highrise Data in ThoughtSpot
Use CData Connect AI to connect to live Highrise data for modeling, searching, and visualizing.
-
Connect to Coinbase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Coinbase data.
-
Automated Continuous EmailOctopus Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Apache Kafka.
-
Create Reports from TaxJar Data in Looker Studio
Use CData Connect AI to gain access to live TaxJar data and create custom reports in Looker Studio.
-
Build Kintone-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Kintone data.
-
Stream ZendeskSell Data into Apache Kafka Topics
Access and stream ZendeskSell data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
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.
-
How to use SQLAlchemy ORM to access Excel Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Excel data.
-
How to Query Microsoft Planner Data in MySQL Workbench
Execute MySQL queries against live Microsoft Planner data from MySQL Workbench.
-
How to Connect Flowise AI Agents to Live ZohoDesk 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 ZohoDesk data without replication.
-
Access Live SAS xpt Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAS xpt data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Gong Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Gong data and build visualizations in Tableau.
-
Integrating OpenCode with Microsoft Exchange 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 HubDB Data in Ruby
Connect to HubDB data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
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.
-
Replicate Act-On Data to Multiple Databases via the CData Sync CLI
Replicate Act-On data to disparate databases with a single configuration.
-
Getting Started with the CData JDBC Driver for HubDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HubDB.
-
Automated Continuous ShipStation Replication to MongoDB
Use CData Sync for automated, continuous, customizable ShipStation replication to MongoDB.
-
Extract, Transform, and Load SharePoint Data in Informatica PowerCenter
Create a simple Workflow for SharePoint data in Informatica PowerCenter.
-
How to Seamlessly Import Zoho CRM Data into IBM SPSS Modeler
Integrate Zoho CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Wistia Data in JRuby
Create a simple JRuby app with access to live Wistia data.
-
Automated Continuous iContact Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable iContact data replication to OneLake in Microsoft Fabric.
-
How to connect to Dynamics CRM Data from Spring Boot
Connect to Dynamics CRM in a Spring Boot Application using the CData JDBC Driver for Dynamics CRM
-
How to load Zoho Projects data into Elasticsearch via Logstash
Introducing a simple method to load Zoho Projects data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Google Drive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Drive data and build Google Drive-connected web apps with Axios.
-
Use the CData Software JDBC Driver for Scrapfly in MicroStrategy
Connect to Scrapfly data in MicroStrategy Developer using the CData Software JDBC Driver for Scrapfly.
-
Build a Simple VCL Application for Auth0 Data
How to build a simple VCL Application to view Auth0 data in RAD Studio using the CData ODBC Driver for Auth0.