CData Software - Knowledge Base
Recent Articles
-
Integrate CloudConvert Data in the Pentaho Report Designer
Publish reports based on CloudConvert data in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy Desktop
Connect to Dynamics CRM data in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics CRM.
-
Replicate Multiple JotForm Accounts via the CData Sync CLI
Replicate multiple JotForm accounts to one or many databases.
-
Build Data Flows from SQL Server to ADP through SSIS
Easily push SQL Server data to ADP using the CData SSIS Tasks for ADP.
-
Visualize HelloSign Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to HelloSign data.
-
Connect to SAP HANA Data in HULFT Integrate
Connect to SAP HANA as a JDBC data source in HULFT Integrate
-
Connect to Cloudant Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Cloudant data from Filemaker Pro on Mac.
-
Connect to Toggl in SpagoBI
Create reports featuring live Toggl data in SpagoBI Studio. Host Toggl reports on SpagoBI Server.
-
Integrating LangChain with MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MariaDB data within automated workflows.
-
How to Build an ETL App for Salesforce Data in Python with CData
Create ETL applications and real-time data pipelines for Salesforce data in Python with petl.
-
Connect to Google Forms Data in RapidMiner
Integrate Google Forms data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Avalara AvaTax-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Avalara AvaTax data and build web apps with connectivity to live Avalara AvaTax data.
-
Integrating LangGraph with API Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on API data within automated workflows.
-
Build a Singer.io Tap for Bugsnag With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bugsnag data using the CData Python Connector.
-
Integrate RSS Feeds in the Pentaho Report Designer
Publish reports based on RSS feeds in the Pentaho BI tool.
-
Automated Continuous Scrapfly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Scrapfly replication to delimited files (CSV/TSV).
-
Automated Continuous OnePageCrm Replication to Snowflake
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Snowflake.
-
Use Dash to Build to Web Apps on Adobe Experience Manager Data
Create Python applications that use pandas and Dash to build Adobe Experience Manager-connected web apps.
-
Explore Geographical Relationships in WooCommerce Data with Power Map
Create data visualizations with WooCommerce data in Power Map.
-
Viewing Aircall Data in RAD Studio Data Explorer
How to view Aircall data in RAD Studio Data Explorer using the CData ODBC Driver for Aircall.
-
Getting Started with the CData ADO.NET Provider for CouchDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for CouchDB.
-
Build Semantic Layer Views for Amazon DynamoDB Data in APOS Live Data Gateway
Use the CData Connector for Amazon DynamoDB in APOS Live Data Gateway to build Semantic Layer Views for Amazon DynamoDB data.
-
Use Biml to Build SSIS Tasks to Replicate Kintone Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Kintone data to SQL Server.
-
Working with SFTP Data in LINQPad
Execute LINQ queries to SFTP data in LINQPad.
-
Connect to Reckon Accounts Hosted Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Reckon Accounts Hosted to connect to Reckon Accounts Hosted data and execute queries in PowerBuilder.
-
Query Microsoft OneDrive Data in DataGrip
Create a Data Source for Microsoft OneDrive in DataGrip and use SQL to query live Microsoft OneDrive data.
-
Automated Continuous Apify Replication to Oracle
Use CData Sync for automated, continuous, customizable Apify replication to Oracle.
-
Process & Analyze MessageBird Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MessageBird Data.
-
Build a Singer.io Tap for Amplitude With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amplitude data using the CData Python Connector.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Recruit
Create Zoho Recruit data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build MVC Applications with Connectivity to SAP SuccessFactors Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP SuccessFactors from an ASP.NET MVC application.
-
Connect Demio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Demio with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Power BI Connector for Cassandra
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Cassandra.
-
Access Live Jira Assets Data in Excel 365 Online (Excel for the web)
Connect to Jira Assets data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Vercel Data to Multiple Databases
Replicate Vercel data to disparate databases with a point-and-click configuration.
-
Create a Data Access Object for QuickBooks Online Data using JDBI
A brief overview of creating a SQL Object API for QuickBooks Online data in JDBI.
-
How to Work with Amazon S3 Data in AWS Glue Jobs Using JDBC
Connect to Amazon S3 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData ODBC Driver for MailerSend in Microsoft Power Query
You can use the CData MailerSend ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MailerSend data into Microsoft Power Query.
-
Access Live Basecamp Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Basecamp data into the statistical analysis tools available in SAS JMP. This article shows how to use Basecamp data in the Graph Builder and Query Builder.
-
How to Connect to & Open Contentful Data in Microsoft Excel
This article uses the CData ODBC driver for Contentful to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import Cosmos DB Data Using Azure Data Factory
Use CData Connect AI to connect to Cosmos DB Data from Azure Data Factory and import live Cosmos DB data.
-
Automate Vault CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Vault CRM data replication to SAP HANA.
-
Validate Drip Data with QuerySurge
Access and validate Drip data in QuerySurge using the CData JDBC Driver.
-
How to connect to SAS xpt Data from Spring Boot
Connect to SAS xpt in a Spring Boot Application using the CData JDBC Driver for SAS xpt
-
Use Dash to Build to Web Apps on IBM Cloud Object Storage Data
Create Python applications that use pandas and Dash to build IBM Cloud Object Storage-connected web apps.
-
Use the CData Software ODBC Driver for Testmonitor in MicroStrategy
Connect to Testmonitor data in MicroStrategy Developer using the CData Software ODBC Driver for Testmonitor.
-
How to Seamlessly Import Salesforce CRM Analytics Data into IBM SPSS Modeler
Integrate Salesforce CRM Analytics data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to integrate MessageBird with Apache Airflow
Access and process MessageBird data in Apache Airflow using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Campaigner
Create Campaigner data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
A PostgreSQL Interface for ActiveCampaign Data (MySQL Remoting via JDBC)
Use the Remoting features of the ActiveCampaign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Retently Data in Dundas BI
Create dynamic dashboards and perform analytics based on Retently data in Dundas BI.
-
Visualize SAP ByDesign Data in TIBCO Spotfire through OData
Integrate SAP ByDesign data into dashboards in TIBCO Spotfire.
-
Publish Browserless-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Browserless data.
-
Visualize Sage Intacct Data in TIBCO Spotfire through OData
Integrate Sage Intacct data into dashboards in TIBCO Spotfire.
-
Integrating Dynamics 365 Business Central Data in Talend Cloud Data Management Platform
Connect Dynamics 365 Business Central Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Dynamics 365 Business Central.
-
Create a Data Access Object for iContact Data using JDBI
A brief overview of creating a SQL Object API for iContact data in JDBI.
-
Connect to Grafana from a Connection Pool in WebLogic
Use the CData JDBC Driver for Grafana to connect to Grafana data from Web applications running on WebLogic.
-
Connect to Live Basecamp Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Basecamp in CData Connect AI and connect to your Basecamp data from PostgreSQL.
-
Build Charts with Qualaroo Data in Clear Analytics
Create dynamic charts and perform analytics based on Qualaroo data in Clear Analytics.
-
Build MVC Applications with Connectivity to JSON Services
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access JSON from an ASP.NET MVC application.
-
Connect to HelloSign Data from a Connection Pool in Jetty
The HelloSign JDBC Driver supports connection pooling: This article shows how to connect faster to HelloSign data from Web apps in Jetty.
-
Create Apps from Square Data in Qlik Sense Cloud
Use CData Connect AI to connect to Square Data and build apps from live Square data in Qlik Sense Cloud.
-
Manage CSV Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CSV.
-
Getting Started with the CData ODBC Driver for Google Spanner
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Spanner.
-
LINQ to Sybase 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 Sybase Data Provider.
-
Getting Started with the CData ADO.NET Provider for Campaigner
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Twitter Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Twitter Ads in FileMaker Pro to connect to Twitter Ads and work with Twitter Ads data in your FileMaker applications.
-
How to Connect to Teamwork Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Teamwork data. Leverage the pyodbc module for ODBC in Python.
-
Provide OData Services of SAP Business One Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Business One data by developing a WCF Service Application.
-
Connect to Mocean in SpagoBI
Create reports featuring live Mocean data in SpagoBI Studio. Host Mocean reports on SpagoBI Server.
-
Use Dash to Build to Web Apps on eBay Analytics Data
Create Python applications that use pandas and Dash to build eBay Analytics-connected web apps.
-
Integrating Cursor with Shippo 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.
-
How to Query Salesforce Data in MySQL Workbench
Execute MySQL queries against live Salesforce data from MySQL Workbench.
-
Access MYOB AccountRight Data from MySQL in PHP
Connect to MYOB AccountRight through the standard MySQL libraries in PHP.
-
How to create an RPA flow for Confluence Data in UiPath Studio
Use the Confluence ODBC Driver to create workflows that access real-time Confluence data without any coding.
-
Visualize Live eBay Analytics Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live eBay Analytics data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Dify with Live Google Contacts Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Contacts data.
-
Integrating LangChain with Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Asana data within automated workflows.
-
Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy
Connect to Cosmos DB data in MicroStrategy Developer using the CData Software JDBC Driver for Cosmos DB.
-
Query ShipStation Data as a MySQL Database in Node.js
Execute MySQL queries against ShipStation data from Node.js.
-
Access Retently Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Retently data from your Oracle system.
-
Integrating Kiro with ServiceDesk Plus 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.
-
How to Connect to Live Dropbox 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 Dropbox data for you.
-
Write a Simple Go Application to work with Workday Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Workday data.
-
Import and Visualize Spotify Data in Power View
Create data visualizations based on Spotify data in Excel.
-
How to Connect to Live Impala Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Impala data through natural language.
-
How to Query Live Okta Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Okta data data in natural language using Python.
-
Integrate Live Microsoft Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Ads data and integrate live Microsoft Ads data into apps built in Microsoft Power Apps.
-
DataBind Clio Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Clio data to a chart.
-
How to Seamlessly Import Opsgenie Data into IBM SPSS Modeler
Integrate Opsgenie data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect Amazon QuickSight to EnterpriseDB Data
Create a connection to EnterpriseDB data in CData Connect AI and insert EnterpriseDB data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Cline with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live HubSpot data from within your IDE.
-
Access Live Exact Online Data in TIBCO Data Virtualization
Use the Exact Online Tibco DV Adapter to create a Exact Online data data source in TIBCO Data Virtualization Studio and gain access to live Exact Online data from your TDV Server.
-
Visualize Live SAP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Microsoft Exchange Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Exchange data from HeidiSQL.
-
Automated Continuous PostgreSQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Google BigQuery.
-
Model, Search, and Visualize Live JSON Services in ThoughtSpot
Use CData Connect AI to connect to live JSON services for modeling, searching, and visualizing.
-
Automate ShipEngine Data Replication to Couchbase
Use CData Sync to Customize and automate ShipEngine data replication to Couchbase.
-
Connect to Dynamics CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Dynamics CRM data in Google Apps Script.
-
DataBind Charts to Access Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Access 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.