CData Software - Knowledge Base
Recent Articles
-
How to connect to WordPress Data from IntelliJ
Integrate connectivity to WordPress with wizards in IntelliJ.
-
Integrating LangChain with Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoho Inventory within automated workflows.
-
Connect to Salesforce Data 360 Data in DBArtisan
Use wizards in DBArtisan to configure Salesforce Data 360 as a data source.
-
Getting Started with the CData Excel Add-In for GetResponse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GetResponse.
-
Connect to HCL Domino Data in DBArtisan
Use wizards in DBArtisan to configure HCL Domino as a data source.
-
Getting Started with the CData SSIS Components for Egnyte
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Egnyte.
-
Build BigQuery-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for BigQuery to explore live BigQuery Data in Claude Code to assist with building BigQuery-powered applications.
-
Write a Simple Go Application to work with Microsoft Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Ads.
-
Connect Salesforce Marketing to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesforce Marketing with IBM WebSphere for seamless data integration and connectivity.
-
How to create Visio diagrams from Salesforce Data
Automatically update Salesforce & Force.com with the changes you make to Visio master shapes.
-
Create Dashboards and Visualize Live Azure Data Lake Storage Data in Geckoboard
Use CData Connect AI to connect to live Azure Data Lake Storage and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Guru Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Guru from your Oracle system.
-
Using the CData Software ODBC Driver for Parallel in PyCharm
Connect to Parallel as an ODBC data source in PyCharm using the CData Software ODBC Driver for Parallel.
-
Build Data Flows from Mistral AI to SQL Server using SSIS
Easily back up Mistral AI to SQL Server using the SSIS components for Mistral AI.
-
Bridge Autopilot Connectivity with Apache NiFi
Access and process Autopilot in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Instagram in MicroStrategy Desktop
Connect to Instagram in MicroStrategy Desktop using the CData Software JDBC Driver for Instagram.
-
DataBind Controls to Teamwork Data in C++Builder
DataBind to Teamwork in C++Builder with standard components and controls.
-
Visualize Spark 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 Apache Spark SQL into TIBCO Spotfire.
-
How to connect to SAP SuccessFactors Data with Squirrel SQL client
Connect to SAP SuccessFactors and execute queries in the Squirrel SQL Client.
-
Excel Spreadsheet Automation on MYOB AccountRight Data with the QUERY Formula
Pull data from MYOB AccountRight, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Grafana Replication to SQLite
Use CData Sync for automated, continuous, customizable Grafana replication to SQLite.
-
Access Live FormSite Data in AWS Lambda
Connect to live FormSite in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Google Campaign Manager 360 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 Google Campaign Manager 360 through natural language.
-
How to Design Dynamics CRM Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Dynamics CRM from mobile and tablet Power Apps.
-
Build Dashboards with Impala Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Impala in Dundas BI.
-
Access Live Sybase Data in Excel 365 Online (Excel for the web)
Connect to Sybase from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Azure Synapse Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Synapse.
-
How to create Visio diagrams from Sage Cloud Accounting Data
Automatically update Sage Business Cloud Accounting with the changes you make to Visio master shapes.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Snapchat Ads using the Model Context Protocol.
-
How to Work with OData Services in AWS Glue Jobs Using JDBC
Connect to OData from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Apps from Google Campaign Manager 360 Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Campaign Manager 360 Data and build apps from live Google Campaign Manager 360 in Qlik Sense Cloud.
-
Connect to Live Highrise Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Highrise in CData Connect AI and connect to your Highrise CRM from PostgreSQL.
-
Connect to YouTube Analytics Data from AWS Glue
Use CData Connect AI to gain access to live YouTube Analytics from your AWS Glue jobs.
-
Connect to Rebilly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Rebilly in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData JDBC Driver for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Raisers Edge NXT.
-
Build Semantic Layer Views for ActiveCampaign Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ActiveCampaign.
-
Connect to Microsoft Exchange Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Exchange in Google Apps Script.
-
Connect to Shopify Data from AWS Glue
Use CData Connect AI to gain access to live Shopify from your AWS Glue jobs.
-
Manage Asana Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Asana.
-
Provide OData Services of Confluence Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Atlassian Confluence by developing a WCF Service Application.
-
Access Live Freshdesk Data in TIBCO Data Virtualization
Use the Freshdesk Tibco DV Adapter to create a Freshdesk data source in TIBCO Data Virtualization Studio and gain access to live Freshdesk from your TDV Server.
-
Automated Continuous Bitbucket Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bitbucket replication to MongoDB.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Dropbox to Power BI dashboards. Simply drag and drop Dropbox into data visuals on the Power BI canvas.
-
Query Close Data in DataGrip
Create a Data Source for Close in DataGrip and use SQL to query live Close.
-
Connect to Tavily Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Tavily.
-
Connect to Figshare from a Connection Pool in WebLogic
Use the CData JDBC Driver for Figshare to connect to Figshare from Web applications running on WebLogic.
-
Automated Continuous Intercom Replication to Oracle
Use CData Sync for automated, continuous, customizable Intercom replication to Oracle.
-
Build Pipelines with Live WooCommerce Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to WooCommerce from Google Cloud Data Fusion, enabling the integration of live WooCommerce into the building and management of effective data pipelines.
-
Visualize REST Data in TIBCO Spotfire through ADO.NET
Integrate REST into dashboards in TIBCO Spotfire.
-
Feed Google Spanner Data into FineReport
How to set Google Spanner as a JDBC data source in FineReport.
-
Automate QuickBooks Time Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Time and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Work with Printify Data in ETL Validator JDBC
Connect to Printify from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate CouchDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache CouchDB replication to Azure Data Lake.
-
Host the API Server on Heroku
Host the CData API Servers in Heroku Cloud Application Platform.
-
A PostgreSQL Interface for Workday Data using the CData ODBC Driver
Use the SQL Gateway and Workday ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Azure Table Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Table Storage.
-
How to Query Microsoft Teams Data in MySQL Workbench
Execute MySQL queries against live Microsoft Teams from MySQL Workbench.
-
Visualize Excel Online Data in TIBCO Spotfire through OData
Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.
-
Visualize Apify Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apify.
-
Build MVC Applications with Connectivity to Klipfolio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Klipfolio from an ASP.NET MVC application.
-
Use Microsoft Copilot Studio to talk to your Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Square for you.
-
How to Access Live Discord Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Discord enables you to integrate Discord into workflows built using Microsoft Power Automate Desktop.
-
How to Query DocuSign Data in MySQL Workbench
Execute MySQL queries against live DocuSign from MySQL Workbench.
-
Build Quickbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Quickbase and build web apps with connectivity to live Quickbase.
-
Query Perigon Data in DataGrip
Create a Data Source for Perigon in DataGrip and use SQL to query live Perigon.
-
Connect to SendInBlue Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SendInBlue as an External Source in Dremio.
-
Use JayDeBeApi to access Dynamics CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Dynamics CRM.
-
Build Data Flows from Toggl to SQL Server using SSIS
Easily back up Toggl to SQL Server using the SSIS components for Toggl.
-
Query ADP Data from Node.js
Use the OData endpoint of the CData API Server to connect to your ADP and perform CRUD operations on ADP from Node.js.
-
Connect to Shopify Data in Google Apps Script via Connect AI
Use CData Connect AI to access Shopify in Google Apps Script.
-
Replicate Multiple Pipeliner CRM Accounts
Replicate multiple Pipeliner CRM accounts to one or many databases.
-
Integrate with Stack Exchange Data in JReport Designer
Create charts and reports based on Stack Exchange in JReport Designer.
-
Write a Simple Go Application to work with Basecamp Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Basecamp.
-
Use the CData Software ODBC Driver for Moosend in SAS for Real-Time Reporting and Analytics
Connect to real-time Moosend in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Moosend.
-
Connect to Zoho Recruit Data from a Connection Pool in Jetty
The Zoho Recruit JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho Recruit from Web apps in Jetty.
-
Use the CData Software ODBC Driver for ConstantContact in MicroStrategy Web
Connect to ConstantContact in MicroStrategy Web using the CData Software ODBC Driver for ConstantContact.
-
Create SharePoint Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SharePoint data access from reports, embedded analytics, and more.
-
Access Google Translate Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Translate from your Oracle system.
-
Connect to Workday Data in Google Apps Script via Connect AI
Use CData Connect AI to access Workday in Google Apps Script.
-
Automated Jira Data Replication to Teradata
Use CData Sync to Customize and automate Atlassian Jira replication to Teradata.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sage 200 to Power BI dashboards. Simply drag and drop Sage 200 into data visuals on the Power BI canvas.
-
How to create Basecamp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Basecamp in MySQL .
-
How to Connect BigCommerce 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 BigCommerce data in real time using natural language.
-
Connect to Real-Time Adobe Analytics Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Adobe Analytics and Dataflow to import and use Adobe Analytics in Power Apps.
-
How to publish and share Sage 200 Data dashboards with Tableau Server
The CData ODBC driver for Sage 200 enables you integrate Sage 200 into Tableau dashboards.
-
Connect to Okta Data from Crystal Reports
Use CData Connect AI to connect to and report on live Okta from Crystal Reports.
-
Connect to Webex Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Webex in the Denodo Virtual DataPort Administrator.
-
Integrate Theia IDE with Live SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Process & Analyze Email Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Email Data.
-
LINQ to Oracle Eloqua 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 Oracle Eloqua Data Provider.
-
How to Access Live Spark Data in Visual Studio Code via Cline
Run CData MCP Server for Spark on Windows Subsytem for Linux (WSL) and connect to live Apache Spark SQL from the Cline extension in Visual Studio Code.
-
Create LinkedIn Ads-Connected Dashboards in Grafana
Connect to LinkedIn Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to LinkedIn Ads.
-
Build Dashboards with Mouseflow Data in DBxtra
Create dynamic dashboards and perform analytics based on Mouseflow in DBxtra.
-
Visualize Live Oracle Eloqua Reporting Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle Eloqua Reporting.
-
Connecting Agentforce with LinkedIn Ads 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 LinkedIn Ads for you.
-
Connect to Zendesk Data in Jaspersoft Studio
Execute SQL to remote Zendesk in Jaspersoft Studio.
-
Query Typeform Data in DataGrip
Create a Data Source for Typeform in DataGrip and use SQL to query live Typeform.
-
Connect to Odoo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Odoo ERP in the Denodo Virtual DataPort Administrator.
-
Explore Geographical Relationships in Superchat Data with Power Map
Create data visualizations with Superchat in Power Map.
-
Integrate Live Invoiced Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Invoiced to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.