CData Software - Knowledge Base
Recent Articles
-
Automated Salesforce Pardot Data Replication to Teradata
Use CData Sync to Customize and automate Salesforce Pardot data replication to Teradata.
-
How to integrate AdRoll with Apache Airflow
Access and process AdRoll data in Apache Airflow using the CData JDBC Driver.
-
Create Amazon DynamoDB-Connected Nintex Workflows
Use CData Connect AI to connect to Amazon DynamoDB Data from Nintex Workflow Cloud and build custom workflows using live Amazon DynamoDB data.
-
Connect to Optimizely Data from AWS Glue
Use CData Connect AI to gain access to live Optimizely data from your AWS Glue jobs.
-
Connect to Dynamics CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics CRM in FileMaker Pro to connect to Dynamics CRM and work with Dynamics CRM data in your FileMaker applications.
-
Integrating OpenCode with Mode 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 Oracle HCM Cloud Data in Ruby
Connect to Oracle HCM Cloud data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData Python Connector for Reckon
Learn to install and license the CData Python Connector and configure a connection to live Reckon data.
-
Use the CData ODBC Driver for Yelp from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Yelp to connect to Yelp data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Yelp data in Excel.
-
Import Sage 300 Data Using Azure Data Factory
Use CData Connect AI to connect to Sage 300 Data from Azure Data Factory and import live Sage 300 data.
-
Getting Started with the CData SSIS Components for Neo4J
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Neo4J.
-
Connect to SAS Data Sets Data in NetBeans
Connect to SAS Data Sets data in NetBeans with the data source configuration wizard.
-
Connecting Pipedream with Tally Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Tally data in real time.
-
Getting Started with the CData SSIS Components for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Cosmos DB.
-
Connect to Confluence Data in Claris FileMaker Pro
Use the CData ODBC Driver for Confluence in FileMaker Pro to connect to Confluence and work with Confluence data in your FileMaker applications.
-
Connect to Harvest Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Harvest data in the Denodo Virtual DataPort Administrator.
-
Build SAP Concur-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Concur data.
-
Analyze Basecamp Data in Looker
Use CData Connect AI to connect to Basecamp Data from Looker and build custom apps using live Basecamp data.
-
How to update Adobe Commerce from Excel
This article explains how to transfer data from Excel to Adobe Commerce using the Excel Add-In for Adobe Commerce.
-
Connect to Sendwithus Data in DBeaver
Use the CData ODBC Driver to connect to Sendwithus data in DBeaver.
-
Create Dynamic Gong Grids Using the Infragistics XamDataGrid
Learn how you can connect Gong to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Datadog Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Datadog replication to Amazon Redshift.
-
Create SAP Ariba Procurement Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Ariba Procurement from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Azure Data Lake Storage Data in Ruby
Connect to Azure Data Lake Storage data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Manage Sage Cloud Accounting Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sage Cloud Accounting.
-
Connect to Zoho Inventory Data in Aqua Data Studio
Access Zoho Inventory data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Dash to Build Web Apps on PayPal Data via CData Connect AI
Build interactive Dash web apps on live PayPal data using pandas and the CData Connect AI Python SDK.
-
Analyze Suadeo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Suadeo data in Microsoft R Open.
-
How to create Airtable federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Airtable data in MySQL .
-
Build Dynamics 365-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 Dynamics 365 data without replication.
-
Connect to Active Directory Data in NetBeans
Connect to Active Directory data in NetBeans with the data source configuration wizard.
-
How to use SQLAlchemy ORM to access Jumpseller Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Jumpseller data.
-
Visualize SageHR Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SageHR data.
-
Visualize Live Jumpseller Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Jumpseller data.
-
Validate FTP Data with QuerySurge
Access and validate FTP data in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData Tableau Connector for Quickbase
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Quickbase.
-
Automated Continuous HelloSign Replication to Snowflake
Use CData Sync for automated, continuous, customizable HelloSign replication to Snowflake.
-
Design BIRT Reports on Acumatica Data
Provide current Acumatica data to your embedded analytics.
-
How to Work with Pinecone Data in ETL Validator JDBC
Connect to Pinecone from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating LlamaIndex with Adobe Experience Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Adobe Experience Manager data in real time.
-
Build Dashboards with Smartsheet Data in DBxtra
Create dynamic dashboards and perform analytics based on Smartsheet data in DBxtra.
-
Work with Live Office 365 Data in Power Query
Use CData Connect AI to connect to Office 365 data and work with live Office 365 data in Microsoft Power Query.
-
Explore Geographical Relationships in Rootly Data with Power Map
Create data visualizations with Rootly data in Power Map.
-
Create SSAS Tabular Models from Google Tasks Data
How to build a SQL Server Analysis Service Tabular Model from Google Tasks data using CData drivers.
-
Connect to SharePoint Excel Services from Asprova with CData Software ODBC Driver for SharePoint Excel Services
This article shows how to connect faster to SharePoint Excel Services data from Asprova.
-
Automated Continuous Azure Synapse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Amazon Redshift.
-
Automated Continuous Omnisend Replication to Vertica
Use CData Sync for automated, continuous, customizable Omnisend replication to Vertica.
-
Create Data Visualizations in Cognos BI with Intercom Data
Access Intercom data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Charts to Instagram Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Instagram 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.
-
Access Missive Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Missive data from HeidiSQL.
-
Replicate Coda Data to Multiple Databases via the CData Sync CLI
Replicate Coda data to disparate databases with a single configuration.
-
Connecting Pipedream with Facebook Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Facebook Ads data in real time.
-
Connect to Office 365 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Office 365 data in the Denodo Virtual DataPort Administrator.
-
Create Reports from Shopify Data in Looker Studio
Use CData Connect AI to gain access to live Shopify data and create custom reports in Looker Studio.
-
Integrate ClickUp with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ClickUp with External Services.
-
Visualize Live SAP SuccessFactors LMS Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP SuccessFactors LMS data.
-
Automate Beeminder Data Replication to Couchbase
Use CData Sync to Customize and automate Beeminder data replication to Couchbase.
-
How to Connect the Power BI Service to ElevenLabs: Complete Guide
Connect to the CData Software Power BI Connector for ElevenLabs from PowerBI.com to provide real-time ElevenLabs data across the organization.
-
Design BIRT Reports on Amazon S3 Data
Provide current Amazon S3 data to your embedded analytics.
-
Bridge Cloudant Connectivity with Apache NiFi
Access and process Cloudant data in Apache NiFi using the CData JDBC Driver.
-
Analyze LDAP Objects in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LDAP objects and visualize live LDAP objects in Infragistics Reveal.
-
Use Grok to Talk to Your SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAS Data Sets data for you.
-
How to Connect to Live Adobe Commerce Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Commerce data securely in real time.
-
Import Real-Time SurveyMonkey Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SurveyMonkey data in ColdFusion.
-
Integrate with ClickUp Data in JReport Designer
Create charts and reports based on ClickUp data in JReport Designer.
-
Generating an Entity Data Model in Visual Studio Express
The Entity Data Model Wizard can be used to easily generate an Entity Data Model in Visual Studio. However this feature is not available in Visual Studio Express. In this article you will use the edmgen utility available with .NET Framework 4.0 to generate the Entity Data Model.
-
Getting Started with the CData Excel Add-In for Microsoft Exchange
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Exchange.
-
How to Connect Flowise AI Agents to Live Campaigner Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Campaigner data without replication.
-
Visualize Live Timely Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Timely data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Testmonitor Data from PowerShell
Write a quick PowerShell script to query Testmonitor data. Use connectivity to the live data to replicate Testmonitor data to SQL Server.
-
Visualize Live Amazon DynamoDB Data in the Power BI Service
Use CData Connect AI to connect to live Amazon DynamoDB data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Object-Relational Mapping (ORM) with ConvertAPI 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 ConvertAPI data into a Java-based ORM framework, Hibernate.
-
A PostgreSQL Interface for ZarMoney Data using the CData ODBC Driver
Use the SQL Gateway and ZarMoney ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Klipfolio Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Klipfolio data securely in real time.
-
Access ZarMoney Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZarMoney data from HeidiSQL.
-
A PostgreSQL Interface for Simplesat Data (MySQL Remoting via JDBC)
Use the Remoting features of the Simplesat JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Tavily in SpagoBI
Create reports featuring live Tavily data in SpagoBI Studio. Host Tavily reports on SpagoBI Server.
-
Query Greenplum Data as a SQL Server Database in Node.js
Execute SQL Server queries against Greenplum data from Node.js.
-
Sendwithus Reporting in OBIEE with the Sendwithus JDBC Driver
Deploy the Sendwithus JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Live Amazon Marketplace 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 Amazon Marketplace data directly from the development environment.
-
Getting Started with the CData Excel Add-In for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Ads.
-
Integrating LangChain with Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Tally data within automated workflows.
-
How to create Visio diagrams from HBase Data
Automatically update HBase data with the changes you make to Visio master shapes.
-
Query Impala Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Impala data from Node.js.
-
Create Google Forms-Connected Dashboards in Grafana
Connect to Google Forms Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Forms data.
-
Validate Notion Data with QuerySurge
Access and validate Notion data in QuerySurge using the CData JDBC Driver.
-
Publish Crystal Reports on EnterpriseDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date EnterpriseDB data.
-
How to Query Foursquare Data in MySQL Workbench
Execute MySQL queries against live Foursquare data from MySQL Workbench.
-
Connect to QuickBooks Time Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for QuickBooks Time to connect to QuickBooks Time data and execute queries in PowerBuilder.
-
Automated Continuous HCL Domino Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable HCL Domino replication to Apache Cassandra.
-
Create Informatica Mappings From/To a JDBC Data Source for eBay Analytics
Create eBay Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build FreshBooks-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to FreshBooks data and build web apps with connectivity to live FreshBooks data.
-
Integrating Boomi Agentstudio with Blackbaud FE NXT Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Blackbaud FE NXT data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Kafka Data in Aqua Data Studio
Access Kafka data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Load Greenhouse Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Greenhouse data to a database.
-
Create BigQuery-Connected Nintex Workflows
Use CData Connect AI to connect to BigQuery Data from Nintex Workflow Cloud and build custom workflows using live BigQuery data.
-
Use the CData Software JDBC Driver for TaxJar in MicroStrategy Web
Connect to TaxJar data in MicroStrategy Web using the CData Software JDBC Driver for TaxJar.
-
Connect to Shortcut Data from Crystal Reports
Use CData Connect AI to connect to and report on live Shortcut data from Crystal Reports.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesforce CRM Analytics
Provide connectivity to Salesforce CRM Analytics data through an SAP BusinessObjects universe.
-
Connect to SAP BusinessObjects BI Data in ACL Analytics
Connect to SAP BusinessObjects BI data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP BusinessObjects BI data.