CData Software - Knowledge Base
Recent Articles
-
Connect to Snapchat Ads Data from a Connection Pool in JBoss
Integrate Snapchat Ads into Java servlets: Use the Management Console in JBoss to install the Snapchat Ads JDBC Driver.
-
How to import Wistia Data into Apache Solr
Use the CData Software JDBC Driver for Wistia in Data Import Handler and create an automated import of Wistia to Apache Solr Enterprise Search platform.
-
Query SpaceX Data in DataGrip
Create a Data Source for SpaceX in DataGrip and use SQL to query live SpaceX.
-
How to Access Teamwork Data Using Entity Framework
This article shows how to access Teamwork using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Microsoft Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Ads from HeidiSQL.
-
Replicate Multiple Databricks Accounts via the CData Sync CLI
Replicate multiple Databricks accounts to one or many databases.
-
Automated Continuous SAP BusinessObjects BI Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to PostgreSQL.
-
Add FreeAgent Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for FreeAgent with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Data Visualizations Based On Snowflake Data in Mode
Use CData Connect AI to connect to Snowflake Data from Mode and build visualizations using live
-
Integrate MessageBird with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MessageBird with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MessageBird.
-
Visualize Adobe Analytics Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Adobe Analytics.
-
Integrate Cursor with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Marketo from within the editor.
-
Manage Odoo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Odoo.
-
How to Query Intercom Data in MySQL Workbench
Execute MySQL queries against live Intercom from MySQL Workbench.
-
Build a Singer.io Tap for Shopify With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Shopify data using
-
Connecting Moonlit Workflow with SAP Concur Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Concur in real time.
-
Visualize SAP Netweaver Gateway Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Netweaver Gateway.
-
Create a Data Access Object for LaunchDarkly Data using JDBI
A brief overview of creating a SQL Object API for LaunchDarkly in JDBI.
-
Natively Connect to Acumatica Data in PHP
The CData ODBC driver for Acumatica enables you to create PHP applications with connectivity to Acumatica ERP. Leverage the native support for ODBC in PHP.
-
How to create an RPA flow for Mode Data in UiPath Studio
Use the Mode ODBC Driver to create workflows that access real-time Mode without any coding.
-
Automated Continuous Wistia Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Wistia replication to PostgreSQL.
-
How to Connect to Live Google Cloud Storage Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Cloud Storage for you.
-
Connect to Google Sheets Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Sheets and the SQL Gateway to access Google Sheets from Google Apps Script.
-
Connect to SAS Data Sets Data in DBArtisan
Use wizards in DBArtisan to configure SAS Data Sets as a data source.
-
Getting Started with the CData Power BI Connector for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Reports with Paylocity Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paylocity.
-
Connect to Live Outreach.io Data in MicroStrategy through CData Connect AI
Create a live connection to Outreach.io Data in CData Connect AI and connect to your Outreach.io from MicroStrategy.
-
Connect to Zendesk Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zendesk Data and connect to Zendesk in Akorbi Digital RunMyProcess.
-
Create SSAS Tabular Models from SendInBlue Data
How to build a SQL Server Analysis Service Tabular Model from SendInBlue using CData drivers.
-
Build a PostgreSQL Interface for Sendwithus Data using the CData JDBC Driver
Use the Remoting features of the Sendwithus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Singer.io Tap for Zendesk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zendesk data using
-
Provide OData Services of SendGrid Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SendGrid by developing a WCF Service Application.
-
Integrate with live NetSuite SuiteAnalytics Data in Jitterbit
Use CData Connect AI to connect to and integrate live NetSuite SuiteAnalytics in Jitterbit.
-
Connect to Chargebee Data in RapidMiner
Integrate Chargebee with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Perplexity Data in ColdFusion
Write standard ColdFusion data access code to connect to Perplexity.
-
How to Connect DBeaver to Kafka via a JDBC Driver
Manage Apache Kafka with visual tools in DBeaver like the query browser.
-
Automated Continuous Google Search Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Search replication to Amazon S3.
-
Connect to Real-Time Notion Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Notion in Power Apps.
-
How to connect and process Adobe Commerce from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Commerce.
-
Back Up Sage 200 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage 200. In this article, we will employ an SSIS workflow to populate a database with Sage 200 data.
-
Integrate Confluence Data in the Pentaho Report Designer
Publish reports based on Atlassian Confluence in the Pentaho BI tool.
-
Build a Simple VCL Application for Redshift Data
How to build a simple VCL Application to view Amazon Redshift in RAD Studio using the CData ODBC Driver for Redshift.
-
Use the CData Software JDBC Driver for Avaza in MicroStrategy Web
Connect to Avaza in MicroStrategy Web using the CData Software JDBC Driver for Avaza.
-
Create QuickBooks Online-Connected Dashboards in Grafana
Connect to QuickBooks Online Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to QuickBooks Online.
-
Rapidly Develop eBay Analytics-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 eBay Analytics.
-
Access Teradata Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Teradata.
-
Use the CData Software ODBC Driver for ZarMoney in MicroStrategy
Connect to ZarMoney in MicroStrategy Developer using the CData Software ODBC Driver for ZarMoney.
-
Choosing the Best Method to Connect SharePoint Excel Services to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SharePoint Excel Services from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with PingOne Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PingOne.
-
Build Data Flows from Email to SQL Server using SSIS
Easily back up Email to SQL Server using the SSIS components for Email.
-
Access Live Close Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Close into the statistical analysis tools available in SAS JMP. This article shows how to use Close in the Graph Builder and Query Builder.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Gmail
Provide connectivity to Gmail through an SAP BusinessObjects universe.
-
Connect to PDFMonkey Data from a Connection Pool in Jetty
The PDFMonkey JDBC Driver supports connection pooling: This article shows how to connect faster to PDFMonkey from Web apps in Jetty.
-
Integrate with Klipfolio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Klipfolio to a JSON file on disk.
-
Getting Started with the CData JDBC Driver for Demio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Demio.
-
Enable the PingOne JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PingOne.
-
NuGet Repository Overview
CData is aware of a recently discovered malware published on nuget.org with package names designed to impersonate several vendor products, including CData.
-
Access Live NetSuite Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live NetSuite CRM & ERP from your Excel spreadsheets.
-
How to Connect DBeaver to Clari via a JDBC Driver
Manage Clari with visual tools in DBeaver like the query browser.
-
Query, Visualize, and Share live Jira Data in Redash
Use CData Connect AI to connect to live Atlassian Jira in Redash for querying, visualizing, and sharing.
-
Connect to Real-Time Zoom Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Zoom in Power Apps.
-
How to import Bright Data Data into Apache Solr
Use the CData Software JDBC Driver for Bright Data in Data Import Handler and create an automated import of Bright Data to Apache Solr Enterprise Search platform.
-
Analyze Splunk Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Splunk and visualize live Splunk in Infragistics Reveal.
-
Connect to SAP Ariba Source Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Ariba Source in FileMaker Pro to connect to SAP Ariba Source and work with SAP Ariba Source in your FileMaker applications.
-
Visualize Live Outreach.io Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Outreach.io using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Oracle HCM Cloud Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle HCM Cloud and the SQL Gateway to access Oracle HCM Cloud from Google Apps Script.
-
Publish Pipeline CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pipeline CRM.
-
Create SendInBlue Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SendInBlue data access from reports, embedded analytics, and more.
-
Create Dashboards and Visualize Live Outreach.io Data in Geckoboard
Use CData Connect AI to connect to live Outreach.io and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData Excel Add-In for Google Forms
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Forms.
-
How to connect to ZeroBounce Data with Squirrel SQL client
Connect to ZeroBounce and execute queries in the Squirrel SQL Client.
-
Analyze MarkLogic Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MarkLogic with the CData JDBC Driver for MarkLogic.
-
Replicate Active Directory Data from PowerShell
Write a quick PowerShell script to query Active Directory. Use connectivity to the live data to replicate Active Directory to SQL Server.
-
Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy Desktop
Connect to Sugar CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Sugar CRM.
-
LINQ to Browserless 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 Browserless Data Provider.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for IBM Informix
Provide connectivity to IBM Informix through an SAP BusinessObjects universe.
-
Deploy the ADO.NET Provider for Shippo on an SSRS Report Server
Connect to Shippo from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Bullhorn CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Bullhorn CRM and build Bullhorn CRM-connected web apps with Axios.
-
How to Visualize Spotify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Spotify in Python.
-
How to create Visio diagrams from Box Data
Automatically update Box with the changes you make to Visio master shapes.
-
Integrating GitHub Copilot CLI with Square 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.
-
DataBind Controls to Dropbox Data in C++Builder
DataBind to Dropbox in C++Builder with standard components and controls.
-
Integrate Salesforce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesforce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesforce & Force.com.
-
How to Connect to Live Facebook Ads 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 Facebook Ads for you.
-
Visualize Live Omnisend Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Omnisend using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Real-Time Microsoft Teams Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Teams in ColdFusion.
-
Access Live Azure Synapse Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Azure Synapse data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build MVC Applications with Connectivity to SAS Data Sets Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAS Data Sets from an ASP.NET MVC application.
-
Publish Amazon DynamoDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Amazon DynamoDB.
-
Build Greenplum-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Pivotal GreenPlum and build Greenplum-connected web apps with Axios.
-
Viewing AgileCRM Data in RAD Studio Data Explorer
How to view AgileCRM in RAD Studio Data Explorer using the CData ODBC Driver for AgileCRM.
-
Build Google Contacts Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Contacts and build visualizations in Tableau Cloud.
-
Migrating data from Aweber to Snowflake using CData SSIS Components.
Easily push Aweber to Snowflake using the CData SSIS Tasks for Aweber and Snowflake.
-
Create Reports from NetSuite SuiteAnalytics Data in Looker Studio
Use CData Connect AI to gain access to live NetSuite SuiteAnalytics and create custom reports in Looker Studio.
-
Create PDFMonkey Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PDFMonkey from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to QuickBooks Online Data in HULFT Integrate
Connect to QuickBooks Online as a JDBC data source in HULFT Integrate
-
Object-Relational Mapping (ORM) with CampaignMonitor 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 CampaignMonitor into a Java-based ORM framework, Hibernate.
-
How to Access LinkedIn Ads Data Using Entity Framework
This article shows how to access LinkedIn Ads using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to Live Salesforce Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Salesforce & Force.com for you.
-
Integrate Yelp Data in the Pentaho Report Designer
Publish reports based on Yelp in the Pentaho BI tool.