CData Software - Knowledge Base
Recent Articles
-
Use CData Connect AI to Access Vertica Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Vertica in the Power Pivot business intelligence tool.
-
Getting Started with the CData SSIS Components for Access
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Access.
-
How to create Visio diagrams from Reckon Accounts Hosted Data
Automatically update Reckon Accounts Hosted with the changes you make to Visio master shapes.
-
Build MVC Applications with Connectivity to Zoho CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho CRM from an ASP.NET MVC application.
-
Connect to Oracle SCM Data from a Connection Pool in Jetty
The Oracle SCM JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle SCM from Web apps in Jetty.
-
Connect to Box Data from a Connection Pool in Jetty
The Box JDBC Driver supports connection pooling: This article shows how to connect faster to Box from Web apps in Jetty.
-
Operational Reporting on Productboard Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Productboard.
-
Connect to Jira Assets Data in Ruby
Connect to Jira Assets in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData ODBC Driver for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Inventory.
-
Automated Continuous Flowlu Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Flowlu replication to IBM DB2.
-
How to Access Live Parquet Data in Visual Studio Code via Cline
Run CData MCP Server for Parquet on Windows Subsytem for Linux (WSL) and connect to live Apache Parquet from the Cline extension in Visual Studio Code.
-
Integrate Auth0 Data in Pentaho Data Integration
Build ETL pipelines based on Auth0 in the Pentaho Data Integration tool.
-
Analyze Attio Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Attio in Microsoft R Open.
-
Import Exact Online Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Exact Online Data and provide access to live Exact Online for custom reports in the Power BI Service.
-
Build Charts with Splunk Data in Clear Analytics
Create dynamic charts and perform analytics based on Splunk in Clear Analytics.
-
Build Data Flows from SQL Server to Microsoft Ads through SSIS
Easily push SQL Server data to Microsoft Ads using the CData SSIS Tasks for Microsoft Ads.
-
How to Connect Flowise AI Agents to Live Tally 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 Tally ERP without replication.
-
Integrating LlamaIndex with SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Fieldglass in real time.
-
Integrate Goose with Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Salesforce Pardot from within the local AI agent.
-
How to connect to Telegram Data with Squirrel SQL client
Connect to Telegram and execute queries in the Squirrel SQL Client.
-
Access Live FHIR 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 FHIR through MCP integration.
-
How to connect to MariaDB Data in DBVisualizer
Integrate MariaDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Trello Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Trello from Power Pivot. You will use the Table Import Wizard to load Trello. You can visually build the import query or use any SQL supported by the driver.
-
Build Adobe Analytics-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Adobe Analytics to explore live Adobe Analytics Data in GitHub Copilot to assist with building Adobe Analytics-powered applications.
-
ETL ActiveCampaign in Oracle Data Integrator
This article shows how to transfer ActiveCampaign into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Pinterest Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Pinterest replication to Google Cloud SQL.
-
Stream Nethunt Data into Apache Kafka Topics
Access and stream Nethunt in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to MailChimp Data from IntelliJ
Integrate connectivity to MailChimp with wizards in IntelliJ.
-
Automated Continuous Shopify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Shopify replication to AlloyDB.
-
Access Live Harvest Data in AWS Lambda
Connect to live Harvest in AWS Lambda using the CData JDBC Driver.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Facebook Ads actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Create SSAS Tabular Models from SharePoint Excel Services Data
How to build a SQL Server Analysis Service Tabular Model from SharePoint Excel Services using CData drivers.
-
Import WordPress Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to WordPress Data and provide access to live WordPress for custom reports in the Power BI Service.
-
Create SAP ByDesign-Connected Nintex Workflows
Use CData Connect AI to connect to SAP ByDesign Data from Nintex Workflow Cloud and build custom workflows using live SAP Business ByDesign.
-
Automate eBay Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access eBay Analytics from PowerShell? This article demonstrates how to utilize the eBay Analytics Cmdlets for tasks like connecting to eBay Analytics, automating operations, downloading data, and more.
-
Analyze SAP ByDesign Data in Cognos Analytics
Use CData Connect AI to connect to SAP ByDesign Data from Cognos Analytics and analyze live SAP Business ByDesign.
-
Integrating Codex CLI with Snapchat Ads 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.
-
Edit and Search External IBM Cloud Object Storage Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of IBM Cloud Object Storage to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create IBM Cloud Object Storage Data objects that you can access from apps and the dashboard.
-
Build SageHR-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SageHR and build web apps with connectivity to live SageHR.
-
Build a Singer.io Tap for Outlook With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Outlook data using
-
How to Connect the Power BI Service to Raisers Edge NXT: Complete Guide
Connect to the CData Software Power BI Connector for Raisers Edge NXT from PowerBI.com to provide real-time Raisers Edge NXT across the organization.
-
How to load GitHub data into Elasticsearch via Logstash
Introducing a simple method to load GitHub data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create SSAS Tabular Models from PagerDuty Data
How to build a SQL Server Analysis Service Tabular Model from PagerDuty using CData drivers.
-
How to Use a Microsoft Access Database to Update Amazon DynamoDB Data in Real Time
Update Amazon DynamoDB data by creating a linked table in Microsoft Access with the CData Amazon DynamoDB ODBC Driver.
-
Connect to Helpscout Data in RazorSQL
Connect to Helpscout from wizards and query Helpscout from the GUI in the RazorSQL database management tool.
-
How to integrate Tanda with Apache Airflow
Access and process Tanda in Apache Airflow using the CData JDBC Driver.
-
Access MailerSend Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MailerSend from your Oracle system.
-
Integrate with MarkLogic Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MarkLogic in SnapLogic.
-
How to Connect to Live Facebook Ads 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 Facebook Ads through natural language.
-
Automate Aweber Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Aweber from PowerShell? This article demonstrates how to utilize the Aweber Cmdlets for tasks like connecting to Aweber, automating operations, downloading data, and more.
-
Integrate SQL Server with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SQL Server with External Services.
-
Automate ConvertKit Data Replication to Azure Synapse
Use CData Sync to customize and automate ConvertKit replication to Azure Synapse.
-
How to Query Live Amplitude Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amplitude data in natural language using Python.
-
Automated Continuous SageHR Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SageHR replication to Amazon S3.
-
Integrate Cline with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Splunk from within your IDE.
-
Connect to LinkedIn Data from PowerBuilder via JDBC
This article demonstrates how to access LinkedIn from PowerBuilder using the LinkedIn JDBC Driver.
-
Connect ZeroBounce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZeroBounce using the CData Python MCP Server.
-
Import Redshift Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Redshift Data and provide access to live Amazon Redshift for custom reports in the Power BI Service.
-
Connect to SAP Data in Aqua Data Studio
Access SAP ERP/NetWeaver from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Add Omnisend Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Omnisend with the Informatica Enterprise Data Catalog to classify and organize data.
-
Easily Integrate ServiceNow Data in Lazarus Pascal IDE
Learn how to easily integrate live ServiceNow in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to SAP HANA XS Advanced in SpagoBI
Create reports featuring live SAP HANA XS Advanced in SpagoBI Studio. Host SAP HANA XS Advanced reports on SpagoBI Server.
-
Automated Continuous Oracle Financials Cloud Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to OneLake in Microsoft Fabric.
-
Connect to MarkLogic in SpagoBI
Create reports featuring live MarkLogic in SpagoBI Studio. Host MarkLogic reports on SpagoBI Server.
-
Bidirectional Access to HBase Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache HBase in Filemaker Pro for Mac or Windows.
-
Connecting GenSpark with SAP SuccessFactors Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP SuccessFactors without any replication or custom integration required.
-
Publish Coinbase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Coinbase.
-
Use JayDeBeApi to access Pushbullet Data in Python
Use standard Python scripting and the development environment of your choice to access live Pushbullet.
-
ETL Paylocity in Oracle Data Integrator
This article shows how to transfer Paylocity into a data warehouse using Oracle Data Integrator.
-
Bind Live SAP HANA Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA data
-
How to create Copper federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Copper in MySQL .
-
Visualize iContact Data in Sisense
Create an ElastiCube in Sisense app with access to iContact.
-
Connect to ServiceNow Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ServiceNow and the SQL Gateway to access ServiceNow from Google Apps Script.
-
Use the CData Software JDBC Driver for JobNimbus in MicroStrategy
Connect to JobNimbus in MicroStrategy Developer using the CData Software JDBC Driver for JobNimbus.
-
Use Dash to Build to Web Apps on Billsby Data
Create Python applications that use pandas and Dash to build Billsby-connected web apps.
-
Discourse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Discourse facts in real time.
-
Build Apps with Live Vault CRM Data Using the Low-Code Development Platform of Mendix
Connect Veeva Vault & Vault CRM with Mendix to build apps using the CData JDBC Driver for Vault CRM.
-
Automate Codat Data Replication to Azure Data Lake
Use CData Sync to customize and automate Codat replication to Azure Data Lake.
-
Automate Square Data Replication to Azure Synapse
Use CData Sync to customize and automate Square replication to Azure Synapse.
-
How to Query Live Authorize.Net Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Authorize.Net data in natural language using Python.
-
Integrating Claude Code CLI with Azure Data Catalog 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 Mocean to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mocean with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Google Ad Manager in MicroStrategy Web
Connect to Google Ad Manager in MicroStrategy Web using the CData Software ODBC Driver for Google Ad Manager.
-
Migrating data from OneNote to Snowflake using CData SSIS Components.
Easily push Microsoft OneNote to Snowflake using the CData SSIS Tasks for OneNote and Snowflake.
-
Automated Continuous Supabase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Supabase replication to Snowflake.
-
Automated Continuous Vault CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Vault CRM replication to PostgreSQL.
-
Create SSAS Tabular Models from Opsgenie Data
How to build a SQL Server Analysis Service Tabular Model from Opsgenie using CData drivers.
-
Connect to OData from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from OData, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Kafka Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache Kafka using standard SQL.
-
Access Live Active Directory Data in Coginiti Pro
Connect to and query live Active Directory from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Configure the CData JDBC Driver for Drift in a Connection Pool in Tomcat
Connect to Drift from a connection pool in Tomcat.
-
Analyze BigCommerce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of BigCommerce and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Cursor CLI with Contentful 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 ZarMoney Data in NetBeans
Connect to ZarMoney in NetBeans with the data source configuration wizard.
-
Automated API Data Replication to Teradata
Use CData Sync to Customize and automate API replication to Teradata.
-
How to Access Helpscout Data Using Entity Framework
This article shows how to access Helpscout using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live EmailOctopus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate EmailOctopus into the statistical analysis tools available in SAS JMP. This article shows how to use EmailOctopus in the Graph Builder and Query Builder.
-
Use ChatGPT to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your OData for you.
-
Integrating Antigravity CLI with Google Search via CData CLI
Connect Google Search to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate Multiple Printful Accounts via the CData Sync CLI
Replicate multiple Printful accounts to one or many databases.