CData Software - Knowledge Base
Recent Articles
-
LINQ to ConstantContact 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 ConstantContact Data Provider.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Mixpanel
Provide connectivity to Mixpanel through an SAP BusinessObjects universe.
-
Integrating Gumloop with Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce Marketing Cloud within automated workflows.
-
Create Data Visualizations in Cognos BI with Datadog Data
Access Datadog as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Using the CData Software ODBC Driver for Azure Synapse in PyCharm
Connect to Azure Synapse as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Synapse.
-
Analyze QuickBooks Time Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze QuickBooks Time with the CData JDBC Driver for QuickBooks Time.
-
Getting Started with the CData SSIS Components for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Blackbaud FE NXT.
-
Query Live ADP 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 ADP directly from the development environment.
-
Automated Continuous Amazon Marketplace Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Amazon S3.
-
Connect to Typeform in SpagoBI
Create reports featuring live Typeform in SpagoBI Studio. Host Typeform reports on SpagoBI Server.
-
Import Real-Time Tickspot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Tickspot in ColdFusion.
-
DataBind Controls to Marketo Data in Delphi
DataBind to Marketo in Delphi with standard data access components and controls.
-
Connect to Vimeo Data in RapidMiner
Integrate Vimeo with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect DBeaver to Oracle Sales via a JDBC Driver
Manage Oracle Sales with visual tools in DBeaver like the query browser.
-
Connect to Avalara AvaTax Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Avalara AvaTax.
-
Connect to Office 365 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Office 365 in FileMaker Pro to connect to Office 365 and work with Microsoft Office 365 in your FileMaker applications.
-
Replicate Multiple Calendly Accounts via the CData Sync CLI
Replicate multiple Calendly accounts to one or many databases.
-
Integrating Wrike Data in Talend Cloud Data Management Platform
Connect Wrike Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Prepare, Blend, and Analyze SAP Ariba Procurement Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Ariba Procurement for self-service data analytics.
-
Replicate Aweber Data in Heroku for Use in Salesforce Connect
Replicate Aweber to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Visualize Live Google Ad Manager Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Ad Manager.
-
How to Import Data from Workday into Google Sheets
Import Workday into a Google spreadsheet that is automatically refreshed.
-
How to Connect DBeaver to Paylocity via a JDBC Driver
Manage Paylocity with visual tools in DBeaver like the query browser.
-
Connect to LinkedIn Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for LinkedIn Ads Data and connect to LinkedIn Ads in Akorbi Digital RunMyProcess.
-
Connect to Adobe Analytics Data in Jaspersoft Studio
Execute SQL to remote Adobe Analytics in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy
Connect to Sage Business Cloud Accounting in MicroStrategy Developer using the CData Software ODBC Driver for Sage Cloud Accounting.
-
Access SharePoint Data from MySQL in Amazon QuickSight
Connect to SharePoint and build visualizations of Microsoft SharePoint using a MySQL Connection in Amazon QuickSight.
-
How to publish and share PayPal Data dashboards with Tableau Server
The CData ODBC driver for PayPal enables you integrate PayPal into Tableau dashboards.
-
Build Data Flows from HubDB to SQL Server using SSIS
Easily back up HubDB to SQL Server using the SSIS components for HubDB.
-
Use the CData Software JDBC Driver for Kafka in MicroStrategy
Connect to Apache Kafka in MicroStrategy Developer using the CData Software JDBC Driver for Kafka.
-
Integrating Antigravity CLI with VWO via CData CLI
Connect VWO to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use JayDeBeApi to access Google Forms Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Forms.
-
Getting Started with the CData Power BI Connector for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to FreeAgent Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FreeAgent.
-
Build MVC Applications with Connectivity to Odoo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Odoo from an ASP.NET MVC application.
-
Access Hive Data from MySQL in Amazon QuickSight
Connect to Hive and build visualizations of Apache Hive using a MySQL Connection in Amazon QuickSight.
-
Easily Integrate Greenplum Data in Lazarus Pascal IDE
Learn how to easily integrate live Pivotal GreenPlum in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for ChartMogul in MicroStrategy
Connect to ChartMogul in MicroStrategy Developer using the CData Software JDBC Driver for ChartMogul.
-
Automated Mailjet Data Replication to Teradata
Use CData Sync to Customize and automate Mailjet replication to Teradata.
-
Migrating data from Square to Snowflake using CData SSIS Components.
Easily push Square to Snowflake using the CData SSIS Tasks for Square and Snowflake.
-
Build a PostgreSQL Interface for Parallel Data using the CData JDBC Driver
Use the Remoting features of the Parallel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Productboard Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Productboard in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live SAS Data Sets 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 SAS Data Sets through natural language.
-
How to Connect Flowise AI Agents to Live Google Contacts 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 Google Contacts without replication.
-
Integrate Wrike with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Wrike with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Wrike.
-
Connect to Zoho Creator Data from a Connection Pool in JBoss
Integrate Zoho Creator into Java servlets: Use the Management Console in JBoss to install the Zoho Creator JDBC Driver.
-
Build AI Agents with Stripe Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Stripe through CData Connect AI.
-
Build a PostgreSQL Interface for Sage Cloud Accounting Data using the CData JDBC Driver
Use the Remoting features of the Sage Cloud Accounting JDBC Driver to create a PostgreSQL entry-point for data access.
-
Process & Analyze CapsuleCRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CapsuleCRM Data.
-
Publish ShipEngine-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ShipEngine.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cloudant
Provide connectivity to IBM Cloudant through an SAP BusinessObjects universe.
-
Analyze SAP Concur Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Concur with the CData JDBC Driver for SAP Concur.
-
Trigger WooCommerce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for WooCommerce with standard wizards in Logic Apps.
-
Edit and Search External Oracle Eloqua Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle Eloqua to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle Eloqua Data objects that you can access from apps and the dashboard.
-
Analyze Opsgenie Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Opsgenie with the CData JDBC Driver for Opsgenie.
-
Access Recurly Data from MySQL in Amazon QuickSight
Connect to Recurly and build visualizations of Recurly using a MySQL Connection in Amazon QuickSight.
-
Visualize Figshare Data in Tableau
The CData ODBC driver for Figshare enables you integrate Figshare into Tableau dashboards.
-
How to Connect to Typeform Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Typeform. Leverage the pyodbc module for ODBC in Python.
-
How to Query Live Email Data in Perplexity MacOS Desktop
Connect to and query live Email Data in Perplexity Desktop using CData MCP Server.
-
How to Create Power BI Visual Reports with Real-Time Facebook Data
Use CData Power BI Connectors to visualize Facebook in Power BI.
-
Automate Teamwork Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Teamwork from PowerShell? This article demonstrates how to utilize the Teamwork Cmdlets for tasks like connecting to Teamwork, automating operations, downloading data, and more.
-
Visualize Instantly Data in TIBCO Spotfire through ADO.NET
Integrate Instantly into dashboards in TIBCO Spotfire.
-
Integrating OpenCode Terminal with Attio 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.
-
Automate IBM Informix Data Replication to SAP HANA
Use CData Sync to customize and automate IBM Informix replication to SAP HANA.
-
Use Biml to Build SSIS Tasks to Replicate Act-On Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Act-On to SQL Server.
-
Access Shortcut Data from MySQL in Amazon QuickSight
Connect to Shortcut and build visualizations of Shortcut using a MySQL Connection in Amazon QuickSight.
-
Integrating Accelo Data in Talend Cloud Data Management Platform
Connect Accelo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
A PostgreSQL Interface for Kintone Data using the CData ODBC Driver
Use the SQL Gateway and Kintone ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations in Cognos BI with PagerDuty Data
Access PagerDuty as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Access Live Trello Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Trello enables you to integrate Trello into workflows built using Microsoft Power Automate Desktop.
-
Build an OLAP Cube in SSAS from Campaigner Data
Establish a connection to Campaigner data from SQL Server Analysis Services, and use the Campaigner Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Oracle Financials Cloud Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle Financials Cloud.
-
Prepare, Blend, and Analyze Oracle Sales Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Sales for self-service data analytics.
-
Create Datasets from RabbitMQ in Domo Workbench and Build Visualizations of RabbitMQ Data in Domo
Use the CData Software ODBC Driver for RabbitMQ to create datasets from RabbitMQ in Domo Workbench and then build visualizations in the Domo service.
-
Natively Connect to Google Sheets Data in PHP
The CData ODBC driver for Google Sheets enables you to create PHP applications with connectivity to Google Sheets. Leverage the native support for ODBC in PHP.
-
Access Live Sybase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sybase into the statistical analysis tools available in SAS JMP. This article shows how to use Sybase in the Graph Builder and Query Builder.
-
How to Connect to Live Microsoft Exchange Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Exchange securely in real time.
-
Edit and Search External GitLab Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of GitLab to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create GitLab Data objects that you can access from apps and the dashboard.
-
Connect to Tavily Data in DBeaver
Use the CData ODBC Driver to connect to Tavily in DBeaver.
-
Automated Continuous xBase Replication to Snowflake
Use CData Sync for automated, continuous, customizable xBase replication to Snowflake.
-
How to connect PolyBase to Discourse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Discourse.
-
Integrating Cursor CLI with PolarTeamPro 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 ChatGPT to Talk to Your Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Azure Analysis Services for you.
-
Integrate Real-Time Access to Kafka in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Kafka in real time.
-
Automated Continuous Kafka Replication to Vertica
Use CData Sync for automated, continuous, customizable Kafka replication to Vertica.
-
Publish Crystal Reports on SAS Data Sets Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAS Data Sets.
-
Build Automated SAP Ariba Source-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Ariba Source and build automated workflows in Zapier.
-
Build an OLAP Cube in SSAS from Facebook Data
Establish a connection to Facebook data from SQL Server Analysis Services, and use the Facebook Data Provider to build OLAP cubes for use in analytics and reporting.
-
Extract, Transform, and Load Optimizely Data in Informatica PowerCenter
Create a simple Workflow for Optimizely in Informatica PowerCenter.
-
Use the CData Software ODBC Driver for Sybase in SAS for Real-Time Reporting and Analytics
Connect to real-time Sybase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sybase.
-
Create SharePoint Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SharePoint from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Splunk-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Splunk to explore live Splunk Data in GitHub Copilot to assist with building Splunk-powered applications.
-
How to Seamlessly Import Delighted Data into IBM SPSS Modeler
Integrate Delighted data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Reckon Accounts Hosted Replication to SQL Server
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SQL Server.
-
Build AI/ML Models with Live ConvertKit Data using Dataiku
Connect ConvertKit Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Dataiku with Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Teams.
-
Automated Continuous Sage 300 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sage 300 replication to SQL Server.
-
Access Discord 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 Discord.
-
Load LionDesk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LionDesk to a database.
-
Create Avalara AvaTax-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Avalara AvaTax Data from Klipfolio and build custom visualizations using live Avalara AvaTax.