CData Software - Knowledge Base
Recent Articles
-
Integrate Live Klipfolio Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Klipfolio data and integrate live Klipfolio data into apps built in Microsoft Power Apps.
-
Create Data Visualizations in Cognos BI with Highrise Data
Access Highrise data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Live Typeform 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 Typeform data directly from the development environment.
-
Using the CData Software ODBC Driver for Google Search in PyCharm
Connect to Google Search as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Search.
-
Connect to QuickBooks Data in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks in FileMaker Pro to connect to QuickBooks and work with QuickBooks data in your FileMaker applications.
-
Getting Started with the CData Tableau Connector for Campaigner
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze ServiceDesk Plus Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ServiceDesk Plus data in Microsoft R Open.
-
Viewing Exa Data in RAD Studio Data Explorer
How to view Exa data in RAD Studio Data Explorer using the CData ODBC Driver for Exa.
-
Automated Continuous Simplesat Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Simplesat replication to Apache Cassandra.
-
Automated Continuous Zoho Inventory Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Snowflake.
-
Bridge ChartMogul Connectivity with Apache NiFi
Access and process ChartMogul data in Apache NiFi using the CData JDBC Driver.
-
Integrating OpenCode with RabbitMQ 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.
-
Connect to ChargeOver Data in DBeaver
Use the CData ODBC Driver to connect to ChargeOver data in DBeaver.
-
Excel Spreadsheet Automation on Reckon Accounts Hosted Data with the QUERY Formula
Pull data from Reckon Accounts Hosted, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live Neo4J Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Neo4J data.
-
Integrating Claude Code CLI with Jodoo 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.
-
Connect to iContact Data in Aqua Data Studio
Access iContact data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate SharePoint with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SharePoint with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SharePoint data.
-
Connecting GenSpark with Apify Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apify data without any replication or custom integration required.
-
Build CSV-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for CSV Data and create custom apps in Mendix.
-
Use the CData ODBC Driver for Office 365 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Office 365 to connect to Office 365 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Office 365 data in Excel.
-
Manage Productboard Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Productboard.
-
Use Claude to Talk to Your CouchDB 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 CouchDB data for you.
-
How to Create Power BI Visual Reports with Real-Time Oracle SCM Data
Use CData Power BI Connectors to visualize Oracle SCM data in Power BI.
-
Build a Simple VCL Application for FreeAgent Data
How to build a simple VCL Application to view FreeAgent data in RAD Studio using the CData ODBC Driver for FreeAgent.
-
Create Informatica Mappings From/To a JDBC Data Source for ServiceDesk Plus
Create ServiceDesk Plus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Adobe Commerce Data in TIBCO Data Virtualization
Use the Adobe Commerce Tibco DV Adapter to create a Adobe Commerce data data source in TIBCO Data Virtualization Studio and gain access to live Adobe Commerce data from your TDV Server.
-
Object-Relational Mapping (ORM) with Qualaroo 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 Qualaroo data into a Java-based ORM framework, Hibernate.
-
Write a Simple Go Application to work with Jira Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Jira data.
-
Build Apps with Live Neo4J Data Using the Low-Code Development Platform of Mendix
Connect Neo4J data with Mendix to build apps using the CData JDBC Driver for Neo4J.
-
How to publish and share Dotmailer Data dashboards with Tableau Server
The CData ODBC driver for Dotmailer enables you integrate Dotmailer data into Tableau dashboards.
-
Integrate with Timely Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Timely data to a JSON file on disk.
-
Prepare, Blend, and Analyze Instagram Data in Alteryx Designer (ODBC)
Build workflows to access live Instagram data for self-service data analytics.
-
Build CockroachDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CockroachDB data and build web apps with connectivity to live CockroachDB data.
-
Create Cvent-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Cvent Data from Klipfolio and build custom visualizations using live Cvent data.
-
Connect to Presto Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Presto data.
-
Access Live SparkPost Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SparkPost data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query Twilio Data in DataGrip
Create a Data Source for Twilio in DataGrip and use SQL to query live Twilio data.
-
Connect to Exa Data in Jaspersoft Studio
Execute SQL to remote Exa data in Jaspersoft Studio.
-
Connect to ServiceNow Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ServiceNow data in the Denodo Virtual DataPort Administrator.
-
How to Create Power BI Visual Reports with Real-Time Azure Data Lake Storage Data
Use CData Power BI Connectors to visualize Azure Data Lake Storage data in Power BI.
-
Query SAS xpt Data in DataGrip
Create a Data Source for SAS xpt in DataGrip and use SQL to query live SAS xpt data.
-
Automated Continuous SendPulse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SendPulse replication to Amazon Redshift.
-
Access Live HubDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live HubDB data from your Excel spreadsheets.
-
Use Databricks Agent Bricks to Talk to Your Azure DevOps Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure DevOps data for you.
-
Replicate Jumpseller Data to Multiple Databases via the CData Sync CLI
Replicate Jumpseller data to disparate databases with a single configuration.
-
Replicate Superchat Data from PowerShell
Write a quick PowerShell script to query Superchat data. Use connectivity to the live data to replicate Superchat data to SQL Server.
-
Integrating Cursor with Greenplum 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 Amazon QuickSight to Google Cloud Storage Data
Create a connection to Google Cloud Storage data in CData Connect AI and insert Google Cloud Storage data into Amazon QuickSight SPICE to build interactive dashboards.
-
Leverage the Full Potential of Workday data with CData Sync
This article compares the CData Sync Workday Connector with Workday connectors from other ETL/ELT platforms.
-
Connect to Elasticsearch Data from AWS Glue
Use CData Connect AI to gain access to live Elasticsearch data from your AWS Glue jobs.
-
Getting Started with the CData JDBC Driver for Contentful
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Contentful.
-
Moving Data from Codat to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Codat data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Google Contacts Data in DBeaver
Use the CData ODBC Driver to connect to Google Contacts data in DBeaver.
-
Prepare, Blend, and Analyze TigerGraph Data in Alteryx Designer (ODBC)
Build workflows to access live TigerGraph data for self-service data analytics.
-
SSIS Components: Source Output ColumnName Does Not Match the Data Type "System.String" of the Source Column
In this entry, you will find the steps to resolve the SSIS Source output data type mismatch error.
-
Working with Teamwork Data in LINQPad
Execute LINQ queries to Teamwork data in LINQPad.
-
Integrating Kiro with Short.io 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.
-
Build Pipelines with Live Amazon S3 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Amazon S3 from Google Cloud Data Fusion, enabling the integration of live Amazon S3 data into the building and management of effective data pipelines.
-
Getting Started with the CData Power BI Connector for Impala
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Impala.
-
How to Access Smartsheet Data Using Entity Framework
This article shows how to access Smartsheet data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import SingleStore Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SingleStore Data and provide access to live SingleStore data for custom reports in the Power BI Service.
-
Automate CampaignMonitor Data Replication to Azure Synapse
Use CData Sync to customize and automate CampaignMonitor data replication to Azure Synapse.
-
How to Easily Query MYOB AccountRight Data in OpenOffice Base
Connect to MYOB AccountRight data in OpenOffice Base using the CData ODBC Driver for MYOB AccountRight and generate reports with live data insights.
-
Publish Omnisend-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Omnisend data.
-
Create Reports with SparkPost Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SparkPost data.
-
How to connect Amazon QuickSight to CapsuleCRM Data
Create a connection to CapsuleCRM data in CData Connect AI and insert CapsuleCRM data into Amazon QuickSight SPICE to build interactive dashboards.
-
Migrating data from Sage Cloud Accounting to Google BigQuery using CData SSIS Components.
Easily push Sage Cloud Accounting data to Google BigQuery using the CData SSIS Tasks for Sage Cloud Accounting and Google BigQuery.
-
Migrating data from Xero to Databricks using CData SSIS Components.
Easily push Xero data to Databricks using the CData SSIS Tasks for Xero and Databricks.
-
How to use SQLAlchemy ORM to access Azure Data Lake Storage Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Data Lake Storage data.
-
Integrate with Notion Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Notion data in SnapLogic.
-
Use the CData ODBC Driver for Microsoft Exchange in Microsoft Power Query
You can use the CData Microsoft Exchange ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Exchange data into Microsoft Power Query.
-
Analyze LDAP Objects with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LDAP from Power Pivot. You will use the Table Import Wizard to load LDAP objects. You can visually build the import query or use any SQL supported by the driver.
-
Access Autopilot Data from MySQL in PHP
Connect to Autopilot through the standard MySQL libraries in PHP.
-
Load eBay Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load eBay Analytics data to a database.
-
Automate Everhour Data Replication to Azure Synapse
Use CData Sync to customize and automate Everhour data replication to Azure Synapse.
-
Create Informatica Mappings From/To an ODBC Data Source for ZohoInvoice
Create an ODBC connection to ZohoInvoice in Informatica and browse and transfer ZohoInvoice data.
-
Create SAP SuccessFactors Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP SuccessFactors data access from reports, embedded analytics, and more.
-
Create Attio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Attio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Extract, Transform, and Load Hacker News Data in Informatica PowerCenter
Create a simple Workflow for Hacker News data in Informatica PowerCenter.
-
How to Connect the Power BI Service to Elasticsearch: Complete Guide
Connect to the CData Software Power BI Connector for Elasticsearch from PowerBI.com to provide real-time Elasticsearch data across the organization.
-
Automate Hacker News Data Replication to Couchbase
Use CData Sync to Customize and automate Hacker News data replication to Couchbase.
-
Use the CData ODBC Driver for xBase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for xBase to connect to xBase data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring xBase data in Excel.
-
Manage iContact Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for iContact.
-
Visualize Live SendInBlue Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SendInBlue data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live SAP Concur Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Concur data from your Excel spreadsheets.
-
Rapidly Develop SparkPost-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 SparkPost.
-
How to connect to Datadog Data in DBVisualizer
Integrate Datadog data with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData ODBC Driver for iContact
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for iContact.
-
Link ClickUp with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ClickUp data in Filemaker Pro for Mac or Windows.
-
Automated Continuous ZendeskSell Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Google Cloud SQL.
-
Object-Relational Mapping (ORM) with Odoo 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 Odoo data into a Java-based ORM framework, Hibernate.
-
Extract, Transform, and Load RabbitMQ Data in Informatica PowerCenter
Create a simple Workflow for RabbitMQ data in Informatica PowerCenter.
-
Automated Hive Data Replication to Teradata
Use CData Sync to Customize and automate Hive data replication to Teradata.
-
Connect to Access Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Access data.
-
Connect to Facebook Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Facebook Ads data using standard SQL.
-
Use the CData Software JDBC Driver for Adobe Commerce in MicroStrategy Web
Connect to Adobe Commerce data in MicroStrategy Web using the CData Software JDBC Driver for Adobe Commerce.
-
Getting Started with the CData ADO.NET Provider for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live SAP Concur 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 Concur data through MCP integration.
-
Building Dynamic Web Pages with Couchbase Data Using AngularJS
Create single-page applications with live connectivity to Couchbase using the CData API Server.