CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Confluence-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 Confluence.
-
Publish Crystal Reports on HelloSign Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HelloSign.
-
Connect Everhour to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Everhour using the CData Python MCP Server.
-
Publish Freshservice-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshservice.
-
Working with Copper Data in LINQPad
Execute LINQ queries to Copper in LINQPad.
-
Automated Continuous GitLab Replication to AlloyDB
Use CData Sync for automated, continuous, customizable GitLab replication to AlloyDB.
-
Analyze ActiveCampaign Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ActiveCampaign and visualize ActiveCampaign in SAP Analytics Cloud.
-
Integrate Live Azure DevOps Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure DevOps to Blue Prism using the CData ODBC Driver for Azure DevOps to create automated workflows for repetitive business tasks.
-
Work with ActiveCampaign Data in FoxPro
Load ActiveCampaign into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To an ODBC Data Source for Lakebase
Create an ODBC connection to Lakebase in Informatica and browse and transfer Lakebase.
-
Build eBay-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live eBay.
-
Build Confluence-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Confluence Data from Zoho Analytics and import live Atlassian Confluence.
-
Getting Started with the CData ADO.NET Provider for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for PostgreSQL.
-
Manage Azure Data Catalog Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Data Catalog.
-
Edit and Search Sugar CRM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sugar CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sugar CRM objects that you can access from apps and the dashboard.
-
Integrate Vault CRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Veeva Vault & Vault CRM from Informatica Cloud.
-
How to Connect to Live PayPal 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 PayPal through natural language.
-
Visualize ConstantContact 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 ConstantContact into TIBCO Spotfire.
-
Use JayDeBeApi to access SQL Server Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft SQL Server.
-
How to connect to Delighted Data with Squirrel SQL client
Connect to Delighted and execute queries in the Squirrel SQL Client.
-
Build Apps with Live FreeAgent Data Using the Low-Code Development Platform of Mendix
Connect FreeAgent with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Xero 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 Xero Accounting into TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Aha! in MicroStrategy Desktop
Connect to Aha! in MicroStrategy Desktop using the CData Software ODBC Driver for Aha!.
-
Automated Continuous Microsoft Exchange Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Google Cloud SQL.
-
Build a PostgreSQL Interface for Sage 200 Data using the CData JDBC Driver
Use the Remoting features of the Sage 200 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Mailgun Data from a Connection Pool in JBoss
Integrate Mailgun into Java servlets: Use the Management Console in JBoss to install the Mailgun JDBC Driver.
-
Configure the CData JDBC Driver for Anaplan in a Connection Pool in Tomcat
Connect to Anaplan from a connection pool in Tomcat.
-
Replicate SendInBlue Data in Heroku for Use in Salesforce Connect
Replicate SendInBlue to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Design BIRT Reports on Epicor Kinetic Data
Provide current Epicor Kinetic to your embedded analytics.
-
Import and Visualize Pinecone Data in Power View
Create data visualizations based on Pinecone in Excel.
-
Connect to Google Spanner from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Spanner, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connecting GenSpark with Microsoft Entra ID Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft Entra ID without any replication or custom integration required.
-
Build Pipelines with Live Pipedrive Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Pipedrive from Google Cloud Data Fusion, enabling the integration of live Pipedrive into the building and management of effective data pipelines.
-
How to Query Live Access Data in Claude Desktop
Connect to and query live Access Data in Claude Desktop using CData MCP Server.
-
How to use SQLAlchemy ORM to access CSV Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of CSV/TSV Files.
-
Visualize Neo4J Data in TIBCO Spotfire through ADO.NET
Integrate Neo4J into dashboards in TIBCO Spotfire.
-
Connect to Raisers Edge NXT Data from HeidiSQL
Use CData Connect AI to connect to and query live Raisers Edge NXT from HeidiSQL.
-
Access Live Sugar CRM Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sugar CRM data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to VWO Data in RazorSQL
Connect to VWO from wizards and query VWO from the GUI in the RazorSQL database management tool.
-
Enable the Hacker News JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hacker News.
-
Publish Bitly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Bitly.
-
Automated Continuous Greenplum Replication to SQL Server
Use CData Sync for automated, continuous, customizable Greenplum replication to SQL Server.
-
Connect to SendGrid Data in NetBeans
Connect to SendGrid in NetBeans with the data source configuration wizard.
-
Process & Analyze Hubstaff Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Hubstaff Data.
-
Connect to Supabase Data from a Connection Pool in Jetty
The Supabase JDBC Driver supports connection pooling: This article shows how to connect faster to Supabase from Web apps in Jetty.
-
Build Data Flows from JobNimbus to SQL Server using SSIS
Easily back up JobNimbus to SQL Server using the SSIS components for JobNimbus.
-
How to Access Live Discourse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Discourse enables you to integrate Discourse into workflows built using Microsoft Power Automate Desktop.
-
How to Build an ETL App for Factorial Data in Python with CData
Create ETL applications and real-time data pipelines for Factorial in Python with petl.
-
Using the CData Software ODBC Driver for MarkLogic in PyCharm
Connect to MarkLogic as an ODBC data source in PyCharm using the CData Software ODBC Driver for MarkLogic.
-
Publish Samanage-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Samanage.
-
Automated Continuous MessageBird Replication to Oracle
Use CData Sync for automated, continuous, customizable MessageBird replication to Oracle.
-
Getting Started with the CData ADO.NET Provider for AgileCRM
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Publish Reckon Accounts Hosted-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Reckon Accounts Hosted.
-
Use the CData ODBC Driver for Wave Financial from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Wave Financial to connect to Wave Financial from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Wave Financial in Excel.
-
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, no replication required.
-
Connect to Ontraport Data from a Connection Pool in Jetty
The Ontraport JDBC Driver supports connection pooling: This article shows how to connect faster to Ontraport from Web apps in Jetty.
-
Query OData Services in DataGrip
Create a Data Source for OData in DataGrip and use SQL to query live OData.
-
Build Charts with MailerSend Data in Clear Analytics
Create dynamic charts and perform analytics based on MailerSend in Clear Analytics.
-
Migrating data from OpenWeatherMap to Snowflake using CData SSIS Components.
Easily push OpenWeatherMap to Snowflake using the CData SSIS Tasks for OpenWeatherMap and Snowflake.
-
Design BIRT Reports on Apollo Data
Provide current Apollo to your embedded analytics.
-
Getting Started with the CData Python Connector for Sybase
Learn to install and license the CData Python Connector
-
Import ADP Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ADP Data and provide access to live ADP for custom reports in the Power BI Service.
-
Integrating Power BI XMLA Data in Talend Cloud Data Management Platform
Connect Power BI XMLA Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Power BI XMLA.
-
Import Real-Time Eventbrite Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Eventbrite in ColdFusion.
-
How to create Azure DevOps federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure DevOps in MySQL .
-
How to load Salesforce Marketing data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce Marketing data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Presto Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Codat Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Codat in the Denodo Virtual DataPort Administrator.
-
Connect to Pipedrive Data from a Connection Pool in Jetty
The Pipedrive JDBC Driver supports connection pooling: This article shows how to connect faster to Pipedrive from Web apps in Jetty.
-
Build Apps with Live CSV Data Using the Low-Code Development Platform of Mendix
Connect CSV/TSV Files with Mendix to build apps using the CData JDBC Driver for CSV.
-
Automated Continuous Testmonitor Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Testmonitor replication to Amazon Redshift.
-
Connect to Authorize.Net in SpagoBI
Create reports featuring live Authorize.Net in SpagoBI Studio. Host Authorize.Net reports on SpagoBI Server.
-
Bidirectional Access to eBay Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate eBay in Filemaker Pro for Mac or Windows.
-
A PostgreSQL Interface for LionDesk Data (MySQL Remoting via JDBC)
Use the Remoting features of the LionDesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect and process Google Ad Manager from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Ad Manager.
-
A PostgreSQL Interface for Mocean Data using the CData ODBC Driver
Use the SQL Gateway and Mocean ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to MailerLite Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MailerLite.
-
Build Visualizations of Certinia Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Certinia in Birst.
-
Connect to Mailjet Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mailjet using standard SQL.
-
Getting Started with the CData ADO.NET Provider for Helpscout
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Bidirectional Access to Power BI XMLA Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Power BI XMLA in Filemaker Pro for Mac or Windows.
-
How to Seamlessly Import ConvertKit Data into IBM SPSS Modeler
Integrate ConvertKit data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Vault CRM Data in Excel 365 Online (Excel for the web)
Connect to Veeva Vault & Vault CRM from Excel 365 Online (Excel for the web) with CData Connect AI.
-
CData Sync Truncation Errors
This entry covers the cause of truncation errors as well as various solutions to resolve them.
-
Build Visualizations of Outreach.io Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Outreach.io in Birst.
-
Automated Continuous Amazon S3 Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon S3 replication to SQLite.
-
Replicate Cvent Data to Multiple Databases
Replicate Cvent to disparate databases with a point-and-click configuration.
-
Rapidly Develop Jira Assets-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 Jira Assets.
-
Automate LDAP Objects Replication to Azure Data Lake
Use CData Sync to customize and automate LDAP replication to Azure Data Lake.
-
Integrating Cloudant Data in Talend Cloud Data Management Platform
Connect Cloudant Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Cloudant.
-
Publish Okta-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Okta.
-
Connect to SAP Data in Jaspersoft Studio
Execute SQL to remote SAP ERP/NetWeaver in Jaspersoft Studio.
-
Visualize SpaceX Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SpaceX.
-
Add Deel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Deel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Excel Add-In for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for RabbitMQ.
-
Create ChartMogul Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ChartMogul data access from reports, embedded analytics, and more.
-
Automated Continuous XML Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable XML replication to Google Cloud SQL.
-
Add EnterpriseDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for EnterpriseDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live SQL Analysis Services Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SQL Analysis Services from your Google Sheets.
-
Integrate Goose with Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live GitLab from within the local AI agent.