CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of SAP Ariba Source Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Ariba Source data in Birst.
-
Model, Search, and Visualize Live Dropbox Data in ThoughtSpot
Use CData Connect AI to connect to live Dropbox data for modeling, searching, and visualizing.
-
Excel Spreadsheet Automation on SingleStore Data with the QUERY Formula
Pull data from SingleStore, automate spreadsheets, and more with the QUERY formula.
-
Build Impala-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Impala data without replication.
-
How to integrate Metabase with GitHub Data
Use CData Connect AI to connect to live GitHub data and create an interactive dashboard in Metabase from GitHub data.
-
ETL Teradata in Oracle Data Integrator
This article shows how to transfer Teradata data into a data warehouse using Oracle Data Integrator.
-
Connect to Sybase IQ 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 Sybase IQ data.
-
Integrate with iContact Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy iContact data to a JSON file on disk.
-
Deploy the ADO.NET Provider for Invoiced on an SSRS Report Server
Connect to Invoiced data 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.
-
Connect to and Visualize Live Qualaroo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Qualaroo data.
-
Build Dashboards with SAP Fieldglass Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Fieldglass data in DBxtra.
-
Create Informatica Mappings From/To an ODBC Data Source for DocuSign
Create an ODBC connection to DocuSign in Informatica and browse and transfer DocuSign data.
-
How to Build an ETL App for Cloudant Data in Python with CData Connect AI
Build ETL pipelines that read and write live Cloudant data in Python with petl and the CData Connect AI Python SDK.
-
How to connect to SparkPost Data in DBVisualizer
Integrate SparkPost data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Bright Data Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bright Data replication to Google BigQuery.
-
Getting Started with the CData Python Connector for CampaignMonitor
Learn to install and license the CData Python Connector and configure a connection to live CampaignMonitor data.
-
Query Live ConstantContact Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ConstantContact data directly from the development environment.
-
Use the CData Software ODBC Driver for Samanage in MicroStrategy
Connect to Samanage data in MicroStrategy Developer using the CData Software ODBC Driver for Samanage.
-
How to Access Attio Data Using Entity Framework
This article shows how to access Attio data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Publish Reports with Asana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Asana data.
-
Create Power BI Reports on Real-Time MySQL Data
Use the CData ODBC Driver for MySQL to visualize MySQL data in Power BI Desktop.
-
Connect to Instantly Data in CloverDX (formerly CloverETL)
Transfer Instantly data using the visual workflow in the CloverDX data integration tool.
-
Query iContact Data through ODBC in Node.js
Use node-odbc to execute SQL queries against iContact data from Node.js.
-
Query Reply.io Data in DataGrip
Create a Data Source for Reply.io in DataGrip and use SQL to query live Reply.io data.
-
Getting Started with the CData ADO.NET Provider for Jodoo
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Postmark Replication to MongoDB
Use CData Sync for automated, continuous, customizable Postmark replication to MongoDB.
-
Provide OData Services of Gumroad Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Gumroad data by developing a WCF Service Application.
-
Getting Started with the CData Tableau Connector for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Campaigner Data into Power Automate Desktop using CData Connect
CData Connect for Campaigner Data enables you to integrate Campaigner data into workflows built using Microsoft Power Automate Desktop.
-
Sybase IQ Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sybase IQ data through CData Connect AI using different applications and tools.
-
Query Short.io Data in DataGrip
Create a Data Source for Short.io in DataGrip and use SQL to query live Short.io data.
-
How to publish and share Hugging Face Data dashboards with Tableau Server
The CData ODBC driver for Hugging Face enables you integrate Hugging Face data into Tableau dashboards.
-
Build AgileCRM-Connected Apps in Choreo
Use CData Connect AI to connect to AgileCRM Data from Choreo and build custom apps using live AgileCRM data.
-
Publish Crystal Reports on Stack Exchange Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Stack Exchange data.
-
Getting Started with the CData Tableau Connector for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle HCM Cloud.
-
Create ZohoDesk-Connected Applications in Appsmith
Connect to ZohoDesk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ZohoDesk data.
-
Connect to CircleCI Data from a Connection Pool in Jetty
The CircleCI JDBC Driver supports connection pooling: This article shows how to connect faster to CircleCI data from Web apps in Jetty.
-
Creating Google Spanner-Connected Applications in Unqork
You can use CData Connect AI to feed Google Spanner data to Unqork and build custom business apps.
-
Automated Continuous Recurly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Recurly replication to IBM DB2.
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy Web
Connect to SAP Business One data in MicroStrategy Web using the CData Software ODBC Driver for SAP Business One.
-
Automated Continuous QuickBooks Replication to SingleStore
Use CData Sync for automated, continuous, customizable QuickBooks replication to SingleStore.
-
Connect Pushbullet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pushbullet with IBM WebSphere for seamless data integration and connectivity.
-
Import LDAP Objects into the Power BI Service for Visualizations
Use CData Connect AI to connect to LDAP Objects and provide access to live LDAP objects for custom reports in the Power BI Service.
-
How to Connect Microsoft Teams Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Microsoft Teams data in real time using natural language.
-
Consume Salesforce Pardot OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce Pardot data as OData feeds from PowerBuilder using the API Server.
-
How to connect PolyBase to ZohoExpense
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZohoExpense data.
-
Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy Desktop
Connect to QuickBooks Time data in MicroStrategy Desktop using the CData Software JDBC Driver for QuickBooks Time.
-
Build Dashboards with Email Data in DBxtra
Create dynamic dashboards and perform analytics based on Email data in DBxtra.
-
Create Typeform-Connected Applications in Appsmith
Connect to Typeform Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Typeform data.
-
Automated Continuous NetSuite Replication to Databricks
Use CData Sync for automated, continuous, customizable NetSuite replication to Databricks.
-
Connect to Amazon Athena Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon Athena in FileMaker Pro to connect to Amazon Athena and work with Amazon Athena data in your FileMaker applications.
-
Connecting GenSpark with Apollo Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apollo data without any replication or custom integration required.
-
How to connect and process Invoiced data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Invoiced data.
-
Analyze Sugar CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sugar CRM from Power Pivot. You will use the Table Import Wizard to load Sugar CRM data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Open WebUI with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SQL Server data from within the chat interface.
-
How to Create Power BI Visual Reports with Real-Time Active Directory Data
Use CData Power BI Connectors to visualize Active Directory data in Power BI.
-
Prepare, Blend, and Analyze Slack Data in Alteryx Designer (ODBC)
Build workflows to access live Slack data for self-service data analytics.
-
Integrate with SAP BusinessObjects BI Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP BusinessObjects BI data to a JSON file on disk.
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy
Connect to TigerGraph data in MicroStrategy Developer using the CData Software JDBC Driver for TigerGraph.
-
Connect to Azure Data Lake Storage Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Data Lake Storage data from Crystal Reports.
-
Query Kafka Data as a SQL Server Database in Node.js
Execute SQL Server queries against Kafka data from Node.js.
-
Working with XML Data in LINQPad
Execute LINQ queries to XML data in LINQPad.
-
Build a Singer.io Tap for Demio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Demio data using the CData Python Connector.
-
How to Connect CapsuleCRM Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live CapsuleCRM data in real time using natural language.
-
Automated Continuous Facebook Replication to SingleStore
Use CData Sync for automated, continuous, customizable Facebook replication to SingleStore.
-
Visualize Recurly Data in Tableau
The CData ODBC driver for Recurly enables you integrate Recurly data into Tableau dashboards.
-
How to Access SAS xpt Data Using Entity Framework
This article shows how to access SAS xpt data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Live Office 365 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Office 365 in CData Connect AI and connect to your Office 365 data from PostgreSQL.
-
Automate Sentry Data Replication to SAP HANA
Use CData Sync to customize and automate Sentry data replication to SAP HANA.
-
How to Connect to Live PingOne Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live PingOne data securely in real time.
-
Create SSAS Tabular Models from Copper Data
How to build a SQL Server Analysis Service Tabular Model from Copper data using CData drivers.
-
Automated Continuous Omnisend Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Omnisend replication to Amazon Redshift.
-
Use the CData Software JDBC Driver for Adobe Commerce in MicroStrategy
Connect to Adobe Commerce data in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Commerce.
-
Analyze Authorize.Net Data in Looker
Use CData Connect AI to connect to Authorize.Net Data from Looker and build custom apps using live Authorize.Net data.
-
Use Manus AI to Talk to Your ClickUp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on ClickUp data.
-
How to Access SendInBlue Data Using Entity Framework
This article shows how to access SendInBlue data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Design BIRT Reports on SAP SuccessFactors LMS Data
Provide current SAP SuccessFactors LMS data to your embedded analytics.
-
Query MariaDB Data as a MySQL Database in Node.js
Execute MySQL queries against MariaDB data from Node.js.
-
Integrating Dataiku with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Acumatica data.
-
Automated Continuous Paymo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Paymo replication to SQL Server.
-
LINQ to QuickBooks 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 QuickBooks Data Provider.
-
Use the CData Software ODBC Driver for SuiteCRM in MicroStrategy Web
Connect to SuiteCRM data in MicroStrategy Web using the CData Software ODBC Driver for SuiteCRM.
-
Access Live SendPulse Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SendPulse data from your Excel spreadsheets.
-
Integrate Bannerbear Data in the Pentaho Report Designer
Publish reports based on Bannerbear data in the Pentaho BI tool.
-
Publish Reports with SFTP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SFTP data.
-
How to integrate Couchbase with Apache Airflow
Access and process Couchbase data in Apache Airflow using the CData JDBC Driver.
-
Connect to Trello Data in CloverDX (formerly CloverETL)
Transfer Trello data using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy
Connect to Adobe Analytics data in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Analytics.
-
Add VWO Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for VWO with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to Splunk Data from Spring Boot
Connect to Splunk in a Spring Boot Application using the CData JDBC Driver for Splunk
-
Connect to Strava Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Strava data in the Denodo Virtual DataPort Administrator.
-
Replicate Pinterest Data to Multiple Databases via the CData Sync CLI
Replicate Pinterest data to disparate databases with a single configuration.
-
Prepare, Blend, and Analyze Aweber Data in Alteryx Designer (Connect AI)
Build workflows to access live Aweber data for self-service data analytics.
-
Automated Continuous Campaigner Replication to Oracle
Use CData Sync for automated, continuous, customizable Campaigner replication to Oracle.
-
Import Google Campaign Manager 360 Data Using Azure Data Factory
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Azure Data Factory and import live Google Campaign Manager 360 data.
-
Visualize Google Ad Manager Data in Tableau
The CData ODBC driver for Google Ad Manager enables you integrate Google Ad Manager data into Tableau dashboards.
-
ETL Google Sheets in Oracle Data Integrator
This article shows how to transfer Google Sheets data into a data warehouse using Oracle Data Integrator.
-
How to Easily Query Drip Data in OpenOffice Base
Connect to Drip data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live SAP Ariba Procurement 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 SAP Ariba Procurement data through MCP integration.
-
Integrate with Avaza Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Avaza data to a JSON file on disk.