CData Software - Knowledge Base
Recent Articles
-
How to connect to Billsby Data in DBVisualizer
Integrate Billsby with visual data analysis tools and data connection wizards in DBVisualizer
-
Explore Geographical Relationships in Zendesk Data with Power Map
Create data visualizations with Zendesk in Power Map.
-
Getting Started with the CData Power BI Connector for Confluence
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Confluence.
-
Model SAP SuccessFactors Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP SuccessFactors, enabling the direct import of real-time SAP SuccessFactors.
-
Automated Continuous Adobe Commerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to AlloyDB.
-
LINQ to Dynamics CRM 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 Dynamics CRM Data Provider.
-
Integrating LangChain with Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apache Phoenix within automated workflows.
-
Easily Integrate Omnisend Data in Lazarus Pascal IDE
Learn how to easily integrate live Omnisend in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Create Power BI Visual Reports with Real-Time Elorus Data
Use CData Power BI Connectors to visualize Elorus in Power BI.
-
Integrating Cursor CLI with Exa 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.
-
Integrate Theia IDE with Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Visualize Azure Synapse 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 Azure Synapse into TIBCO Spotfire.
-
Integrate FormSite Data in the Pentaho Report Designer
Publish reports based on FormSite in the Pentaho BI tool.
-
Use the CData ODBC Driver for Copper from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Copper to connect to Copper from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Copper in Excel.
-
Build Apps with Live Nethunt Data Using the Low-Code Development Platform of Mendix
Connect Nethunt with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate with Live Act CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Act CRM from the MuleSoft Anypoint Platform to integrate live Act CRM into custom reports and dashboards.
-
Stream Clockify Data into Apache Kafka Topics
Access and stream Clockify in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Consume LDAP OData Feeds in SAP Lumira
Use the API Server to create data visualizations on LDAP feeds that reflect any changes in SAP Lumira.
-
Access Google Ads Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Ads.
-
Automated Continuous HDFS Replication to Snowflake
Use CData Sync for automated, continuous, customizable HDFS replication to Snowflake.
-
Access Live EnterpriseDB 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 EnterpriseDB through MCP integration.
-
Analyze Cloudflare Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Cloudflare in Microsoft R Open.
-
Replicate Sendwithus Data in Heroku for Use in Salesforce Connect
Replicate Sendwithus to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Highrise Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Highrise CRM through MCP integration.
-
Automated Continuous Monday.com Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Monday.com replication to Amazon Redshift.
-
Create Outreach.io-Connected Applications in Appsmith
Connect to Outreach.io Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Outreach.io.
-
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.
-
Getting Started with the CData SSIS Components for Basecamp
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Basecamp.
-
How to Connect DBeaver to Customer.io via a JDBC Driver
Manage Customer.io with visual tools in DBeaver like the query browser.
-
Connect to Couchbase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Couchbase and the Script function in FileMaker Pro to connect to Couchbase and work with Couchbase in your FileMaker application.
-
Integrate with HCL Domino Data in SnapLogic
Use CData Connect AI to connect to and integrate with live HCL Domino in SnapLogic.
-
Connect to Spotify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Spotify and the SQL Gateway to access Spotify from Google Apps Script.
-
DataBind Controls to Zoho Projects Data in Delphi
DataBind to Zoho Projects in Delphi with standard data access components and controls.
-
Connecting Agentforce with Facebook Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Facebook for you.
-
Integrate Real-Time Access to Dynamics CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Dynamics CRM in real time.
-
Automated Continuous Supabase Replication to Databricks
Use CData Sync for automated, continuous, customizable Supabase replication to Databricks.
-
Automate SharePoint Excel Services Data Replication to Azure Synapse
Use CData Sync to customize and automate SharePoint Excel Services replication to Azure Synapse.
-
How to Connect DBeaver to DocuSign via a JDBC Driver
Manage DocuSign with visual tools in DBeaver like the query browser.
-
Connect to CockroachDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for CockroachDB in Airbyte.
-
Connect to Zendesk Data in JRuby
Create a simple JRuby app with access to live Zendesk.
-
Connect to Live API Data in MicroStrategy through CData Connect AI
Create a live connection to API Data in CData Connect AI and connect to your API from MicroStrategy.
-
Automate ZohoDesk Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoDesk replication to Azure Synapse.
-
How to Work with Jumpseller Data in ETL Validator JDBC
Connect to Jumpseller from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a Simple VCL Application for HubDB Data
How to build a simple VCL Application to view HubDB in RAD Studio using the CData ODBC Driver for HubDB.
-
Access Live Xero Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Xero Accounting from your Google Sheets.
-
Connect to Foursquare Data in Jaspersoft Studio
Execute SQL to remote Foursquare in Jaspersoft Studio.
-
Build a PostgreSQL Interface for Oracle Data using the CData JDBC Driver
Use the Remoting features of the Oracle JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Gumroad Data in Sisense
Create an ElastiCube in Sisense app with access to Gumroad.
-
Automated Continuous Oracle Financials Cloud Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Amazon S3.
-
Connect to Templated Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Publish Crystal Reports on SAP HANA XS Advanced Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP HANA XS Advanced.
-
Integrate Drip Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Drip from Informatica Cloud.
-
DataBind Controls to Oracle SCM Data in Delphi
DataBind to Oracle SCM in Delphi with standard data access components and controls.
-
Integrate Live Dynamics CRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Dynamics CRM and integrate live Microsoft Dynamics CRM into apps built in Microsoft Power Apps.
-
How to connect to HDFS Data with Squirrel SQL client
Connect to Apache HDFS and execute queries in the Squirrel SQL Client.
-
Create Datasets from Parallel in Domo Workbench and Build Visualizations of Parallel Data in Domo
Use the CData Software ODBC Driver for Parallel to create datasets from Parallel in Domo Workbench and then build visualizations in the Domo service.
-
Connect and Query Live Vault CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Veeva Vault & Vault CRM into Databricks
-
Connect to Recurly from Asprova with CData Software ODBC Driver for Recurly
This article shows how to connect faster to Recurly data from Asprova.
-
Use the CData Software ODBC Driver for ElevenLabs in MicroStrategy
Connect to ElevenLabs in MicroStrategy Developer using the CData Software ODBC Driver for ElevenLabs.
-
Microsoft Exchange Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft Exchange facts in real time.
-
Visualize ConvertKit 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 ConvertKit into TIBCO Spotfire.
-
Automate Redshift Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Amazon Redshift and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Visualizations of Bugsnag Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bugsnag in Birst.
-
Integrating Codex CLI with Missive 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.
-
Object-Relational Mapping (ORM) with Short.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 Short.io into a Java-based ORM framework, Hibernate.
-
Use the CData ODBC Driver for Oracle SCM in Microsoft Power Query
You can use the CData Oracle SCM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle SCM into Microsoft Power Query.
-
How to Access Live Avalara AvaTax Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Avalara AvaTax enables you to integrate Avalara AvaTax into workflows built using Microsoft Power Automate Desktop.
-
Create Jira-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Jira Data from Klipfolio and build custom visualizations using live Atlassian Jira.
-
Connect to Salesforce Pardot Data in DBeaver
Use the CData ODBC Driver to connect to Salesforce Pardot in DBeaver.
-
Getting Started with the CData ADO.NET Provider for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Business Warehouse.
-
Moving Data from ZohoSubscriptions to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoSubscriptions data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Templated Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Templated 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.
-
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.
-
How to Build an ETL App for Mouseflow Data in Python with CData
Create ETL applications and real-time data pipelines for Mouseflow in Python with petl.
-
Back Up SendGrid to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SendGrid. In this article, we will employ an SSIS workflow to populate a database with SendGrid data.
-
Build AI/ML Models with Live BigCommerce Data using Dataiku
Connect BigCommerce Data with Dataiku using the CData JDBC Driver for BigCommerce.
-
Integrating Cursor CLI with ADP 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.
-
Replicate Printify Data in Heroku for Use in Salesforce Connect
Replicate Printify to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build ActiveCampaign-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for ActiveCampaign to explore live ActiveCampaign Data in GitHub Copilot to assist with building ActiveCampaign-powered applications.
-
Query Printful Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Printful from Node.js.
-
Build Factorial-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Factorial and build web apps with connectivity to live Factorial.
-
Use the CData Software ODBC Driver for HubSpot in SAS for Real-Time Reporting and Analytics
Connect to real-time HubSpot in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HubSpot.
-
Access TigerGraph Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live TigerGraph from HeidiSQL.
-
Replicate Multiple ConvertKit Accounts via the CData Sync CLI
Replicate multiple ConvertKit accounts to one or many databases.
-
Automated QuickBooks Online Data Replication to Teradata
Use CData Sync to Customize and automate QuickBooks Online replication to Teradata.
-
Create Informatica Mappings From/To an ODBC Data Source for ClickUp
Create an ODBC connection to ClickUp in Informatica and browse and transfer ClickUp.
-
Integrating Claude Code with Outreach.io Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Outreach.io within assisted coding and automated development workflows.
-
Feed JobNimbus Data into FineReport
How to set JobNimbus as a JDBC data source in FineReport.
-
Integrating Antigravity CLI with ChargeOver via CData CLI
Connect ChargeOver to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Kintone with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Kintone with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Kintone.
-
Build Data Flows from LinkedIn to SQL Server using SSIS
Easily back up LinkedIn to SQL Server using the SSIS components for LinkedIn.
-
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.
-
Integrating Outreach.io Data in Talend Cloud Data Management Platform
Connect Outreach.io Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Outreach.io.
-
How to Connect to Live Salesforce CRM Analytics Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Salesforce CRM Analytics for you.
-
Rapidly Develop Dropbox-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 Dropbox.
-
Integrate with Adobe Commerce Data in JReport Designer
Create charts and reports based on Adobe Commerce in JReport Designer.
-
How to connect to Apollo Data from IntelliJ
Integrate connectivity to Apollo with wizards in IntelliJ.
-
How to Query Live Cloudant Data in Perplexity MacOS Desktop
Connect to and query live Cloudant Data in Perplexity Desktop using CData MCP Server.
-
Bridge Timely Connectivity with Apache NiFi
Access and process Timely in Apache NiFi using the CData JDBC Driver.