CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Bitly 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 Bitly data without replication.
-
Connect to Float Data in CloverDX (formerly CloverETL)
Transfer Float data using the visual workflow in the CloverDX data integration tool.
-
Create Reports from Reckon Data in Looker Studio
Use CData Connect AI to gain access to live Reckon data and create custom reports in Looker Studio.
-
Access Live Odoo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Odoo data from your Excel spreadsheets.
-
Creating Google Calendar-Connected Applications in Unqork
You can use CData Connect AI to feed Google Calendar data to Unqork and build custom business apps.
-
Load SparkPost Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SparkPost data to a database.
-
Automated Continuous Toggl Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Toggl replication to delimited files (CSV/TSV).
-
Consume Instagram OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Instagram feeds that reflect any changes in SAP Lumira.
-
Access Live Redshift Data in AWS Lambda
Connect to live Redshift data in AWS Lambda using the CData JDBC Driver.
-
A PostgreSQL Interface for Facebook Data using the CData ODBC Driver
Use the SQL Gateway and Facebook ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Agno to Talk to Your Attio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Attio data for you.
-
Automate SAP HANA Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP HANA data replication to Azure Data Lake.
-
Build an OLAP Cube in SSAS from ZohoExpense Data
Establish a connection to ZohoExpense data data from SQL Server Analysis Services, and use the ZohoExpense Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous DocuSign Replication to SingleStore
Use CData Sync for automated, continuous, customizable DocuSign replication to SingleStore.
-
Validate SFTP Data with QuerySurge
Access and validate SFTP data in QuerySurge using the CData JDBC Driver.
-
Analyze Calendly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Calendly from Power Pivot. You will use the Table Import Wizard to load Calendly data. You can visually build the import query or use any SQL supported by the driver.
-
Import Kintone Data Using Azure Data Factory
Use CData Connect AI to connect to Kintone Data from Azure Data Factory and import live Kintone data.
-
Use the CData Software JDBC Driver for SharePoint Excel Services in MicroStrategy Desktop
Connect to SharePoint Excel Services data in MicroStrategy Desktop using the CData Software JDBC Driver for SharePoint Excel Services.
-
How to publish and share Sage Intacct Data dashboards with Tableau Server
The CData ODBC driver for Sage Intacct enables you integrate Sage Intacct data into Tableau dashboards.
-
Automated Continuous Redis Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Redis replication to delimited files (CSV/TSV).
-
Connect to Webflow Data from a Connection Pool in JBoss
Integrate Webflow data into Java servlets: Use the Management Console in JBoss to install the Webflow JDBC Driver.
-
Connect to Anaplan in SpagoBI
Create reports featuring live Anaplan data in SpagoBI Studio. Host Anaplan reports on SpagoBI Server.
-
Transfer Google Contacts to Dynamics CRM
Never manually copy your Google contacts into CRM again! With the CData SSIS components, you can automatically synchronize Dynamics CRM with your customer and lead information no matter where it resides, without manually copying data.
-
How to update SendGrid from Excel
This article explains how to transfer data from Excel to SendGrid using the Excel Add-In for SendGrid.
-
Create SSAS Tabular Models from ZohoPeople Data
How to build a SQL Server Analysis Service Tabular Model from ZohoPeople data using CData drivers.
-
Replicate SharePoint Data to Multiple Databases
Replicate SharePoint data to disparate databases with a point-and-click configuration.
-
Getting Started with the CData ODBC Driver for Printful
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Printful.
-
Integrating LangGraph with Greenhouse Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Greenhouse data within automated workflows.
-
Import Real-Time Mocean Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mocean data in ColdFusion.
-
Viewing Snapchat Ads Data in RAD Studio Data Explorer
How to view Snapchat Ads data in RAD Studio Data Explorer using the CData ODBC Driver for Snapchat Ads.
-
Access QuickBooks Time Data from MySQL in Amazon QuickSight
Connect to QuickBooks Time and build visualizations of QuickBooks Time data using a MySQL Connection in Amazon QuickSight.
-
Prepare, Blend, and Analyze BambooHR Data in Alteryx Designer (Connect AI)
Build workflows to access live BambooHR data for self-service data analytics.
-
Access Live Zoho Projects 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 Zoho Projects data through MCP integration.
-
Visualize Live Sugar CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sugar CRM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build MVC Applications with Connectivity to Discord Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Discord from an ASP.NET MVC application.
-
Build Dashboards with Oracle SCM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle SCM data in Dundas BI.
-
Replicate Multiple FreeAgent Accounts via the CData Sync CLI
Replicate multiple FreeAgent accounts to one or many databases.
-
Replicate Sybase IQ Data from PowerShell
Write a quick PowerShell script to query Sybase IQ data. Use connectivity to the live data to replicate Sybase IQ data to SQL Server.
-
How to use SQLAlchemy ORM to access Calendly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Calendly data.
-
Access Workday Data from MySQL in Amazon QuickSight
Connect to Workday and build visualizations of Workday data using a MySQL Connection in Amazon QuickSight.
-
Connecting Pipedream with AgileCRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on AgileCRM data in real time.
-
Access Live Snowflake Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Snowflake data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Replicate Multiple PhantomBuster Accounts via the CData Sync CLI
Replicate multiple PhantomBuster accounts to one or many databases.
-
Working with Printful Data in LINQPad
Execute LINQ queries to Printful data in LINQPad.
-
How to connect to Samanage Data from IntelliJ
Integrate connectivity to Samanage data with wizards in IntelliJ.
-
Connect to ChargeOver Data in JRuby
Create a simple JRuby app with access to live ChargeOver data.
-
How to Visualize CockroachDB Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live CockroachDB data in Python.
-
Provide OData Services of Yelp Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Yelp data by developing a WCF Service Application.
-
Query Snapchat Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Snapchat Ads data from Node.js.
-
Use the CData ODBC Driver for MailChimp from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MailChimp to connect to MailChimp data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MailChimp data in Excel.
-
How to Work with Google Cloud Storage Data in ETL Validator JDBC
Connect to Google Cloud Storage from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Pipedrive Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Pipedrive data for you.
-
Connect to Shopify Data from HeidiSQL
Use CData Connect AI to connect to and query live Shopify data from HeidiSQL.
-
DataBind Controls to Amazon Athena Data in C++Builder
DataBind to Amazon Athena data in C++Builder with standard components and controls.
-
Getting Started with the CData Python Connector for Sage Intacct
Learn to install and license the CData Python Connector and configure a connection to live Sage Intacct data.
-
Analyze Live Yelp Data in SAS Viya
Use CData Connect AI to connect to Yelp data from SAS Viya and deploy self-service analytics using live Yelp data.
-
Create Power BI Reports on Real-Time Highrise Data
Use the CData ODBC Driver for Highrise to visualize Highrise data in Power BI Desktop.
-
Visualize Live SurveyMonkey Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SurveyMonkey data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Pinterest Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Pinterest with the DevExpress Windows Forms and Web controls to provide Pinterest data to a chart.
-
How to Connect the Power BI Service to BigCommerce: Complete Guide
Connect to the CData Software Power BI Connector for BigCommerce from PowerBI.com to provide real-time BigCommerce data across the organization.
-
Building Dynamic Web Pages with Google Spanner Data Using AngularJS
Create single-page applications with live connectivity to Google Spanner using the CData API Server.
-
Use the CData Software ODBC Driver for MailerLite in MicroStrategy Desktop
Connect to MailerLite data in MicroStrategy Desktop using the CData Software ODBC Driver for MailerLite.
-
Provide OData Services of Salesloft Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesloft data by developing a WCF Service Application.
-
Build an OLAP Cube in SSAS from WooCommerce Data
Establish a connection to WooCommerce data data from SQL Server Analysis Services, and use the WooCommerce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Office 365-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Office 365 data and build web apps with connectivity to live Office 365 data.
-
Build Airtable-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Airtable Data and create custom apps in Mendix.
-
Choosing the Best Method to Connect Greenplum to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Greenplum data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to use SQLAlchemy ORM to access Bullhorn CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bullhorn CRM data.
-
Migrating data from BambooHR to Google BigQuery using CData SSIS Components.
Easily push BambooHR data to Google BigQuery using the CData SSIS Tasks for BambooHR and Google BigQuery.
-
Connect to Attio Data in DBeaver
Use the CData ODBC Driver to connect to Attio data in DBeaver.
-
Getting Started with the CData Python Connector for Cloudant
Learn to install and license the CData Python Connector and configure a connection to live Cloudant data.
-
How to connect to PagerDuty Data from IntelliJ
Integrate connectivity to PagerDuty data with wizards in IntelliJ.
-
Analyze HubSpot Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of HubSpot data and visualize live HubSpot data in Infragistics Reveal.
-
DataBind ChargeOver Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ChargeOver data to a chart.
-
Build Testmonitor Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Testmonitor data and build visualizations in Tableau Cloud.
-
Process & Analyze Figshare Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Figshare Data.
-
Query ZohoSubscriptions Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoSubscriptions data.
-
Use the CData ODBC Driver for Cloudant in Microsoft Power Query
You can use the CData Cloudant ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Cloudant data into Microsoft Power Query.
-
Freshteam Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Freshteam facts in real time.
-
Edit and Search External Dynamics 365 Business Central Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Dynamics 365 Business Central data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics 365 Business Central Data objects that you can access from apps and the dashboard.
-
Connect to MySQL Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MySQL as an External Source in Dremio.
-
Connect to Azure Table Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Table data in the Denodo Virtual DataPort Administrator.
-
How to connect to Bitbucket Data with Squirrel SQL client
Connect to Bitbucket data and execute queries in the Squirrel SQL Client.
-
Replicate Mode Data to Multiple Databases via the CData Sync CLI
Replicate Mode data to disparate databases with a single configuration.
-
Analyze Live Google Ads Data in SAS Viya
Use CData Connect AI to connect to Google Ads data from SAS Viya and deploy self-service analytics using live Google Ads data.
-
Explore Geographical Relationships in Google Calendar Data with Power Map
Create data visualizations with Google Calendar data in Power Map.
-
Manage Nethunt Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Nethunt.
-
Connect to and Query Postmark Data in QlikView over ODBC
Create data visualizations with Postmark data in QlikView.
-
How to connect Amazon QuickSight to Reckon Accounts Hosted Data
Create a connection to Reckon Accounts Hosted data in CData Connect AI and insert Reckon Accounts Hosted data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Gumloop with Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Wave Financial data within automated workflows.
-
How to connect to Bannerbear Data from Spring Boot
Connect to Bannerbear in a Spring Boot Application using the CData API Driver for JDBC
-
Use ChatGPT to Talk to Your Dynamics 365 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 Dynamics 365 data for you.
-
Automated Continuous Square Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Square replication to AlloyDB.
-
Analyze ZarMoney Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZarMoney data in Microsoft R Open.
-
How to Connect DBeaver to Short.io via a JDBC Driver
Manage Short.io data with visual tools in DBeaver like the query browser.
-
Automate SAP Hybris C4C Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Hybris C4C data replication to Azure Data Lake.
-
Replicate Confluence Data to Multiple Databases
Replicate Confluence data to disparate databases with a point-and-click configuration.
-
Visualize Live SuiteCRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SuiteCRM data.
-
Provide OData Services of Kafka Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Kafka data by developing a WCF Service Application.
-
How to Work with ZohoMarketingHub Data in AWS Glue Jobs Using JDBC
Connect to ZohoMarketingHub from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.