CData Software - Knowledge Base
Recent Articles
-
How to work with Microsoft Teams Data in Apache Spark using SQL
Access and process Microsoft Teams Data in Apache Spark using the CData Software JDBC Driver.
-
Rapidly Develop Timely-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 Timely.
-
Getting Started with the CData SSIS Components for Grafana
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Grafana.
-
Build Voice Agents in ElevenLabs with access to Live SAP Ariba Procurement Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Ariba Procurement.
-
Integrate Live Jira Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use the CData Software JDBC Driver for Databricks in MicroStrategy
Connect to Databricks in MicroStrategy Developer using the CData Software JDBC Driver for Databricks.
-
Integrate with Accelo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Accelo to a JSON file on disk.
-
How to Connect to Live Acumatica Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Acumatica ERP without replication.
-
Connect to VWO Data from PowerBuilder via JDBC
This article demonstrates how to access VWO from PowerBuilder using the VWO JDBC Driver.
-
Automate Amazon S3 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Amazon S3 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Work with Jira Assets Data in AWS Glue Jobs Using JDBC
Connect to Jira Assets from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create QuickBooks Dataflows on PowerBI.com
Connect to the CData Power BI Connector for QuickBooks from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating GitHub Copilot CLI with Zuora 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.
-
Automated Continuous Everhour Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Everhour replication to Google BigQuery.
-
Create Dashboards and Visualize Live Sugar CRM Data in Geckoboard
Use CData Connect AI to connect to live Sugar CRM and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to use SQLAlchemy ORM to access QuickBooks Online Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of QuickBooks Online.
-
Automate SAS xpt Data Replication to SAP HANA
Use CData Sync to customize and automate SAS XPORT replication to SAP HANA.
-
How to integrate Reply.io with Apache Airflow
Access and process Reply.io in Apache Airflow using the CData JDBC Driver.
-
Build Data Flows from Cvent to SQL Server using SSIS
Easily back up Cvent to SQL Server using the SSIS components for Cvent.
-
Use the CData ODBC Driver for Printful from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Printful to connect to Printful from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Printful in Excel.
-
Stream Demio Data into Apache Kafka Topics
Access and stream Demio in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Use a Microsoft Access Database to Update Redis Data in Real Time
Update Redis data by creating a linked table in Microsoft Access with the CData Redis ODBC Driver.
-
Use the CData Software JDBC Driver for MailerLite in MicroStrategy Desktop
Connect to MailerLite in MicroStrategy Desktop using the CData Software JDBC Driver for MailerLite.
-
Build Semantic Layer Views for Smartsheet Data in APOS Live Data Gateway
Use the CData Connector for Smartsheet in APOS Live Data Gateway to build Semantic Layer Views for Smartsheet.
-
Validate Gumroad Data with QuerySurge
Access and validate Gumroad in QuerySurge using the CData JDBC Driver.
-
Create Gong-Connected Dashboards in Grafana
Connect to Gong Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Gong.
-
Sage Intacct Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sage Intacct through CData Connect AI using different applications and tools.
-
How to Access Microsoft Entra ID Data Using Entity Framework
This article shows how to access Microsoft Entra ID using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData API Server to Access Splunk Data in Microsoft PowerPivot
Use the CData API Server to connect to live Splunk in the Power Pivot business intelligence tool.
-
Integrate Greenplum Data in the Pentaho Report Designer
Publish reports based on Pivotal GreenPlum in the Pentaho BI tool.
-
Explore Geographical Relationships in HDFS Data with Power Map
Create data visualizations with Apache HDFS in Power Map.
-
Build Cosmos DB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Cosmos DB Data and create custom apps in Bubble.
-
How to use SQLAlchemy ORM to access BigCommerce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of BigCommerce.
-
Access Databricks Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Databricks from your Oracle system.
-
Getting Started with the CData Power BI Connector for Webex
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automate NetSuite Data Replication to Azure Synapse
Use CData Sync to customize and automate NetSuite CRM & ERP replication to Azure Synapse.
-
Connect to Retently Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Retently to connect to Retently and execute queries in PowerBuilder.
-
Integrate Goose with Live SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Fieldglass from within the local AI agent.
-
Integrating LlamaIndex with Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Atlassian Jira in real time.
-
How to work with GitLab Data in Apache Spark using SQL
Access and process GitLab Data in Apache Spark using the CData Software JDBC Driver.
-
How to create Pipedrive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Pipedrive in MySQL .
-
Add SAP Ariba Procurement Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Ariba Procurement with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for Neo4J on an SSRS Report Server
Connect to Neo4J 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.
-
How to Connect to Live MarkLogic Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MarkLogic securely in real time.
-
How to connect to Teradata Data from Spring Boot
Connect to Teradata in a Spring Boot Application using the CData JDBC Driver for Teradata
-
Connect and Query Live SAP HANA Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP HANA into Databricks
-
Analyze PayPal Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PayPal in Microsoft R Open.
-
Connect to SAP Business Warehouse Data in DBArtisan
Use wizards in DBArtisan to configure SAP Business Warehouse as a data source.
-
Automated Continuous Avalara AvaTax Replication to Snowflake
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Snowflake.
-
Getting Started with the CData SSIS Components for ZohoDesk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoDesk.
-
Automated Continuous Zendesk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zendesk replication to Azure SQL Database.
-
Automated Continuous Oracle Service Cloud Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to MongoDB.
-
Load Campaigner Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Campaigner to a database.
-
Connect to Jodoo Data in JRuby
Create a simple JRuby app with access to live Jodoo.
-
Work with Zuora Data in FoxPro
Load Zuora into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access OneNote Data Using Entity Framework
This article shows how to access Microsoft OneNote using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Query Live Google Ad Manager Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Ad Manager data in natural language using Python.
-
Create SSAS Tabular Models from Spotify Data
How to build a SQL Server Analysis Service Tabular Model from Spotify using CData drivers.
-
Connect and Query Live Certinia Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Certinia into Databricks
-
Object-Relational Mapping (ORM) with Reply.io 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 Reply.io into a Java-based ORM framework, Hibernate.
-
Automated Continuous HBase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HBase replication to IBM DB2.
-
Visualize Apollo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apollo.
-
Automated Continuous ZohoMarketingHub Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to SQL Server.
-
Connect to and Query Pipeliner CRM Data in QlikView over ODBC
Create data visualizations with Pipeliner CRM in QlikView.
-
Automated Continuous Oracle Sales Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Sales replication to OneLake in Microsoft Fabric.
-
How to connect Amazon QuickSight to Azure Analysis Services Data
Create a connection to Azure Analysis Services in CData Connect AI and insert Azure Analysis Services into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Dynamics CRM Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Dynamics CRM.
-
Publish Reports with PhantomBuster Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PhantomBuster.
-
Access Live Bullhorn CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bullhorn CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect DBeaver to Hacker News via a JDBC Driver
Manage Hacker News with visual tools in DBeaver like the query browser.
-
Explore Geographical Relationships in Salesloft Data with Power Map
Create data visualizations with Salesloft in Power Map.
-
Integrating GitHub Copilot CLI with Quickbase 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.
-
Build a Simple VCL Application for Azure Table Data
How to build a simple VCL Application to view Azure Table Storage in RAD Studio using the CData ODBC Driver for Azure Table.
-
Operational Reporting on Codat Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Codat.
-
Access Shippo Data from MySQL in PHP
Connect to Shippo through the standard MySQL libraries in PHP.
-
Connect to and Query Mocean Data in QlikView over ODBC
Create data visualizations with Mocean in QlikView.
-
Connect to Azure Table Data from a Connection Pool in Jetty
The Azure Table JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Table Storage from Web apps in Jetty.
-
Use the CData Software JDBC Driver for GitLab in MicroStrategy Desktop
Connect to GitLab in MicroStrategy Desktop using the CData Software JDBC Driver for GitLab.
-
Operational Reporting on MailChimp Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MailChimp.
-
How to import Salesforce Data into Apache Solr
Use the CData Software JDBC Driver for Salesforce in Data Import Handler and create an automated import of Salesforce & Force.com to Apache Solr Enterprise Search platform.
-
Zendesk Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zendesk facts in real time.
-
Automated Continuous Slack Replication to Oracle
Use CData Sync for automated, continuous, customizable Slack replication to Oracle.
-
Connect to and Visualize Live Factorial Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Factorial.
-
Connect to Dynamics CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics CRM and the Script function in FileMaker Pro to connect to Dynamics CRM and work with Microsoft Dynamics CRM in your FileMaker application.
-
Choosing the Best Method to Connect Exa to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Exa from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Couchbase 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 Couchbase through MCP integration.
-
Moving Data from Bullhorn CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bullhorn CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Cassandra-Connected Dashboards in Grafana
Connect to Cassandra Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apache Cassandra.
-
Stream Shortcut Data into Apache Kafka Topics
Access and stream Shortcut in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Apps with Live SharePoint Excel Services Data Using the Low-Code Development Platform of Mendix
Connect SharePoint Excel Services with Mendix to build apps using the CData JDBC Driver for SharePoint Excel Services.
-
Connect to Zoho Books Data in Ruby
Connect to Zoho Books in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build AI/ML Models with Live Bitbucket Data using Dataiku
Connect Bitbucket Data with Dataiku using the CData JDBC Driver for Bitbucket.
-
Work with HubSpot Data in FoxPro
Load HubSpot into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate Copper Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Copper from PowerShell? This article demonstrates how to utilize the Copper Cmdlets for tasks like connecting to Copper, automating operations, downloading data, and more.
-
Manage TaxJar Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for TaxJar.
-
Access Live Vimeo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Vimeo into the statistical analysis tools available in SAS JMP. This article shows how to use Vimeo in the Graph Builder and Query Builder.
-
How to Connect to Live Snowflake Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Snowflake for you.
-
Replicate Multiple Google Analytics Accounts
Replicate multiple Google Analytics accounts to one or many databases.
-
A PostgreSQL Interface for HDFS Data using the CData ODBC Driver
Use the SQL Gateway and HDFS ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Zoho Projects Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zoho Projects from Appeon PowerBuilder using the CData ADO.NET Provider for Zoho Projects.