CData Software - Knowledge Base
Recent Articles
-
Visualize AfterShip Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to AfterShip.
-
Publish SFTP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SFTP.
-
Create GitHub Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time GitHub data access from reports, embedded analytics, and more.
-
Build Monday.com-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Monday.com.
-
Object-Relational Mapping (ORM) with Avalara AvaTax 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 Avalara AvaTax into a Java-based ORM framework, Hibernate.
-
Build Greenhouse-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Greenhouse Data and create custom apps in Bubble.
-
Connect to Sentry Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sentry and the SQL Gateway to access Sentry from Google Apps Script.
-
Integrate Paymo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Paymo with External Services.
-
Use Dash to Build to Web Apps on Asana Data
Create Python applications that use pandas and Dash to build Asana-connected web apps.
-
Build Dashboards with HDFS Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache HDFS in Dundas BI.
-
Integrate Marketo Data into Power Automate Desktop using CData Connect
CData Connect for Marketo Data enables you to integrate Marketo into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access Invoiced Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Invoiced.
-
Access Live LinkedIn Data in Excel 365 Online (Excel for the web)
Connect to LinkedIn from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Write a Simple Go Application to work with Mailjet Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mailjet.
-
Visualize Live FreshBooks Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live FreshBooks into custom reports in Power BI.
-
Use the CData Software ODBC Driver for CapsuleCRM in MicroStrategy Web
Connect to CapsuleCRM in MicroStrategy Web using the CData Software ODBC Driver for CapsuleCRM.
-
How to Connect Twilio 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 Twilio data in real time using natural language.
-
Connect to Tickspot Data from PowerBuilder via JDBC
This article demonstrates how to access Tickspot from PowerBuilder using the Tickspot JDBC Driver.
-
Analyze Live YouTube Analytics Data in SAS Viya
Use CData Connect AI to connect to YouTube Analytics from SAS Viya and deploy self-service analytics using live YouTube Analytics.
-
Publish Optimizely-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Optimizely.
-
Automated Continuous Epicor Kinetic Replication to MySQL
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to MySQL.
-
Integrate Real-Time Access to Freshdesk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Freshdesk in real time.
-
Connect to Sugar CRM Data in DBeaver
Use the CData ODBC Driver to connect to Sugar CRM in DBeaver.
-
Automated Continuous CData Connect AI Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Google BigQuery.
-
How to use SQLAlchemy ORM to access Aweber Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Aweber.
-
SQL Gateway SSH Tunneling Capabilities
Configure the SSH Tunnel on the SQL Gateway to create a reverse SSH tunnel to a publicly accessible SSH host.
-
How to Work with JobNimbus Data in AWS Glue Jobs Using JDBC
Connect to JobNimbus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Short.io Data in the Pentaho Report Designer
Publish reports based on Short.io in the Pentaho BI tool.
-
Automate PabblySubscriptions Data Replication to SAP HANA
Use CData Sync to customize and automate PabblySubscriptions replication to SAP HANA.
-
Integrate Klipfolio Data in the Pentaho Report Designer
Publish reports based on Klipfolio in the Pentaho BI tool.
-
Build Charts with Flowlu Data in Clear Analytics
Create dynamic charts and perform analytics based on Flowlu in Clear Analytics.
-
Connect to Google Campaign Manager 360 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Campaign Manager 360 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Power BI Reports on Real-Time Asana Data
Use the CData ODBC Driver for Asana to visualize Asana in Power BI Desktop.
-
Integrate Live Google Ad Manager Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Ad Manager and integrate live Google Ad Manager into apps built in Microsoft Power Apps.
-
Viewing Amazon Marketplace Data in RAD Studio Data Explorer
How to view Amazon Marketplace in RAD Studio Data Explorer using the CData ODBC Driver for Amazon Marketplace.
-
Getting Started with the CData Python Connector for Greenhouse
Learn to install and license the CData Python Connector
-
Connect to LeadDesk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LeadDesk in the Denodo Virtual DataPort Administrator.
-
Bridge Templated Connectivity with Apache NiFi
Access and process Templated in Apache NiFi using the CData JDBC Driver.
-
Connect to Guru Data in RazorSQL
Connect to Guru from wizards and query Guru from the GUI in the RazorSQL database management tool.
-
How to connect to Access Data with Squirrel SQL client
Connect to Microsoft Access and execute queries in the Squirrel SQL Client.
-
How to connect to AfterShip Data with Squirrel SQL client
Connect to AfterShip and execute queries in the Squirrel SQL Client.
-
Use Microsoft Copilot Studio to talk to your Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Azure Analysis Services for you.
-
DataBind Klaviyo Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Klaviyo with the DevExpress Windows Forms and Web controls to provide Klaviyo to a chart.
-
Access BigCommerce Data from MySQL in PHP
Connect to BigCommerce through the standard MySQL libraries in PHP.
-
Integrate VWO with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate VWO with External Services.
-
Connect to Sage Cloud Accounting Data from AWS Glue
Use CData Connect AI to gain access to live Sage Business Cloud Accounting from your AWS Glue jobs.
-
Connect to Hubstaff Data in HULFT Integrate
Connect to Hubstaff as a JDBC data source in HULFT Integrate
-
How to connect PolyBase to Vault CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Veeva Vault & Vault CRM.
-
Provide OData Services of SAP ByDesign Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Business ByDesign by developing a WCF Service Application.
-
Automated Continuous SAP Ariba Procurement Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to PostgreSQL.
-
Integrate Live Slack Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Slack and integrate live Slack into apps built in Microsoft Power Apps.
-
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 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 Pivotal GreenPlum 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP SuccessFactors 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 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 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 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 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.
-
Connect to iContact Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Teamgate Data in Sisense
Create an ElastiCube in Sisense app with access to Teamgate.
-
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 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 Cloud 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 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 within assisted coding and automated development workflows.
-
How to Import Data from Asana into Google Sheets
Import Asana into a Google spreadsheet that is automatically refreshed.
-
How to Query Live Zoho Creator Data in Claude Desktop
Connect to and query live Zoho Creator Data in Claude Desktop using CData MCP Server.
-
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.
-
Connect to Spotify Data in Ruby
Connect to Spotify 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
-
How to connect to SFTP Data with Squirrel SQL client
Connect to SFTP and execute queries in the Squirrel SQL Client.
-
Connect to Opsgenie Data in Ruby
Connect to Opsgenie 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 Storage through an SAP BusinessObjects universe.
-
Edit and Search External Google Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Ads 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 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 to disparate databases with a single configuration.
-
Visualize Live Telegram Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Telegram.
-
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 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 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 in AWS Lambda using the CData JDBC Driver.
-
Extract, Transform, and Load Odoo Data in Informatica PowerCenter
Create a simple Workflow for Odoo ERP 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 into a Java-based ORM framework, Hibernate.
-
How to connect to Basecamp Data in DBVisualizer
Integrate Basecamp 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 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 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 Microsoft Excel.
-
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 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 to a database.