CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To a JDBC Data Source for CampaignMonitor
Create CampaignMonitor data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to Live ZohoPeople Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ZohoPeople data without replication.
-
Connect to RSS Feeds from AWS Glue
Use CData Connect AI to gain access to live RSS feeds from your AWS Glue jobs.
-
Automated Continuous Typeform Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Typeform replication to Google BigQuery.
-
Automated Continuous Salesforce Marketing Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Amazon Redshift.
-
Connect to Oracle Financials Cloud Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Financials Cloud data from HeidiSQL.
-
Integrate Amazon S3 Data in Pentaho Data Integration
Build ETL pipelines based on Amazon S3 data in the Pentaho Data Integration tool.
-
How to connect PolyBase to Discord
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Discord data.
-
Access Live Mixpanel Data in AWS Lambda
Connect to live Mixpanel data in AWS Lambda using the CData JDBC Driver.
-
Analyze LightSpeedRetail Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LightSpeedRetail data in Microsoft R Open.
-
Replicate Multiple Power BI XMLA Accounts
Replicate multiple Power BI XMLA accounts to one or many databases.
-
Publish Typeform-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Typeform data.
-
Work with Tavily Data in FoxPro
Load Tavily data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Link SAP ByDesign with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP ByDesign data in Filemaker Pro for Mac or Windows.
-
Working with Paymo Data in LINQPad
Execute LINQ queries to Paymo data in LINQPad.
-
Connect to Adobe Experience Manager in SpagoBI
Create reports featuring live Adobe Experience Manager data in SpagoBI Studio. Host Adobe Experience Manager reports on SpagoBI Server.
-
Connect to SendInBlue Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SendInBlue data.
-
Connect to Zoho Creator Data from a Connection Pool in Jetty
The Zoho Creator JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho Creator data from Web apps in Jetty.
-
How to work with Salesforce CRM Analytics Data in Apache Spark using SQL
Access and process Salesforce CRM Analytics Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Open WebUI with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Dataverse data from within the chat interface.
-
Query Klaviyo Data as a MySQL Database in Node.js
Execute MySQL queries against Klaviyo data from Node.js.
-
View Reports on Real-Time Harvest Data in Power BI Report Server
Use the CData ODBC Driver for Harvest to visualize Harvest data in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze LinkedIn Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LinkedIn from Power Pivot. You will use the Table Import Wizard to load LinkedIn data. You can visually build the import query or use any SQL supported by the driver.
-
Use Biml to Build SSIS Tasks to Replicate Salesforce Data 360 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce Data 360 data to SQL Server.
-
Analyze ClickTime Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ClickTime data in Microsoft R Open.
-
Integrating GitHub Copilot with Placid 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.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy Desktop
Connect to Google Sheets data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Sheets.
-
Getting Started with the CData SSIS Components for Xero
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Xero.
-
Connect to Bugsnag Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Bugsnag as an External Source in Dremio.
-
Migrating data from Google Ads to Snowflake using CData SSIS Components.
Easily push Google Ads data to Snowflake using the CData SSIS Tasks for Google Ads and Snowflake.
-
Analyze Live Instagram Data in SAS Viya
Use CData Connect AI to connect to Instagram data from SAS Viya and deploy self-service analytics using live Instagram data.
-
Object-Relational Mapping (ORM) with Email 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 Email data into a Java-based ORM framework, Hibernate.
-
Integrate with Keap Data in JReport Designer
Create charts and reports based on Keap data in JReport Designer.
-
Automated Continuous Mocean Replication to Vertica
Use CData Sync for automated, continuous, customizable Mocean replication to Vertica.
-
Load Coinbase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Coinbase data to a database.
-
Create SharePoint-Connected Applications in Appsmith
Connect to SharePoint Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SharePoint data.
-
Connect to Splunk Data in Google Apps Script via Connect AI
Use CData Connect AI to access Splunk data in Google Apps Script.
-
Connecting Agentforce with SAP Concur Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAP Concur data for you.
-
Connect to SAP HANA XS Advanced from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP HANA XS Advanced to connect to SAP HANA XS Advanced data from Web applications running on WebLogic.
-
Create Snapchat Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Snapchat Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Adobe Experience Manager-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Adobe Experience Manager Data from Zoho Analytics and import live Adobe Experience Manager data.
-
Validate Stripe Data with QuerySurge
Access and validate Stripe data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous SAP Ariba Source Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Azure SQL Database.
-
Connect Nethunt to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Nethunt data using the CData Python MCP Server.
-
Integrate Cursor with Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sendwithus data from within the editor.
-
Integrate Theia IDE with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Avro data from within the development environment.
-
How to connect Amazon QuickSight to Optimizely Data
Create a connection to Optimizely data in CData Connect AI and insert Optimizely data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous TaxJar Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable TaxJar replication to PostgreSQL.
-
Manage Vault CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Vault CRM.
-
Bidirectional Access to Sybase IQ Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sybase IQ data in Filemaker Pro for Mac or Windows.
-
Integrating OpenCode with Pipedrive 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 eBay Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for eBay Analytics to connect to eBay Analytics data from Web applications running on WebLogic.
-
Access Live QuickBooks Online Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks Online data from your Excel spreadsheets.
-
Design BIRT Reports on ZohoMarketingHub Data
Provide current ZohoMarketingHub data to your embedded analytics.
-
Connect LightSpeedRetail to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LightSpeedRetail data using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Miro in MicroStrategy Web
Connect to Miro data in MicroStrategy Web using the CData Software ODBC Driver for Miro.
-
Create Power BI Reports on Real-Time QuickBooks Online Data
Use the CData ODBC Driver for QuickBooks Online to visualize QuickBooks Online data in Power BI Desktop.
-
Automated Continuous Stack Exchange Replication to Databricks
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Databricks.
-
Automated Continuous DB2 for i Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable DB2 for i replication to Google BigQuery.
-
Connect to Marketo Data from AWS Glue
Use CData Connect AI to gain access to live Marketo data from your AWS Glue jobs.
-
How to connect PolyBase to Printful
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Printful data.
-
Connect to Xero 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 Xero data.
-
Integrate Cursor with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure Data Lake Storage data from within the editor.
-
Automated Continuous BigCommerce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable BigCommerce replication to Google BigQuery.
-
Use the CData Software ODBC Driver for OpenWeatherMap in MicroStrategy
Connect to OpenWeatherMap data in MicroStrategy Developer using the CData Software ODBC Driver for OpenWeatherMap.
-
Connect to Oracle Eloqua Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle Eloqua data in the Denodo Virtual DataPort Administrator.
-
How to Connect ShipEngine 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 ShipEngine data in real time using natural language.
-
Visualize Google Campaign Manager 360 Data in TIBCO Spotfire through ADO.NET
Integrate Google Campaign Manager 360 data into dashboards in TIBCO Spotfire.
-
Working with Shortcut Data in LINQPad
Execute LINQ queries to Shortcut data in LINQPad.
-
Automated Continuous ZarMoney Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZarMoney replication to Apache Cassandra.
-
Publish AgileCRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live AgileCRM data.
-
Connect to ScrapingBee Data in CloverDX (formerly CloverETL)
Transfer ScrapingBee data using the visual workflow in the CloverDX data integration tool.
-
LINQ to Sage Cloud Accounting 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 Sage Cloud Accounting Data Provider.
-
Visualize Live eBay Analytics Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live eBay Analytics data.
-
Use the CData Software ODBC Driver for Smartsheet in MicroStrategy Desktop
Connect to Smartsheet data in MicroStrategy Desktop using the CData Software ODBC Driver for Smartsheet.
-
Connect Azure Data Lake Storage to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Data Lake Storage with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Live Paylocity Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Paylocity from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Paylocity data.
-
Moving Data from Vault CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Vault CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Use a Microsoft Access Database to Update ADP Data in Real Time
Update ADP data by creating a linked table in Microsoft Access with the CData ADP ODBC Driver.
-
Natively Connect to Retently Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Retently data. Leverage the native support for ODBC in PHP.
-
A PostgreSQL Interface for HelloSign Data (MySQL Remoting via JDBC)
Use the Remoting features of the HelloSign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Add GitLab Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for GitLab with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Opsgenie Replication to Databricks
Use CData Sync for automated, continuous, customizable Opsgenie replication to Databricks.
-
Build Dashboards with Oracle SCM Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle SCM data in DBxtra.
-
Use CData Connect AI to Access Cvent Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Cvent data in the Power Pivot business intelligence tool.
-
Getting Started with the CData Python Connector for AdRoll
Learn to install and license the CData Python Connector and configure a connection to live AdRoll data.
-
How to Connect to Live Oracle SCM Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Oracle SCM data for you.
-
Automate Datadog Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Datadog data from PowerShell? This article demonstrates how to utilize the Datadog Cmdlets for tasks like connecting to Datadog data, automating operations, downloading data, and more.
-
Access Pipeline CRM Data from MySQL in Amazon QuickSight
Connect to Pipeline CRM and build visualizations of Pipeline CRM data using a MySQL Connection in Amazon QuickSight.
-
Connect to Mouseflow Data in DBeaver
Use the CData ODBC Driver to connect to Mouseflow data in DBeaver.
-
How to create Visio diagrams from SAP Ariba Source Data
Automatically update SAP Ariba Source data with the changes you make to Visio master shapes.
-
Create Informatica Mappings From/To an ODBC Data Source for SpaceX
Create an ODBC connection to SpaceX in Informatica and browse and transfer SpaceX data.
-
Build an OLAP Cube in SSAS from ZendeskSell Data
Establish a connection to ZendeskSell data data from SQL Server Analysis Services, and use the ZendeskSell Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to RSS Feeds from Crystal Reports
Use CData Connect AI to connect to and report on live RSS feeds from Crystal Reports.
-
Integrate Live Acumatica Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Acumatica data from within the IDE.
-
Integrate Procore Data in the Pentaho Report Designer
Publish reports based on Procore data in the Pentaho BI tool.
-
How to create Avalara AvaTax federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Avalara AvaTax data in MySQL .
-
Connect to Twitter Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live Twitter Ads data from Crystal Reports.
-
Connect to Dynamics 365 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Dynamics 365 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating Kiro with SAP Hybris C4C 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.