CData Software - Knowledge Base
Recent Articles
-
Connect to Pushbullet Data from a Connection Pool in JBoss
Integrate Pushbullet data into Java servlets: Use the Management Console in JBoss to install the Pushbullet JDBC Driver.
-
Connect to Dropbox 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 Dropbox data.
-
Access Live Dynamics 365 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Dynamics 365 data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use Grok to Talk to Your Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Zoho Projects data for you.
-
How to Connect to Live Authorize.Net Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Authorize.Net data for you.
-
Connect to CapsuleCRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live CapsuleCRM data.
-
Connect and Visualize Live Azure Analysis Services Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Analysis Services data into the Databricks platform and create visualization dashboards with real-time Azure Analysis Services data.
-
DataBind Controls to Zoho Projects Data in Delphi
DataBind to Zoho Projects data in Delphi with standard data access components and controls.
-
How to connect to Amazon Athena Data with Squirrel SQL client
Connect to Amazon Athena data and execute queries in the Squirrel SQL Client.
-
Use Grok to Talk to Your Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Cloudflare data for you.
-
Azure Analysis Services Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Analysis Services facts in real time.
-
Analyze Codat Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Codat data with the CData JDBC Driver for Codat.
-
Visualize Adobe Analytics Data in Tableau
The CData ODBC driver for Adobe Analytics enables you integrate Adobe Analytics data into Tableau dashboards.
-
Object-Relational Mapping (ORM) with Elasticsearch 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 Elasticsearch data into a Java-based ORM framework, Hibernate.
-
Extract, Transform, and Load Keap Data in Informatica PowerCenter
Create a simple Workflow for Keap data in Informatica PowerCenter.
-
Query Okta Data in ColdFusion
Write standard ColdFusion data access code to connect to Okta data.
-
Connect to Pipedrive Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pipedrive as an External Source in Dremio.
-
Connect to Sage 200 Data in HULFT Integrate
Connect to Sage 200 as a JDBC data source in HULFT Integrate
-
Visualize Live Cassandra Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Cassandra data into custom reports in Power BI.
-
Build a Singer.io Tap for ElevenLabs With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ElevenLabs data using the CData Python Connector.
-
Publish Trello-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Trello data.
-
Automate ZohoDesk Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoDesk data replication to Azure Synapse.
-
Build Apps with Live WooCommerce data in Adalo using CData Connect AI
Use CData Connect AI to integrate live WooCommerce data into the Adalo platform and build custom mobile and web applications with real-time WooCommerce data.
-
Import Real-Time Retently Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Retently data in ColdFusion.
-
How to Work with Jumpseller Data in ETL Validator JDBC
Connect to Jumpseller from ETL Validator jobs using the CData Software JDBC Driver.
-
Enable the Elasticsearch JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Elasticsearch data.
-
Connecting GenSpark with NetSuite SuiteAnalytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to NetSuite SuiteAnalytics data without any replication or custom integration required.
-
Process & Analyze ZendeskSell Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZendeskSell Data.
-
Create SSAS Tabular Models from Toggl Data
How to build a SQL Server Analysis Service Tabular Model from Toggl data using CData drivers.
-
Work with Live Jira Assets Data in Power Query
Use CData Connect AI to connect to Jira Assets data and work with live Jira Assets data in Microsoft Power Query.
-
How to Manage Multiple Attachments in Kintone Using the CData Kintone JDBC Driver
Easily add, update, and delete multiple attachments in Kintone using the CData Kintone JDBC Driver for efficient file management.
-
Integrate Live Dynamics CRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Dynamics CRM data and integrate live Dynamics CRM data into apps built in Microsoft Power Apps.
-
Create RSS-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to RSS Feeds from OutSystems and build custom enterprise apps using live RSS feeds.
-
Connect to Recurly from Asprova with CData Software ODBC Driver for Recurly
This article shows how to connect faster to Recurly data from Asprova.
-
Migrating data from Presto to Databricks using CData SSIS Components.
Easily push Presto data to Databricks using the CData SSIS Tasks for Presto and Databricks.
-
Query Pipeline CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pipeline CRM data from Node.js.
-
Integrating Codex with Mouseflow 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.
-
Connecting Pipedream with ADP Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ADP data in real time.
-
How to connect and process Mouseflow data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mouseflow data.
-
Publish Crystal Reports on Xero Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Xero data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cassandra
Provide connectivity to Cassandra data through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for Quickbase Data using the CData ODBC Driver
Use the SQL Gateway and Quickbase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Azure Table Data Using Azure Data Factory
Use CData Connect AI to connect to Azure Table Data from Azure Data Factory and import live Azure Table data.
-
Replicate Sage Cloud Accounting Data in Heroku for Use in Salesforce Connect
Replicate Sage Cloud Accounting data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Tavily
Provide connectivity to Tavily data through an SAP BusinessObjects universe.
-
Integrate Templated Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Templated data from Informatica Cloud.
-
How to Work with Beeminder Data in ETL Validator JDBC
Connect to Beeminder from ETL Validator jobs using the CData Software JDBC Driver.
-
Bridge Impala Connectivity with Apache NiFi
Access and process Impala data in Apache NiFi using the CData JDBC Driver.
-
Create Dynamic Facebook Grids Using the Infragistics XamDataGrid
Learn how you can connect Facebook to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Google Ads Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Ads and the SQL Gateway to access Google Ads data from Google Apps Script.
-
Connect to SAP Concur from Asprova with CData Software ODBC Driver for SAP Concur
This article shows how to connect faster to SAP Concur data from Asprova.
-
Getting Started with the CData Python Connector for Close
Learn to install and license the CData Python Connector and configure a connection to live Close data.
-
Integrating OpenCode with MarkLogic 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.
-
Publish Crystal Reports on Authorize.Net Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Authorize.Net data.
-
Build Dashboards with Nethunt Data in DBxtra
Create dynamic dashboards and perform analytics based on Nethunt data in DBxtra.
-
Automate Zoho Books Data Replication to SAP HANA
Use CData Sync to customize and automate Zoho Books data replication to SAP HANA.
-
Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy
Connect to SAP Ariba Source data in MicroStrategy Developer using the CData Software JDBC Driver for SAP Ariba Source.
-
Build Optimizely-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Optimizely Data and create custom apps in Bubble.
-
How to create Jira Assets federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Jira Assets data in MySQL .
-
Use Databricks Agent Bricks to Talk to Your API Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your API data for you.
-
Connect to Tally Data from AWS Glue
Use CData Connect AI to gain access to live Tally data from your AWS Glue jobs.
-
Build Factorial-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Factorial data and build web apps with connectivity to live Factorial data.
-
Analyze Guru Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Guru from Power Pivot. You will use the Table Import Wizard to load Guru data. You can visually build the import query or use any SQL supported by the driver.
-
Build Dashboards with Tanda Data in Dundas BI
Create dynamic dashboards and perform analytics based on Tanda data in Dundas BI.
-
Integrate Live Missive Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Missive data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Informatica Mappings From/To an ODBC Data Source for ClickUp
Create an ODBC connection to ClickUp in Informatica and browse and transfer ClickUp data.
-
Feed JobNimbus Data into FineReport
How to set JobNimbus data as a JDBC data source in FineReport.
-
Load Bullhorn CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bullhorn CRM data to a database.
-
Build Apps with Live HBase data in Adalo using CData Connect AI
Use CData Connect AI to integrate live HBase data into the Adalo platform and build custom mobile and web applications with real-time HBase data.
-
Create Dynamic Google Drive Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Drive to Infragistics XamDataGrid to build dynamic grids.
-
Build Data Flows from iContact to SQL Server using SSIS
Easily back up iContact data to SQL Server using the SSIS components for iContact.
-
Use Dash to Build to Web Apps on Google Directory Data
Create Python applications that use pandas and Dash to build Google Directory-connected web apps.
-
Connect to Tavily Data in HULFT Integrate
Connect to Tavily as a JDBC data source in HULFT Integrate
-
Connect to Workday Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Workday data.
-
Rapidly Develop Tickspot-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 Tickspot.
-
Enable the Freshsales JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Freshsales data.
-
Build Pipelines with Live Microsoft Exchange Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Exchange from Google Cloud Data Fusion, enabling the integration of live Microsoft Exchange data into the building and management of effective data pipelines.
-
Connect to Superchat Data from PowerBuilder via JDBC
This article demonstrates how to access Superchat data from PowerBuilder using the Superchat JDBC Driver.
-
Validate HCL Domino Data with QuerySurge
Access and validate HCL Domino data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Presto Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Presto replication to Google BigQuery.
-
How to Access Live Google Cloud Storage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Cloud Storage enables you to integrate Google Cloud Storage data into workflows built using Microsoft Power Automate Desktop.
-
Use Azure AI Foundry to Talk to Your Avro 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 Avro data for you.
-
Automated Continuous Google Contacts Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Contacts replication to AlloyDB.
-
Add Clockify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Clockify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData ODBC Driver for MySQL from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MySQL to connect to MySQL data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MySQL data in Excel.
-
Create Reports with SAP SuccessFactors Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors data.
-
Migrating data from Cohere to Google BigQuery using CData SSIS Components.
Easily push Cohere data to Google BigQuery using the CData SSIS Tasks for Cohere and Google BigQuery.
-
Access Nethunt Data from MySQL in Amazon QuickSight
Connect to Nethunt and build visualizations of Nethunt data using a MySQL Connection in Amazon QuickSight.
-
Create Aircall Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Aircall data access from reports, embedded analytics, and more.
-
Replicate Multiple Oracle Eloqua Accounts
Replicate multiple Oracle Eloqua accounts to one or many databases.
-
Integrating Cursor with Google Directory 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.
-
Using the CData Software ODBC Driver for Airtable in PyCharm
Connect to Airtable as an ODBC data source in PyCharm using the CData Software ODBC Driver for Airtable.
-
Use the CData Software JDBC Driver for Avalara AvaTax in MicroStrategy
Connect to Avalara AvaTax data in MicroStrategy Developer using the CData Software JDBC Driver for Avalara AvaTax.
-
Establish a Live Connection with Bitbucket Data using Tableau Bridge
The CData ODBC Driver for Bitbucket enables you to integrate live Bitbucket data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create a Data Access Object for Instagram Data using JDBI
A brief overview of creating a SQL Object API for Instagram data in JDBI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sage 200
Provide connectivity to Sage 200 data through an SAP BusinessObjects universe.
-
Create Google Ad Manager-Connected Nintex Workflows
Use CData Connect AI to connect to Google Ad Manager Data from Nintex Workflow Cloud and build custom workflows using live Google Ad Manager data.
-
Getting Started with the CData JDBC Driver for Sage 200
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage 200.
-
Query, Visualize, and Share live YouTube Analytics Data in Redash
Use CData Connect AI to connect to live YouTube Analytics data in Redash for querying, visualizing, and sharing.
-
Migrating data from Strava to Snowflake using CData SSIS Components.
Easily push Strava data to Snowflake using the CData SSIS Tasks for Strava and Snowflake.