CData Software - Knowledge Base
Recent Articles
-
DataBind Charts to Google Spanner Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Spanner data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate Klaviyo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Klaviyo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Klaviyo data.
-
Automated Continuous Amazon S3 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Google Cloud SQL.
-
Automated Continuous ConvertAPI Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ConvertAPI replication to IBM DB2.
-
Explore Geographical Relationships in GetResponse Data with Power Map
Create data visualizations with GetResponse data in Power Map.
-
Automated Continuous Omnisend Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Omnisend replication to Apache Cassandra.
-
Automated Continuous Recurly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Recurly replication to Snowflake.
-
How to import Freshservice Data into Apache Solr
Use the CData Software JDBC Driver for Freshservice in Data Import Handler and create an automated import of Freshservice data to Apache Solr Enterprise Search platform.
-
Integrating Antigravity CLI with JDBC-ODBC Bridge data via CData CLI
Connect JDBC-ODBC Bridge data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Rebilly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Rebilly data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Aha! Data in ColdFusion
Write standard ColdFusion data access code to connect to Aha! data.
-
How to connect Amazon QuickSight to Zuora Data
Create a connection to Zuora data in CData Connect AI and insert Zuora data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate with SAP Netweaver Gateway Data in JReport Designer
Create charts and reports based on SAP Netweaver Gateway data in JReport Designer.
-
Process & Analyze Mailgun Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mailgun Data.
-
Access Live Float Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Float data into the statistical analysis tools available in SAS JMP. This article shows how to use Float data in the Graph Builder and Query Builder.
-
Automated Continuous Bannerbear Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bannerbear data replication to OneLake in Microsoft Fabric.
-
How to load PagerDuty data into Elasticsearch via Logstash
Introducing a simple method to load PagerDuty data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Viewing Reckon Data in RAD Studio Data Explorer
How to view Reckon data in RAD Studio Data Explorer using the CData ODBC Driver for Reckon.
-
Create Informatica Mappings From/To an ODBC Data Source for Telegram
Create an ODBC connection to Telegram in Informatica and browse and transfer Telegram data.
-
Prepare, Blend, and Analyze Hive Data in Alteryx Designer (Connect AI)
Build workflows to access live Hive data for self-service data analytics.
-
Automated Continuous Sentry Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sentry replication to Google BigQuery.
-
Integrating Dataiku with SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SharePoint data.
-
How to use SQLAlchemy ORM to access ConvertAPI Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ConvertAPI data.
-
Access Live eBay Data in AWS Lambda (with IntelliJ IDEA)
Connect to live eBay data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Salesforce CRM Analytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce CRM Analytics data from your Excel spreadsheets.
-
How to Query Live Coinbase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Coinbase data data in natural language using Python.
-
Replicate Jira Assets Data to Multiple Databases via the CData Sync CLI
Replicate Jira Assets data to disparate databases with a single configuration.
-
Access Live LDAP Objects in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LDAP objects from your Excel spreadsheets.
-
Use Claude to Talk to Your Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Perplexity data for you.
-
How to connect and process Aweber data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Aweber data.
-
Access Live Facebook Data in Coginiti Pro
Connect to and query live Facebook data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Redis Data in TIBCO Spotfire through OData
Integrate Redis data into dashboards in TIBCO Spotfire.
-
Connect to SharePoint Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SharePoint and the Script function in FileMaker Pro to connect to SharePoint and work with SharePoint data in your FileMaker application.
-
Access Live Guru 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 Guru data through MCP integration.
-
Integrate Google's Antigravity Agent with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Dataverse data using the Model Context Protocol.
-
Connect to PingOne Data in CloverDX (formerly CloverETL)
Transfer PingOne data using the visual workflow in the CloverDX data integration tool.
-
Publish Azure Analysis Services-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Analysis Services data.
-
Integrate with Slack Data in JReport Designer
Create charts and reports based on Slack data in JReport Designer.
-
Build Pipelines with Live Discord Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Discord from Google Cloud Data Fusion, enabling the integration of live Discord data into the building and management of effective data pipelines.
-
Adobe Commerce Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Adobe Commerce data through CData Connect AI using different applications and tools.
-
Integrating OpenCode with Access 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 Box Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Box data.
-
A PostgreSQL Interface for SAP Business Warehouse Data using the CData ODBC Driver
Use the SQL Gateway and SAP Business Warehouse ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Samanage Data Using Entity Framework
This article shows how to access Samanage data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Object-Relational Mapping (ORM) with Printify 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 Printify data into a Java-based ORM framework, Hibernate.
-
Create SSAS Tabular Models from TigerGraph Data
How to build a SQL Server Analysis Service Tabular Model from TigerGraph data using CData drivers.
-
How to Connect DBeaver to Exa via a JDBC Driver
Manage Exa data with visual tools in DBeaver like the query browser.
-
Integrating Claude Code with PayPal Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on PayPal data within assisted coding and automated development workflows.
-
Automated Continuous CSV Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CSV replication to Amazon S3.
-
Integrate Okta Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Okta data and integrate live Okta data into your Power Automate tasks.
-
Visualize MySQL Data in TIBCO Spotfire through ADO.NET
Integrate MySQL data into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Webex in MicroStrategy
Connect to Webex data in MicroStrategy Developer using the CData Software ODBC Driver for Webex.
-
Analyze Zoho CRM Data in Cognos Analytics
Use CData Connect AI to connect to Zoho CRM Data from Cognos Analytics and analyze live Zoho CRM data.
-
Getting Started with the CData Power BI Connector for Trello
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Trello.
-
Create Informatica Mappings From/To an ODBC Data Source for ADP
Create an ODBC connection to ADP in Informatica and browse and transfer ADP data.
-
Visualize Live Google Search Results in the Power BI Service
Use CData Connect AI to connect to live Google Search results and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect and Query Live Blackbaud FE NXT Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Blackbaud FE NXT data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to QuickBooks Time Data in RazorSQL
Connect to QuickBooks Time from wizards and query QuickBooks Time data from the GUI in the RazorSQL database management tool.
-
Query, Visualize, and Share live Facebook Ads Data in Redash
Use CData Connect AI to connect to live Facebook Ads data in Redash for querying, visualizing, and sharing.
-
Use the CData Software JDBC Driver for FreeAgent in MicroStrategy Web
Connect to FreeAgent data in MicroStrategy Web using the CData Software JDBC Driver for FreeAgent.
-
How to create an RPA flow for Ontraport Data in UiPath Studio
Use the Ontraport ODBC Driver to create workflows that access real-time Ontraport data without any coding.
-
Integrate with live Bitbucket Data in Jitterbit
Use CData Connect AI to connect to and integrate live Bitbucket data in Jitterbit.
-
Build Voice Agents in ElevenLabs with access to Live CockroachDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live CockroachDB data.
-
Create Power BI Reports on Real-Time Cloudant Data
Use the CData ODBC Driver for Cloudant to visualize Cloudant data in Power BI Desktop.
-
Automated Continuous Landbot Replication to Databricks
Use CData Sync for automated, continuous, customizable Landbot replication to Databricks.
-
Model iContact Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and iContact, enabling the direct import of real-time iContact data.
-
Integrating GitHub Copilot with Wistia 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.
-
Build Charts with Moosend Data in Clear Analytics
Create dynamic charts and perform analytics based on Moosend data in Clear Analytics.
-
Design BIRT Reports on Microsoft Teams Data
Provide current Microsoft Teams data to your embedded analytics.
-
Connect to Zoho Books 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 Zoho Books data.
-
Automate Typeform Data Replication to Azure Synapse
Use CData Sync to customize and automate Typeform data replication to Azure Synapse.
-
Connect Amazon Athena Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon Athena data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating OpenCode with Impala 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.
-
Migrating data from Zoho CRM to Databricks using CData SSIS Components.
Easily push Zoho CRM data to Databricks using the CData SSIS Tasks for Zoho CRM and Databricks.
-
Build AgileCRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live AgileCRM data and build visualizations in Tableau Cloud.
-
LINQ to HelloSign Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the HelloSign Data Provider.
-
Model Tavily Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Tavily, enabling the direct import of real-time Tavily data.
-
Connect to Wrike Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Wrike and work with Wrike data in your FileMaker applications.
-
How to Work with Parallel Data in ETL Validator JDBC
Connect to Parallel from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Basecamp Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Basecamp data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Migrating data from Perplexity to Snowflake using CData SSIS Components.
Easily push Perplexity data to Snowflake using the CData SSIS Tasks for Perplexity and Snowflake.
-
Integrating Antigravity CLI with MailerLite data via CData CLI
Connect MailerLite data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Import Samanage Data Using Azure Data Factory
Use CData Connect AI to connect to Samanage Data from Azure Data Factory and import live Samanage data.
-
Connecting Mastra with EnterpriseDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time EnterpriseDB data, no replication required.
-
Build an OLAP Cube in SSAS from SAP HANA Data
Establish a connection to SAP HANA data data from SQL Server Analysis Services, and use the SAP HANA Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create an RPA flow for Miro Data in UiPath Studio
Use the Miro ODBC Driver to create workflows that access real-time Miro data without any coding.
-
Connect to and Visualize Live Rebilly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Rebilly data.
-
Visualize Toggl Data in TIBCO Spotfire through ADO.NET
Integrate Toggl data into dashboards in TIBCO Spotfire.
-
Analyze Amazon DynamoDB Data in Looker
Use CData Connect AI to connect to Amazon DynamoDB Data from Looker and build custom apps using live Amazon DynamoDB data.
-
Connect to Excel Data from PowerBuilder via JDBC
This article demonstrates how to access Excel data from PowerBuilder using the Excel JDBC Driver.
-
Stream Sage Intacct Data into Apache Kafka Topics
Access and stream Sage Intacct data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Cosmos DB Replication to Oracle
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Oracle.
-
How to create Oracle Eloqua federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Eloqua data in MySQL .
-
Create Power BI Reports on Real-Time Pingdom Data
Use the CData ODBC Driver for Pingdom to visualize Pingdom data in Power BI Desktop.
-
Integrate with Azure Synapse Data in JReport Designer
Create charts and reports based on Azure Synapse data in JReport Designer.
-
Integrate Devin with Live Bullhorn CRM Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Bullhorn CRM data.
-
Connect to OneNote Data from PowerBuilder via ADO.NET
This article demonstrates how to access OneNote data from Appeon PowerBuilder using the CData ADO.NET Provider for OneNote.
-
Visualize Office 365 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Office 365 data.
-
Access Live Oracle Eloqua Reporting Data in AWS Lambda
Connect to live Oracle Eloqua Reporting data in AWS Lambda using the CData JDBC Driver.
-
How to Access Trello Data Using Entity Framework
This article shows how to access Trello data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.