CData Software - Knowledge Base
Recent Articles
-
Work with Egnyte Data in FoxPro
Load Egnyte data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Google Tasks Data in Pentaho Data Integration
Build ETL pipelines based on Google Tasks data in the Pentaho Data Integration tool.
-
Excel Spreadsheet Automation on Sage Intacct Data with the QUERY Formula
Pull data from Sage Intacct, automate spreadsheets, and more with the QUERY formula.
-
Replicate Multiple Marketo Accounts
Replicate multiple Marketo accounts to one or many databases.
-
Build a Singer.io Tap for MailChimp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MailChimp data using the CData Python Connector.
-
Connect to Dynamics CRM Data in NetBeans
Connect to Dynamics CRM data in NetBeans with the data source configuration wizard.
-
Access Live CSV Data in Excel 365 Online (Excel for the web)
Connect to CSV data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to SuiteCRM Data from HeidiSQL
Use CData Connect AI to connect to and query live SuiteCRM data from HeidiSQL.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Databricks
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Databricks.
-
Building Dynamic Web Pages with Certinia Data Using AngularJS
Create single-page applications with live connectivity to Certinia using the CData API Server.
-
Visualize Live Salesforce Data 360 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce Data 360 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Seamlessly Import Azure Table Data into IBM SPSS Modeler
Integrate Azure Table data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Zoho Recruit Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Recruit data into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Recruit data in the Graph Builder and Query Builder.
-
Explore Geographical Relationships in Attio Data with Power Map
Create data visualizations with Attio data in Power Map.
-
Connect to Confluence Data in JRuby
Create a simple JRuby app with access to live Confluence data.
-
Integrate Goose with Live ZohoSubscriptions Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ZohoSubscriptions data from within the local AI agent.
-
Connect to Live Adobe Experience Manager Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Adobe Experience Manager in CData Connect AI and connect to your Adobe Experience Manager data from PostgreSQL.
-
Integrating Antigravity CLI with Basecamp data via CData CLI
Connect Basecamp data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Consume SAP SuccessFactors OData Feeds in PowerBuilder
This article demonstrates how to consume SAP SuccessFactors data as OData feeds from PowerBuilder using the API Server.
-
Create Clio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Clio data access from reports, embedded analytics, and more.
-
Automated Continuous Pingdom Replication to SQLite
Use CData Sync for automated, continuous, customizable Pingdom replication to SQLite.
-
Automate ChargeOver Data Replication to Azure Data Lake
Use CData Sync to customize and automate ChargeOver data replication to Azure Data Lake.
-
Build an OLAP Cube in SSAS from Customer.io Data
Establish a connection to Customer.io data data from SQL Server Analysis Services, and use the Customer.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software JDBC Driver for Microsoft Ads in MicroStrategy
Connect to Microsoft Ads data in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Ads.
-
Replicate Multiple Clockify Accounts via the CData Sync CLI
Replicate multiple Clockify accounts to one or many databases.
-
How to Connect to Guru Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Guru data. Leverage the pyodbc module for ODBC in Python.
-
Create Data Visualizations in Cognos BI with ChargeOver Data
Access ChargeOver data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating LangGraph with ActiveCampaign Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ActiveCampaign data within automated workflows.
-
Automated Continuous Parallel Replication to MySQL
Use CData Sync for automated, continuous, customizable Parallel replication to MySQL.
-
Interact with Live Twitter Ads Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Twitter Ads data.
-
Build WordPress-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live WordPress data.
-
How to Visualize Zoho Creator Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Zoho Creator data in Python.
-
Integrating Kiro with Avalara AvaTax 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.
-
Create Azure Table Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure Table from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Cloudant-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Cloudant data.
-
Integrating GitHub Copilot with Dynamics 365 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.
-
Choosing the Best Method to Connect Landbot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Landbot data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Instantly Data from PowerShell
Write a quick PowerShell script to query Instantly data. Use connectivity to the live data to replicate Instantly data to SQL Server.
-
Create Epicor Kinetic-Connected Dashboards in Grafana
Connect to Epicor Kinetic Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Epicor Kinetic data.
-
Use the CData ODBC Driver for FHIR in Microsoft Power Query
You can use the CData FHIR ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FHIR data into Microsoft Power Query.
-
How to Query Zoho Recruit Data in MySQL Workbench
Execute MySQL queries against live Zoho Recruit data from MySQL Workbench.
-
Connect to Exact Online Data from HeidiSQL
Use CData Connect AI to connect to and query live Exact Online data from HeidiSQL.
-
Automated Continuous PolarTeamPro Replication to MySQL
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to MySQL.
-
Build an OLAP Cube in SSAS from Chargebee Data
Establish a connection to Chargebee data data from SQL Server Analysis Services, and use the Chargebee Data Provider to build OLAP cubes for use in analytics and reporting.
-
Object-Relational Mapping (ORM) with SAS xpt 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 SAS xpt data into a Java-based ORM framework, Hibernate.
-
Access Act CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Act CRM data from HeidiSQL.
-
Access Live Adobe Analytics Data in Coginiti Pro
Connect to and query live Adobe Analytics data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Gorgias
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Perform Batch Operations with QuickBooks Data in Apache NiFi
Connect to QuickBooks data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Dashboards with LinkedIn Data in Dundas BI
Create dynamic dashboards and perform analytics based on LinkedIn data in Dundas BI.
-
Build Semantic Layer Views for Slack Data in APOS Live Data Gateway
Use the CData Connector for Slack in APOS Live Data Gateway to build Semantic Layer Views for Slack data.
-
How to Connect to Live SurveyMonkey 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 SurveyMonkey data through natural language.
-
Automated Continuous SAP Ariba Procurement Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to delimited files (CSV/TSV).
-
Choosing the Best Method to Connect ADP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ADP data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Creating Sage Cloud Accounting-Connected Applications in Unqork
You can use CData Connect AI to feed Sage Cloud Accounting data to Unqork and build custom business apps.
-
Visualize Gmail Data in Tableau
The CData ODBC driver for Gmail enables you integrate Gmail data into Tableau dashboards.
-
Create Datasets from Greenhouse in Domo Workbench and Build Visualizations of Greenhouse Data in Domo
Use the CData Software ODBC Driver for Greenhouse to create datasets from Greenhouse data in Domo Workbench and then build visualizations in the Domo service.
-
How to Access Live Supabase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Supabase enables you to integrate Supabase data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Marketo Data from Crystal Reports
Use CData Connect AI to connect to and report on live Marketo data from Crystal Reports.
-
Build CSV-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for CSV Data and create custom apps in Bubble.
-
Build Pipelines with Live AgileCRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to AgileCRM from Google Cloud Data Fusion, enabling the integration of live AgileCRM data into the building and management of effective data pipelines.
-
How to connect to Telegram Data from Spring Boot
Connect to Telegram in a Spring Boot Application using the CData API Driver for JDBC
-
Publish ZendeskSell-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZendeskSell data.
-
Process & Analyze ShipStation Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ShipStation Data.
-
Working with ZohoDesk Data in LINQPad
Execute LINQ queries to ZohoDesk data in LINQPad.
-
Establish a Live Connection with Discourse Data using Tableau Bridge
The CData ODBC Driver for Discourse enables you to integrate live Discourse data into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze iContact Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for iContact from Power Pivot. You will use the Table Import Wizard to load iContact data. You can visually build the import query or use any SQL supported by the driver.
-
View Reports on Real-Time IBM Informix Data in Power BI Report Server
Use the CData ODBC Driver for IBM Informix to visualize IBM Informix data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Couchbase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Couchbase entities in PHP by modeling them as objects.
-
Add Wrike Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Wrike with the Informatica Enterprise Data Catalog to classify and organize data.
-
Seamlessly Bring Zuora Data into Retool Using CData Connect AI
Integrate Zuora data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate with MessageBird Data in JReport Designer
Create charts and reports based on MessageBird data in JReport Designer.
-
Query Google Directory Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Directory data.
-
Create Data Visualizations Based On OneNote Data in Mode
Use CData Connect AI to connect to OneNote Data from Mode and build visualizations using live OneNote data.
-
Automated Continuous BigCommerce Replication to Snowflake
Use CData Sync for automated, continuous, customizable BigCommerce replication to Snowflake.
-
Integrate Avaza Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Avaza data from Informatica Cloud.
-
Build Data Flows from Moosend to SQL Server using SSIS
Easily back up Moosend data to SQL Server using the SSIS components for Moosend.
-
How to load Everhour data into Elasticsearch via Logstash
Introducing a simple method to load Everhour data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Visualize Nuclia Data in Python with pandas
Use pandas and other modules to analyze and visualize live Nuclia data in Python.
-
Connect to Apify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Apify and the SQL Gateway to access Apify data from Google Apps Script.
-
Create GraphQL-Connected Dashboards in Grafana
Connect to GraphQL Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to GraphQL data.
-
Build AI Agents with Bitbucket 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 Bitbucket data through CData Connect AI.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Eloqua
Create Oracle Eloqua data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect Google Cloud Storage Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Cloud Storage data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build SAP HANA-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP HANA data.
-
Getting Started with the CData ODBC Driver for Tanda
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tanda.
-
Automated Continuous HBase Replication to Databricks
Use CData Sync for automated, continuous, customizable HBase replication to Databricks.
-
Configure the CData JDBC Driver for ScrapingBee in a Connection Pool in Tomcat
Connect to ScrapingBee data from a connection pool in Tomcat.
-
Migrating data from JobNimbus to Databricks using CData SSIS Components.
Easily push JobNimbus data to Databricks using the CData SSIS Tasks for JobNimbus and Databricks.
-
Publish Reports with Paymo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paymo data.
-
Use Dash to Build to Web Apps on Discourse Data
Create Python applications that use pandas and Dash to build Discourse-connected web apps.
-
Connect to Google Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Analytics to connect to Google Analytics data from Web applications running on WebLogic.
-
DataBind Controls to Scrapfly Data in C++Builder
DataBind to Scrapfly data in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for Gong in MicroStrategy Desktop
Connect to Gong data in MicroStrategy Desktop using the CData Software ODBC Driver for Gong.
-
Use the CData SSIS Components to Insert New or Update Existing Xero Records from SQL Server
Easily push SQL Server data to Xero using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Xero or update existing records with data from a SQL Server database.
-
Import Apollo Data Using Azure Data Factory
Use CData Connect AI to connect to Apollo Data from Azure Data Factory and import live Apollo data.
-
Use the CData Software JDBC Driver for LinkedIn in MicroStrategy Web
Connect to LinkedIn data in MicroStrategy Web using the CData Software JDBC Driver for LinkedIn.
-
Query Live SQL Analysis Services Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SQL Analysis Services data through a conversational interface.
-
Create Dashboards and Visualize Live Bitbucket Data in Geckoboard
Use CData Connect AI to connect to live Bitbucket data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to MYOB AccountRight Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MYOB AccountRight data using standard SQL.