CData Software - Knowledge Base
Recent Articles
-
Connect to and Query Accelo Data in QlikView over ODBC
Create data visualizations with Accelo in QlikView.
-
Getting Started with the CData JDBC Driver for Retently
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Retently.
-
Integrate with SAP Business Warehouse Data in JReport Designer
Create charts and reports based on SAP Business Warehouse in JReport Designer.
-
Build Shopify-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Shopify to explore live Shopify Data in Claude Code to assist with building Shopify-powered applications.
-
Automated Continuous Oracle Service Cloud Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Azure SQL Database.
-
Connect to Bullhorn CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bullhorn CRM.
-
Access Live HubDB Data in AWS Lambda
Connect to live HubDB in AWS Lambda using the CData JDBC Driver.
-
Enable the Customer.io JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Customer.io.
-
Visualize SendPulse Data in TIBCO Spotfire through ADO.NET
Integrate SendPulse into dashboards in TIBCO Spotfire.
-
Publish Reports with ConvertAPI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ConvertAPI.
-
Integrate Phoenix Data in the Pentaho Report Designer
Publish reports based on Apache Phoenix in the Pentaho BI tool.
-
Migrating data from ChartMogul to Google BigQuery using CData SSIS Components.
Easily push ChartMogul to Google BigQuery using the CData SSIS Tasks for ChartMogul and Google BigQuery.
-
Getting Started with the CData ADO.NET Provider for ChartMogul
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
View Reports on Real-Time Google Directory Data in Power BI Report Server
Use the CData ODBC Driver for Google Directory to visualize Google Directory in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Tableau Connector for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for IBM Cloud Object Storage.
-
How to Query Live HCL Domino Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live HCL Domino data in natural language using Python.
-
Analyze Teamgate Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Teamgate from Power Pivot. You will use the Table Import Wizard to load Teamgate. You can visually build the import query or use any SQL supported by the driver.
-
How to use SQLAlchemy ORM to access SAP SuccessFactors LMS Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP SuccessFactors LMS.
-
Publish SAP HANA XS Advanced-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP HANA XS Advanced.
-
Build Excel-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Excel to explore live Excel Data in GitHub Copilot to assist with building Excel-powered applications.
-
How to Connect to Live Basecamp Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Basecamp for you.
-
Automated Continuous Twilio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Twilio replication to Azure SQL Database.
-
Access Live Dropbox 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 Dropbox through MCP integration.
-
Working with Cloudflare Data in LINQPad
Execute LINQ queries to Cloudflare in LINQPad.
-
Visualize Jira Assets Data in TIBCO Spotfire through OData
Integrate Jira Assets into dashboards in TIBCO Spotfire.
-
Connect to SAS Data Sets Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAS Data Sets from Appeon PowerBuilder using the CData ADO.NET Provider for SAS Data Sets.
-
Access Live Gong 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 Gong through MCP integration.
-
How to Connect to Live SingleStore Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SingleStore without replication.
-
Build a Simple VCL Application for Microsoft Planner Data
How to build a simple VCL Application to view Microsoft Planner in RAD Studio using the CData ODBC Driver for Microsoft Planner.
-
Use CData Connect AI to Access Trello Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Trello in the Power Pivot business intelligence tool.
-
How to Seamlessly Import ShipEngine Data into IBM SPSS Modeler
Integrate ShipEngine data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Reports with MySQL Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MySQL.
-
Design BIRT Reports on DB2 Data
Provide current IBM DB2 to your embedded analytics.
-
Create Paylocity Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Paylocity data access from reports, embedded analytics, and more.
-
Validate Printify Data with QuerySurge
Access and validate Printify in QuerySurge using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Adobe Target 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 Adobe Target into a Java-based ORM framework, Hibernate.
-
How to Access Snapchat Ads Data Using Entity Framework
This article shows how to access Snapchat Ads using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Moving Data from PDFMonkey to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PDFMonkey data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to use SQLAlchemy ORM to access Microsoft OneDrive Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft OneDrive.
-
Working with Mailjet Data in LINQPad
Execute LINQ queries to Mailjet in LINQPad.
-
Build ClickUp-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ClickUp.
-
Integrating Antigravity CLI with Gmail via CData CLI
Connect Gmail to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous IBM Informix Replication to SQLite
Use CData Sync for automated, continuous, customizable IBM Informix replication to SQLite.
-
Extend Google Sheets with Pipedrive Data
Make calls to Pipedrive from Google Apps Script via the API Server.
-
How to Connect SurveyMonkey 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 SurveyMonkey data in real time using natural language.
-
Visualize Qualaroo 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 Qualaroo into TIBCO Spotfire.
-
Publish ConvertAPI-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ConvertAPI.
-
Analyze Dotmailer Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dotmailer from Power Pivot. You will use the Table Import Wizard to load Dotmailer. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from Adobe Analytics to Google BigQuery using CData SSIS Components.
Easily push Adobe Analytics to Google BigQuery using the CData SSIS Tasks for Adobe Analytics and Google BigQuery.
-
Replicate Adobe Analytics Data in Heroku for Use in Salesforce Connect
Replicate Adobe Analytics to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Validate Spark Data with QuerySurge
Access and validate Apache Spark SQL in QuerySurge using the CData JDBC Driver.
-
Connect to Live Reckon Accounts Hosted Data in MicroStrategy through CData Connect AI
Create a live connection to Reckon Accounts Hosted Data in CData Connect AI and connect to your Reckon Accounts Hosted from MicroStrategy.
-
Migrating data from Sage 300 to Databricks using CData SSIS Components.
Easily push Sage 300 to Databricks using the CData SSIS Tasks for Sage 300 and Databricks.
-
Analyze Dynamics 365 Business Central Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dynamics 365 Business Central in Microsoft R Open.
-
DataBind Controls to Microsoft Entra ID Data in Delphi
DataBind to Microsoft Entra ID in Delphi with standard data access components and controls.
-
Automated Continuous Opsgenie Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Opsgenie replication to Apache Kafka.
-
How to Create Power BI Visual Reports with Real-Time Excel Data
Use CData Power BI Connectors to visualize Microsoft Excel in Power BI.
-
Connect to JotForm Data from a Connection Pool in JBoss
Integrate JotForm into Java servlets: Use the Management Console in JBoss to install the JotForm JDBC Driver.
-
Access Live Monday.com 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 Monday.com through MCP integration.
-
Automated Continuous Billsby Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Billsby replication to Amazon S3.
-
Visualize MariaDB Data in TIBCO Spotfire through OData
Integrate MariaDB into dashboards in TIBCO Spotfire.
-
Connect Nethunt to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Nethunt with IBM WebSphere for seamless data integration and connectivity.
-
How to use SQLAlchemy ORM to access CircleCI Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of CircleCI.
-
Connect to Salesloft Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesloft using standard SQL.
-
Use Claude to Talk to Your SharePoint 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 Microsoft SharePoint for you.
-
Connect to Salesforce Pardot in SpagoBI
Create reports featuring live Salesforce Pardot in SpagoBI Studio. Host Salesforce Pardot reports on SpagoBI Server.
-
Connect to ZohoDesk Data in DBeaver
Use the CData ODBC Driver to connect to ZohoDesk in DBeaver.
-
Visualize Live Opsgenie Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Opsgenie using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to use SQLAlchemy ORM to access XML Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of XML Files.
-
Connect to Placid Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Placid and work with Placid in your FileMaker applications.
-
Asana Reporting in OBIEE with the Asana JDBC Driver
Deploy the Asana JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
A PostgreSQL Interface for Oracle Eloqua Reporting Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Eloqua Reporting JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData JDBC Driver for Slack
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Slack.
-
Connect to Office 365 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Office 365 in Airbyte.
-
How to connect to CapsuleCRM Data with Squirrel SQL client
Connect to CapsuleCRM and execute queries in the Squirrel SQL Client.
-
Visualize Productboard Data in TIBCO Spotfire through ADO.NET
Integrate Productboard into dashboards in TIBCO Spotfire.
-
Automated Continuous EmailOctopus Replication to SingleStore
Use CData Sync for automated, continuous, customizable EmailOctopus replication to SingleStore.
-
Publish Crystal Reports on PostgreSQL Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PostgreSQL.
-
Connect to Miro Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Miro in the Denodo Virtual DataPort Administrator.
-
DataBind Charts to Templated Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Templated 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.
-
Automate SparkPost Data Replication to Azure Synapse
Use CData Sync to customize and automate SparkPost replication to Azure Synapse.
-
Process & Analyze Microsoft Teams Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Teams Data.
-
How to Connect to Live Box 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 Box through natural language.
-
How to use SQLAlchemy ORM to access EnterpriseDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of EnterpriseDB.
-
Replicate Sybase IQ Data to Multiple Databases via the CData Sync CLI
Replicate Sybase IQ to disparate databases with a single configuration.
-
Write a Simple Go Application to work with Dynamics NAV Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Dynamics NAV.
-
Build Charts with Acumatica Data in Clear Analytics
Create dynamic charts and perform analytics based on Acumatica ERP in Clear Analytics.
-
How to Connect to Live Twilio Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Twilio without replication.
-
Create Reports with PhantomBuster Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PhantomBuster.
-
Automated Continuous GraphQL Replication to Vertica
Use CData Sync for automated, continuous, customizable GraphQL replication to Vertica.
-
Easily Integrate Onfleet Data in Lazarus Pascal IDE
Learn how to easily integrate live Onfleet in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to load Zuora data into Elasticsearch via Logstash
Introducing a simple method to load Zuora data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Viewing Landbot Data in RAD Studio Data Explorer
How to view Landbot in RAD Studio Data Explorer using the CData ODBC Driver for Landbot.
-
Getting Started with the CData ODBC Driver for Aweber
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Aweber.
-
Back Up Act CRM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Act CRM. In this article, we will employ an SSIS workflow to populate a database with Act CRM data.
-
Connect to Excel Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Excel in the Denodo Virtual DataPort Administrator.
-
Easily Integrate BigQuery Data in Lazarus Pascal IDE
Learn how to easily integrate live Google BigQuery in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Planio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Planio in the Denodo Virtual DataPort Administrator.
-
Build Google Sheets-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Sheets to explore live Google Sheets Data in GitHub Copilot to assist with building Google Sheets-powered applications.
-
Visualize Paymo 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 Paymo into TIBCO Spotfire.