CData Software - Knowledge Base
Recent Articles
-
Build AI/ML Models with Live Insightly Data using Dataiku
Connect Insightly Data with Dataiku using the CData API Driver for JDBC.
-
Getting Started with the CData Excel Add-In for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Data Catalog.
-
Create Epicor Kinetic-Connected Business Apps in AppSheet
Connect to Epicor Kinetic Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Epicor Kinetic.
-
Getting Started with the CData ODBC Driver for QuickBooks
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for QuickBooks.
-
How to create Visio diagrams from Smartsheet Data
Automatically update Smartsheet with the changes you make to Visio master shapes.
-
Access Live Power BI XMLA Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Power BI XMLA from your Excel spreadsheets.
-
Integrate SendGrid Data in Pentaho Data Integration
Build ETL pipelines based on SendGrid in the Pentaho Data Integration tool.
-
Visualize SharePoint Data in Tableau
The CData ODBC driver for SharePoint enables you integrate Microsoft SharePoint into Tableau dashboards.
-
Visualize CircleCI Data in Sisense
Create an ElastiCube in Sisense app with access to CircleCI.
-
Create Reports with ShipEngine Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ShipEngine.
-
Operational Reporting on Elasticsearch Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Elasticsearch.
-
How to connect to AgileCRM Data from IntelliJ
Integrate connectivity to AgileCRM with wizards in IntelliJ.
-
How to Connect the Power BI Service to ZohoDesk: Complete Guide
Connect to the CData Software Power BI Connector for ZohoDesk from PowerBI.com to provide real-time ZohoDesk across the organization.
-
Integrate Dynamics NAV with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dynamics NAV with External Services.
-
Getting Started with the CData ODBC Driver for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CapsuleCRM.
-
Build Data Flows from SQL Server to Klaviyo through SSIS
Easily push SQL Server data to Klaviyo using the CData SSIS Tasks for Klaviyo.
-
Automated Continuous Attio Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Attio replication to AlloyDB.
-
Create Datasets from LinkedIn Ads in Domo Workbench and Build Visualizations of LinkedIn Ads Data in Domo
Use the CData Software ODBC Driver for LinkedIn Ads to create datasets from LinkedIn Ads in Domo Workbench and then build visualizations in the Domo service.
-
Build Cloudant-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Cloudant to explore live Cloudant Data in GitHub Copilot to assist with building Cloudant-powered applications.
-
Integrating Gumloop with Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Projects within automated workflows.
-
How to use SQLAlchemy ORM to access Beeminder Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Beeminder.
-
Integrate with Oracle HCM Cloud Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle HCM Cloud to a JSON file on disk.
-
Automated Continuous HBase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HBase replication to Amazon S3.
-
Create Informatica Mappings From/To an ODBC Data Source for PhantomBuster
Create an ODBC connection to PhantomBuster in Informatica and browse and transfer PhantomBuster.
-
How to load Paymo data into Elasticsearch via Logstash
Introducing a simple method to load Paymo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Live BigCommerce Data in PostGresSQL Interface through CData Connect AI
Create a live connection to BigCommerce in CData Connect AI and connect to your BigCommerce from PostgreSQL.
-
Connect to Parallel Data from PowerBuilder via JDBC
This article demonstrates how to access Parallel from PowerBuilder using the Parallel JDBC Driver.
-
Rapidly Develop Azure Synapse-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 Azure Synapse.
-
Create Data Visualizations in Cognos BI with Salesforce Data 360 Data
Access Salesforce Data 360 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData Tableau Connector for Aha!
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Migrating data from Dynamics NAV to Snowflake using CData SSIS Components.
Easily push Microsoft Dynamics NAV to Snowflake using the CData SSIS Tasks for Dynamics NAV and Snowflake.
-
Prepare, Blend, and Analyze Avalara AvaTax Data in Alteryx Designer (ODBC)
Build workflows to access live Avalara AvaTax for self-service data analytics.
-
Connect to CouchDB Data in ACL Analytics
Connect to Apache CouchDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache CouchDB.
-
Connect to Live Cloudant Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Cloudant in CData Connect AI and connect to your IBM Cloudant from PostgreSQL.
-
Object-Relational Mapping (ORM) with Snapchat 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 Snapchat Ads into a Java-based ORM framework, Hibernate.
-
Migrating data from SendPulse to Snowflake using CData SSIS Components.
Easily push SendPulse to Snowflake using the CData SSIS Tasks for SendPulse and Snowflake.
-
How to Access Live Vault CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Vault CRM enables you to integrate Veeva Vault & Vault CRM into workflows built using Microsoft Power Automate Desktop.
-
Connect to Smartsheet Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Smartsheet from Filemaker Pro on Mac.
-
Getting Started with the CData Connect AI Python SDK for Greenplum
Install the CData Connect AI Python SDK to read and write live Pivotal GreenPlum with standard DB-API 2.0 Python code.
-
Integrating GitHub Copilot CLI with Demio 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.
-
Working with Scrapfly Data in LINQPad
Execute LINQ queries to Scrapfly in LINQPad.
-
How to Connect DBeaver to Teamgate via a JDBC Driver
Manage Teamgate with visual tools in DBeaver like the query browser.
-
How to Query Freshdesk Data in MySQL Workbench
Execute MySQL queries against live Freshdesk from MySQL Workbench.
-
Connect to Quickbase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Quickbase using standard SQL.
-
How to Query Live Oracle Eloqua Reporting Data in Claude Desktop
Connect to and query live Oracle Eloqua Reporting Data in Claude Desktop using CData MCP Server.
-
MariaDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MariaDB facts in real time.
-
Connect and Query Live Oracle Financials Cloud Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Financials Cloud into Databricks
-
Analyze Anaplan Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Anaplan and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Object-Relational Mapping (ORM) with Close 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 Close into a Java-based ORM framework, Hibernate.
-
Integrate Auth0 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Auth0 from Informatica Cloud.
-
How to import Impala Data into Apache Solr
Use the CData Software JDBC Driver for Impala in Data Import Handler and create an automated import of Apache Impala to Apache Solr Enterprise Search platform.
-
How to Connect to SAP
This entry shows how to obtain the connection properties you need to use any CData data provider to connect to SAP.
-
Load Gumroad Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Gumroad to a database.
-
DataBind Controls to SAP BusinessObjects BI Data in C++Builder
DataBind to SAP BusinessObjects BI in C++Builder with standard components and controls.
-
Access Live LinkedIn Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn Ads from your Google Sheets.
-
Connect to Zendesk from Asprova with CData Software ODBC Driver for Zendesk
This article shows how to connect faster to Zendesk data from Asprova.
-
Automated Continuous Email Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Email replication to Apache Kafka.
-
Automated Continuous Shippo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Shippo replication to OneLake in Microsoft Fabric.
-
Visualize Front Data in TIBCO Spotfire through ADO.NET
Integrate Front into dashboards in TIBCO Spotfire.
-
Connect to Mode Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Mode and work with Mode in your FileMaker application.
-
Build Parquet-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Parquet and build web apps with connectivity to live Apache Parquet.
-
Manage Ontraport Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Ontraport.
-
Build an OLAP Cube in SSAS from Yelp Data
Establish a connection to Yelp data from SQL Server Analysis Services, and use the Yelp Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect and process Redis from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Redis.
-
Connect to Wave Financial Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Wave Financial as an External Source in Dremio.
-
Add Google Calendar Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Calendar with the Informatica Enterprise Data Catalog to classify and organize data.
-
Establish a Live Connection with Onfleet Data using Tableau Bridge
The CData ODBC Driver for Onfleet enables you to integrate live Onfleet into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Real-Time PayPal Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PayPal and Dataflow to import and use PayPal in Power Apps.
-
Use the CData Software JDBC Driver for Close in MicroStrategy
Connect to Close in MicroStrategy Developer using the CData Software JDBC Driver for Close.
-
Access Live JSON Services in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live JSON from your Excel spreadsheets.
-
How to connect to ZohoPeople Data with Squirrel SQL client
Connect to ZohoPeople and execute queries in the Squirrel SQL Client.
-
How to connect to HubSpot Data with Squirrel SQL client
Connect to HubSpot and execute queries in the Squirrel SQL Client.
-
Build Semantic Layer Views for Amplitude Data in APOS Live Data Gateway
Use the CData Connector for Amplitude in APOS Live Data Gateway to build Semantic Layer Views for Amplitude.
-
Build MVC Applications with Connectivity to Perigon Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Perigon from an ASP.NET MVC application.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live MYOB AccountRight within intelligent workflows.
-
Build Google Cloud Storage-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Cloud Storage and build Google Cloud Storage-connected web apps with Axios.
-
Visualize Klipfolio Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Klipfolio.
-
Query Dropbox Data in ColdFusion
Write standard ColdFusion data access code to connect to Dropbox.
-
Add Salesforce Marketing Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce Marketing with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate IBM Informix Data Replication to Couchbase
Use CData Sync to Customize and automate IBM Informix replication to Couchbase.
-
Prepare, Blend, and Analyze PayPal Data in Alteryx Designer (ODBC)
Build workflows to access live PayPal for self-service data analytics.
-
Automate Sybase IQ Data Replication to SAP HANA
Use CData Sync to customize and automate Sybase IQ replication to SAP HANA.
-
Write a Simple Go Application to work with Sybase IQ Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sybase IQ.
-
Automate ElevenLabs Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ElevenLabs from PowerShell? This article demonstrates how to utilize the ElevenLabs Cmdlets for tasks like connecting to ElevenLabs, automating operations, downloading data, and more.
-
Rapidly Develop CampaignMonitor-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 CampaignMonitor.
-
Connect to and Query Demio Data in QlikView over ODBC
Create data visualizations with Demio in QlikView.
-
Access Live Sybase IQ Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Sybase IQ through MCP integration.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Sales
Create Oracle Sales data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bidirectional Access to Dynamics 365 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics 365 in Filemaker Pro for Mac or Windows.
-
How to connect to Authorize.Net Data from Spring Boot
Connect to Authorize.Net in a Spring Boot Application using the CData JDBC Driver for Authorize.Net
-
How to Build an ETL App for Certinia Data in Python with CData Connect AI
Build ETL pipelines that read and write live Certinia in Python with petl and the CData Connect AI Python SDK.
-
Analyze Neo4J Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Neo4J from Power Pivot. You will use the Table Import Wizard to load Neo4J. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData SSIS Components for Productboard
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Productboard.
-
Automated Continuous Moosend Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Moosend replication to Apache Cassandra.
-
Manage Google Drive Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Drive.
-
How to Connect to & Open FreshBooks Data in Microsoft Excel
This article uses the CData ODBC driver for FreshBooks to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Reports from Hive Data in Looker Studio
Use CData Connect AI to gain access to live Apache Hive and create custom reports in Looker Studio.
-
Connect to Live OData Services in MicroStrategy through CData Connect AI
Create a live connection to OData Services in CData Connect AI and connect to your OData from MicroStrategy.
-
Integrate Trello Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Trello from Informatica Cloud.
-
Build a Singer.io Tap for Copper With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Copper data using