CData Software - Knowledge Base
Recent Articles
-
Automated Continuous TaxJar Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable TaxJar replication to Amazon Redshift.
-
Connect to SAP SuccessFactors LMS Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP SuccessFactors LMS data from HeidiSQL.
-
Connect to Freshteam Data in ACL Analytics
Connect to Freshteam data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Freshteam data.
-
Connecting GenSpark with Azure Analysis Services Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Azure Analysis Services data without any replication or custom integration required.
-
Replicate PostgreSQL Data in Heroku for Use in Salesforce Connect
Replicate PostgreSQL data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Azure Synapse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Synapse from Power Pivot. You will use the Table Import Wizard to load Azure Synapse data. You can visually build the import query or use any SQL supported by the driver.
-
Load Google Tasks Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Tasks data to a database.
-
Analyze QuickBooks Time Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for QuickBooks Time from Power Pivot. You will use the Table Import Wizard to load QuickBooks Time data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Slack from Asprova with CData Software ODBC Driver for Slack
This article shows how to connect faster to Slack data from Asprova.
-
Analyze Live Adobe Experience Manager Data in SAS Viya
Use CData Connect AI to connect to Adobe Experience Manager data from SAS Viya and deploy self-service analytics using live Adobe Experience Manager data.
-
Import Epicor Kinetic Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Epicor Kinetic Data and provide access to live Epicor Kinetic data for custom reports in the Power BI Service.
-
DataBind Telegram Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Telegram data to a chart.
-
Connect to Salesforce CRM Analytics Data in HULFT Integrate
Connect to Salesforce CRM Analytics as a JDBC data source in HULFT Integrate
-
How to Connect to Discord Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Discord data. Leverage the pyodbc module for ODBC in Python.
-
Using the CData Software ODBC Driver for ZendeskSell in PyCharm
Connect to ZendeskSell as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZendeskSell.
-
Use the CData Software ODBC Driver for SFTP in MicroStrategy Desktop
Connect to SFTP data in MicroStrategy Desktop using the CData Software ODBC Driver for SFTP.
-
Build Dashboards with Amazon S3 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Amazon S3 data in Dundas BI.
-
Connect to CircleCI Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to CircleCI.
-
How to Access ShipEngine Data Using Entity Framework
This article shows how to access ShipEngine data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData SSIS Components for GitHub
Complete guide to installing, licensing, and connecting with the CData SSIS Components for GitHub.
-
Enable the Excel Online JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Excel Online data.
-
Connect to DB2 Data in Google Apps Script via Connect AI
Use CData Connect AI to access DB2 data in Google Apps Script.
-
Integrate Accelo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Accelo with External Services.
-
A PostgreSQL Interface for MessageBird Data (MySQL Remoting via JDBC)
Use the Remoting features of the MessageBird JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Sentry Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sentry data from Node.js.
-
How to Build an ETL App for Salesloft Data in Python with CData
Create ETL applications and real-time data pipelines for Salesloft data in Python with petl.
-
How to Easily Query Lakebase Data in OpenOffice Base
Connect to Lakebase data in OpenOffice Base using the CData ODBC Driver for Lakebase and generate reports with live data insights.
-
How to Connect to & Open ZarMoney Data in Microsoft Excel
This article uses the CData ODBC driver for ZarMoney to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData ODBC Driver for Mailgun from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mailgun to connect to Mailgun data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mailgun data in Excel.
-
Automated Continuous SingleStore Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SingleStore replication to Azure SQL Database.
-
Connect to Amazon S3 Data in Jaspersoft Studio
Execute SQL to remote Amazon S3 data in Jaspersoft Studio.
-
Integrating Claude Code CLI with WooCommerce 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 HCL Domino Data from PowerBuilder via JDBC
This article demonstrates how to access HCL Domino data from PowerBuilder using the HCL Domino JDBC Driver.
-
Connect to Sentry Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sentry as an External Source in Dremio.
-
Connect to Moosend Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Moosend.
-
Model Freshdesk Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Freshdesk, enabling the direct import of real-time Freshdesk data.
-
Connect to Shopify Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Shopify data in Airbyte.
-
Enable the Jodoo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Jodoo data.
-
Establish a Live Connection with GitLab Data using Tableau Bridge
The CData ODBC Driver for GitLab enables you to integrate live GitLab data into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData JDBC Driver for Spotify
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Spotify.
-
Enable the Toggl JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Toggl data.
-
Automate Tickspot Data Replication to Azure Synapse
Use CData Sync to customize and automate Tickspot data replication to Azure Synapse.
-
Moving Data from Amplitude to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Amplitude data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Boomi Agentstudio with Couchbase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Couchbase data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData SSIS Components for Sentry
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sentry.
-
Visualize Square Data in Sisense
Create an ElastiCube in Sisense app with access to Square data.
-
Build Data Flows from Nuclia to SQL Server using SSIS
Easily back up Nuclia data to SQL Server using the SSIS components for Nuclia.
-
Connect to and Visualize Live OnePageCrm Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live OnePageCrm data.
-
How to Query Live Google Spanner Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Spanner data data in natural language using Python.
-
Natively Connect to Vimeo Data in PHP
The CData ODBC driver for Vimeo enables you to create PHP applications with connectivity to Vimeo data. Leverage the native support for ODBC in PHP.
-
Establish a Live Connection with Elasticsearch Data using Tableau Bridge
The CData ODBC Driver for Elasticsearch enables you to integrate live Elasticsearch data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live ActiveCampaign Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live ActiveCampaign data through MCP integration.
-
How to connect PolyBase to Invoiced
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Invoiced data.
-
Explore Geographical Relationships in Optimizely Data with Power Map
Create data visualizations with Optimizely data in Power Map.
-
Design BIRT Reports on Pipeliner CRM Data
Provide current Pipeliner CRM data to your embedded analytics.
-
Connect to DB2 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for DB2 and the Script function in FileMaker Pro to connect to DB2 and work with DB2 data in your FileMaker application.
-
Integrating OnePageCrm Data in Talend Cloud Data Management Platform
Connect OnePageCrm Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Jodoo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Jodoo data using standard SQL.
-
Prepare, Blend, and Analyze MYOB AccountRight Data in Alteryx Designer (Connect AI)
Build workflows to access live MYOB AccountRight data for self-service data analytics.
-
Connect to Basecamp Data from Crystal Reports
Use CData Connect AI to connect to and report on live Basecamp data from Crystal Reports.
-
Link Teamwork with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Teamwork data in Filemaker Pro for Mac or Windows.
-
Analyze Exa Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Exa from Power Pivot. You will use the Table Import Wizard to load Exa data. You can visually build the import query or use any SQL supported by the driver.
-
How to Query Paylocity Data in MySQL Workbench
Execute MySQL queries against live Paylocity data from MySQL Workbench.
-
How to Visualize Gorgias Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gorgias data in Python.
-
How to Create Power BI Visual Reports with Real-Time Salesforce Pardot Data
Use CData Power BI Connectors to visualize Salesforce Pardot data in Power BI.
-
How to Connect DBeaver to Google Directory via a JDBC Driver
Manage Google Directory data with visual tools in DBeaver like the query browser.
-
Automated Continuous Vault CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Vault CRM replication to Oracle.
-
Create Reports with Cloudant Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cloudant data.
-
Getting Started with the CData JDBC Driver for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Epicor Kinetic.
-
Use Azure AI Foundry to Talk to Your Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Paymo data for you.
-
Automated Continuous Bitbucket Replication to SingleStore
Use CData Sync for automated, continuous, customizable Bitbucket replication to SingleStore.
-
Query Onfleet Data in ColdFusion
Write standard ColdFusion data access code to connect to Onfleet data.
-
Migrating data from Pipeliner CRM to Databricks using CData SSIS Components.
Easily push Pipeliner CRM data to Databricks using the CData SSIS Tasks for Pipeliner CRM and Databricks.
-
Access Invoiced Data from MySQL in PHP
Connect to Invoiced through the standard MySQL libraries in PHP.
-
Creating Greenplum-Connected Applications in Unqork
You can use CData Connect AI to feed Greenplum data to Unqork and build custom business apps.
-
How to work with Redshift Data in Apache Spark using SQL
Access and process Redshift Data in Apache Spark using the CData Software JDBC Driver.
-
Create Datasets from Confluence in Domo Workbench and Build Visualizations of Confluence Data in Domo
Use the CData Software ODBC Driver for Confluence to create datasets from Confluence data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous JotForm Replication to Vertica
Use CData Sync for automated, continuous, customizable JotForm replication to Vertica.
-
Connect to VWO Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time VWO data using standard SQL.
-
How to integrate Avaza with Apache Airflow
Access and process Avaza data in Apache Airflow using the CData JDBC Driver.
-
Build ZohoInvoice-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoInvoice data.
-
Connect to Notion Data from Crystal Reports
Use CData Connect AI to connect to and report on live Notion data from Crystal Reports.
-
Provide OData Services of Hacker News Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Hacker News data by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Rootly in SAS for Real-Time Reporting and Analytics
Connect to real-time Rootly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Rootly.
-
How to connect and process Pushbullet data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pushbullet data.
-
Excel Spreadsheet Automation on Timely Data with the QUERY Formula
Pull data from Timely, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Power BI Connector for Coinbase
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to BenchmarkEmail Data from a Connection Pool in JBoss
Integrate BenchmarkEmail data into Java servlets: Use the Management Console in JBoss to install the BenchmarkEmail JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live TaxJar Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live TaxJar data.
-
How to Seamlessly Import Samanage Data into IBM SPSS Modeler
Integrate Samanage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Visualizations of Shopify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Shopify data in Birst.
-
Connect to Facebook Ads Data in Ruby
Connect to Facebook Ads data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Feed Unbounce Data into FineReport
How to set Unbounce data as a JDBC data source in FineReport.
-
How to Work with Jodoo Data in AWS Glue Jobs Using JDBC
Connect to Jodoo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Prepare, Blend, and Analyze ChargeOver Data in Alteryx Designer (ODBC)
Build workflows to access live ChargeOver data for self-service data analytics.
-
Build a PostgreSQL Interface for Clockify Data using the CData JDBC Driver
Use the Remoting features of the Clockify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to iContact Data in HULFT Integrate
Connect to iContact as a JDBC data source in HULFT Integrate
-
Deploy the ADO.NET Provider for Amazon Athena on an SSRS Report Server
Connect to Amazon Athena data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
DataBind Controls to ScrapingBee Data in C++Builder
DataBind to ScrapingBee data in C++Builder with standard components and controls.
-
Visualize ZohoSubscriptions 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 ZohoSubscriptions data into TIBCO Spotfire.