CData Software - Knowledge Base
Recent Articles
-
Build Azure Data Lake Storage-Connected Apps in Choreo
Use CData Connect AI to connect to Azure Data Lake Storage Data from Choreo and build custom apps using live Azure Data Lake Storage data.
-
Automated Continuous Trello Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Trello replication to IBM DB2.
-
Create Power BI Reports on Real-Time Wistia Data
Use the CData ODBC Driver for Wistia to visualize Wistia data in Power BI Desktop.
-
Analyze Sybase Data in Cognos Analytics
Use CData Connect AI to connect to Sybase Data from Cognos Analytics and analyze live Sybase data.
-
How to Visualize Snowflake 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 Snowflake data in Python.
-
How to Work with Act CRM Data in ETL Validator JDBC
Connect to Act CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with AfterShip Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy AfterShip data to a JSON file on disk.
-
Connect to LDAP Objects from AWS Glue
Use CData Connect AI to gain access to live LDAP objects from your AWS Glue jobs.
-
Build GitHub-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live GitHub data and build GitHub-connected web apps with Axios.
-
Use the CData Software ODBC Driver for HubDB in MicroStrategy Web
Connect to HubDB data in MicroStrategy Web using the CData Software ODBC Driver for HubDB.
-
Replicate Asana Data from PowerShell
Write a quick PowerShell script to query Asana data. Use connectivity to the live data to replicate Asana data to SQL Server.
-
Provide OData Services of Shopify Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Shopify data by developing a WCF Service Application.
-
Analyze BigQuery Data in Cognos Analytics
Use CData Connect AI to connect to BigQuery Data from Cognos Analytics and analyze live BigQuery data.
-
Build an OLAP Cube in SSAS from Bullhorn CRM Data
Establish a connection to Bullhorn CRM data data from SQL Server Analysis Services, and use the Bullhorn CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Google Calendar Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Calendar data.
-
Publish Reports with Google Campaign Manager 360 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Campaign Manager 360 data.
-
Use the CData Software ODBC Driver for xBase in MicroStrategy
Connect to xBase data in MicroStrategy Developer using the CData Software ODBC Driver for xBase.
-
Back Up Drip data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Drip data data.
-
Choosing the Best Method to Connect Bitbucket to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bitbucket data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Mode Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Mode.
-
MailerLite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MailerLite facts in real time.
-
Automated Continuous Keap Replication to Snowflake
Use CData Sync for automated, continuous, customizable Keap replication to Snowflake.
-
Automated Continuous Perigon Replication to SQL Server
Use CData Sync for automated, continuous, customizable Perigon replication to SQL Server.
-
Connect to RSS Feeds in DBArtisan
Use wizards in DBArtisan to configure RSS feeds as a data source.
-
Integrate with Live HCL Domino Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to HCL Domino from the MuleSoft Anypoint Platform to integrate live HCL Domino data into custom reports and dashboards.
-
Salesforce Data 360 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce Data 360 facts in real time.
-
Automated Continuous Postmark Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Postmark replication to delimited files (CSV/TSV).
-
Analyze Google Search Results in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Search results and visualize Google Search results in SAP Analytics Cloud.
-
Integrate with SAS xpt Data in JReport Designer
Create charts and reports based on SAS xpt data in JReport Designer.
-
Integrate Goose with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAS xpt data from within the local AI agent.
-
Work with Impala Data in FoxPro
Load Impala data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Build an ETL App for Contentful Data in Python with CData
Create ETL applications and real-time data pipelines for Contentful data in Python with petl.
-
How to connect to Cloudflare Data with Squirrel SQL client
Connect to Cloudflare data and execute queries in the Squirrel SQL Client.
-
Connect to and Query Spark Data in QlikView over ODBC
Create data visualizations with Spark data in QlikView.
-
Query Oracle Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle data from Node.js.
-
Access SAP Ariba Source Data from MySQL in PHP
Connect to SAP Ariba Source through the standard MySQL libraries in PHP.
-
Create Zoho Books-Connected Business Apps in AppSheet
Connect to Zoho Books Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho Books data.
-
How to Build an ETL App for Teradata Data in Python with CData
Create ETL applications and real-time data pipelines for Teradata data in Python with petl.
-
How to Connect Redis 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 Redis data in real time using natural language.
-
Integrate Cursor with Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Ariba Procurement data from within the editor.
-
Easily Integrate Gorgias Data in Lazarus Pascal IDE
Learn how to easily integrate live Gorgias data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Reports with PingOne Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PingOne data.
-
Connect to Google Campaign Manager 360 Data in DBeaver
Use the CData ODBC Driver to connect to Google Campaign Manager 360 data in DBeaver.
-
Integrate with Live Google Sheets Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Sheets from the MuleSoft Anypoint Platform to integrate live Google Sheets data into custom reports and dashboards.
-
DataBind Autopilot Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Autopilot data to a chart.
-
Model, Search, and Visualize Live GraphQL Data in ThoughtSpot
Use CData Connect AI to connect to live GraphQL data for modeling, searching, and visualizing.
-
Create DB2-Connected Dashboards in Grafana
Connect to DB2 Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to DB2 data.
-
Automate Paddle Data Replication to Azure Data Lake
Use CData Sync to customize and automate Paddle data replication to Azure Data Lake.
-
Design BIRT Reports on Asana Data
Provide current Asana data to your embedded analytics.
-
How to Connect to Live iContact Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live iContact data securely in real time.
-
Automated Continuous Asana Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Asana replication to Azure SQL Database.
-
Connect to Freshdesk Data in Ruby
Connect to Freshdesk data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Airtable Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Airtable data for you.
-
Getting Started with the CData Python Connector for Workday
Learn to install and license the CData Python Connector and configure a connection to live Workday data.
-
Visualize Oracle SCM Data in TIBCO Spotfire through ADO.NET
Integrate Oracle SCM data into dashboards in TIBCO Spotfire.
-
How to connect to HelloSign Data with Squirrel SQL client
Connect to HelloSign data and execute queries in the Squirrel SQL Client.
-
Extract, Transform, and Load SAP HANA XS Advanced Data in Informatica PowerCenter
Create a simple Workflow for SAP HANA XS Advanced data in Informatica PowerCenter.
-
Analyze ADP Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ADP data and visualize ADP data in SAP Analytics Cloud.
-
How to Connect to Live Exact Online 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 Exact Online data through natural language.
-
Perform Batch Operations with Sybase Data in Apache NiFi
Connect to Sybase data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to integrate Telegram with Apache Airflow
Access and process Telegram data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData Tableau Connector for Pipedrive
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Pipedrive.
-
Use Claude to Talk to Your WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your WordPress data for you.
-
Integrating Pipeline CRM Data in Talend Cloud Data Management Platform
Connect Pipeline CRM Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Kintone Replication to SingleStore
Use CData Sync for automated, continuous, customizable Kintone replication to SingleStore.
-
Viewing Telegram Data in RAD Studio Data Explorer
How to view Telegram data in RAD Studio Data Explorer using the CData ODBC Driver for Telegram.
-
Build an OLAP Cube in SSAS from Impala Data
Establish a connection to Impala data data from SQL Server Analysis Services, and use the Impala Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import Real-Time GetResponse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use GetResponse data in ColdFusion.
-
Connect to Toggl Data in Google Apps Script via Connect AI
Use CData Connect AI to access Toggl data in Google Apps Script.
-
How to connect PolyBase to MessageBird
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MessageBird data.
-
Use Agno to Talk to Your AlloyDB 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 AlloyDB data for you.
-
Build Jira Assets Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Jira Assets data and build visualizations in Tableau Cloud.
-
Use the CData Software ODBC Driver for PingOne in MicroStrategy Web
Connect to PingOne data in MicroStrategy Web using the CData Software ODBC Driver for PingOne.
-
Connect to Twitter Ads Data in Ruby
Connect to Twitter Ads data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating LangGraph with Zendesk Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zendesk data within automated workflows.
-
Use the CData Software JDBC Driver for LightSpeedRetail in MicroStrategy Desktop
Connect to LightSpeedRetail data in MicroStrategy Desktop using the CData Software JDBC Driver for LightSpeedRetail.
-
How to publish and share SAP Ariba Procurement Data dashboards with Tableau Server
The CData ODBC driver for SAP Ariba Procurement enables you integrate SAP Ariba Procurement data into Tableau dashboards.
-
Build Charts with ZohoMarketingHub Data in Clear Analytics
Create dynamic charts and perform analytics based on ZohoMarketingHub data in Clear Analytics.
-
Analyze Live SageHR Data in SAS Viya
Use CData Connect AI to connect to SageHR data from SAS Viya and deploy self-service analytics using live SageHR data.
-
Connect to Vault CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Vault CRM and the Script function in FileMaker Pro to connect to Vault CRM and work with Vault CRM data in your FileMaker application.
-
Integrating Boomi Agentstudio with Bitbucket Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Bitbucket data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect Foursquare Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Foursquare data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build SuiteCRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SuiteCRM data and build visualizations in Tableau.
-
Automated Continuous Cohere Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cohere replication to Amazon S3.
-
How to connect to Attio Data from Spring Boot
Connect to Attio in a Spring Boot Application using the CData API Driver for JDBC
-
Visualize Live IBM Cloud Object Storage Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live IBM Cloud Object Storage data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple Sentry Accounts
Replicate multiple Sentry accounts to one or many databases.
-
Use the CData ODBC Driver for Hacker News from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Hacker News to connect to Hacker News data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Hacker News data in Excel.
-
Connect to GetResponse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for GetResponse and the SQL Gateway to access GetResponse data from Google Apps Script.
-
Connect to CouchDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CouchDB to connect to CouchDB data and execute queries in PowerBuilder.
-
Create SSAS Tabular Models from ZohoMarketingHub Data
How to build a SQL Server Analysis Service Tabular Model from ZohoMarketingHub data using CData drivers.
-
Using the CData Software ODBC Driver for Sage Intacct in PyCharm
Connect to Sage Intacct as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage Intacct.
-
Automated Continuous WordPress Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable WordPress replication to Google BigQuery.
-
Migrating data from Zendesk to Snowflake using CData SSIS Components.
Easily push Zendesk data to Snowflake using the CData SSIS Tasks for Zendesk and Snowflake.
-
Build Zoom-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoom data and build Zoom-connected web apps with Axios.
-
View Reports on Real-Time Notion Data in Power BI Report Server
Use the CData ODBC Driver for Notion to visualize Notion data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Dash to Build to Web Apps on LaunchDarkly Data
Create Python applications that use pandas and Dash to build LaunchDarkly-connected web apps.
-
Seamlessly Bring Klaviyo Data into Retool Using CData Connect AI
Integrate Klaviyo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData Software ODBC Driver for Everhour in MicroStrategy Web
Connect to Everhour data in MicroStrategy Web using the CData Software ODBC Driver for Everhour.
-
Connect to Supabase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Supabase data, and over 250 other data sources, right inside your Excel and Google spreadsheets!