CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from SQL Server to Greenplum through SSIS
Easily push SQL Server data to Greenplum using the CData SSIS Tasks for Greenplum.
-
Integrating SAP Business One Data in Talend Cloud Data Management Platform
Connect SAP Business One Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Business One.
-
Connect Klaviyo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Klaviyo data using the CData Python MCP Server.
-
Visualize Supabase Data in Tableau
The CData ODBC driver for Supabase enables you integrate Supabase data into Tableau dashboards.
-
Process & Analyze DB2 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live DB2 Data.
-
Getting Started with the CData Excel Add-In for Stripe
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Stripe.
-
Query Elasticsearch Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Elasticsearch data from Node.js.
-
Viewing Bitbucket Data in RAD Studio Data Explorer
How to view Bitbucket data in RAD Studio Data Explorer using the CData ODBC Driver for Bitbucket.
-
Replicate Multiple SendPulse Accounts
Replicate multiple SendPulse accounts to one or many databases.
-
Connect SAS xpt to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAS xpt data using the CData Python MCP Server.
-
Build a Simple VCL Application for Cohere Data
How to build a simple VCL Application to view Cohere data in RAD Studio using the CData ODBC Driver for Cohere.
-
Feed Phoenix Data into FineReport
How to set Phoenix data as a JDBC data source in FineReport.
-
How to Work with Optimizely Data in AWS Glue Jobs Using JDBC
Connect to Optimizely from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import eBay Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to eBay Analytics Data and provide access to live eBay Analytics data for custom reports in the Power BI Service.
-
Automated Continuous Freshsales Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Freshsales replication to Google BigQuery.
-
How to import ShipEngine Data into Apache Solr
Use the CData Software JDBC Driver for ShipEngine in Data Import Handler and create an automated import of ShipEngine data to Apache Solr Enterprise Search platform.
-
Build Data Flows from Avalara AvaTax to SQL Server using SSIS
Easily back up Avalara AvaTax data to SQL Server using the SSIS components for Avalara AvaTax.
-
Use the CData SSIS Components to Insert New or Update Existing Cosmos DB Records from SQL Server
Easily push SQL Server data to Cosmos DB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cosmos DB or update existing records with data from a SQL Server database.
-
Automate AlloyDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access AlloyDB data from PowerShell? This article demonstrates how to utilize the AlloyDB Cmdlets for tasks like connecting to AlloyDB data, automating operations, downloading data, and more.
-
Visualize ServiceDesk Plus Data in Tableau
The CData ODBC driver for ServiceDesk Plus enables you integrate ServiceDesk Plus data into Tableau dashboards.
-
Prepare, Blend, and Analyze OpenWeatherMap Data in Alteryx Designer (ODBC)
Build workflows to access live OpenWeatherMap data for self-service data analytics.
-
Create Dynamic Stack Exchange Grids Using the Infragistics XamDataGrid
Learn how you can connect Stack Exchange to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Excel Data in Alteryx Designer (ODBC)
Build workflows to access live Excel data for self-service data analytics.
-
Automated Continuous Clari Replication to MySQL
Use CData Sync for automated, continuous, customizable Clari replication to MySQL.
-
Connect and Query Live ShipStation Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ShipStation data into Databricks and enable direct, live querying and analysis without replication.
-
Use Databricks Agent Bricks to Talk to Your SAP BusinessObjects BI Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP BusinessObjects BI data for you.
-
Build Printify Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Printify data and build visualizations in Tableau.
-
Automate Google Drive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Drive data from PowerShell? This article demonstrates how to utilize the Google Drive Cmdlets for tasks like connecting to Google Drive data, automating operations, downloading data, and more.
-
Connect to Access Data from PowerBuilder via JDBC
This article demonstrates how to access Access data from PowerBuilder using the Access JDBC Driver.
-
How to integrate Metabase with ConstantContact Data
Use CData Connect AI to connect to live ConstantContact data and create an interactive dashboard in Metabase from ConstantContact data.
-
Build Semantic Layer Views for Flowlu Data in APOS Live Data Gateway
Use the CData Connector for Flowlu in APOS Live Data Gateway to build Semantic Layer Views for Flowlu data.
-
Access Live Trello Data in AWS Lambda
Connect to live Trello data in AWS Lambda using the CData JDBC Driver.
-
Integrating GitHub Copilot with Optimizely 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.
-
SharePoint Online: Microsoft IDCRL Authentication Deprecation (SOAP Schema)
IDCRL retirement impacts SharePoint Online SOAP Schema users. Migrate to REST Schema or apply a temporary extension.
-
Getting Started with the CData Tableau Connector for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Raisers Edge NXT Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Raisers Edge NXT and the Script function in FileMaker Pro to connect to Raisers Edge NXT and work with Raisers Edge NXT data in your FileMaker application.
-
Connect to Bitly Data from a Connection Pool in Jetty
The Bitly JDBC Driver supports connection pooling: This article shows how to connect faster to Bitly data from Web apps in Jetty.
-
Connect to Microsoft Planner Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Planner data in DBeaver.
-
Import Real-Time Humanity Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Humanity data in ColdFusion.
-
How to Connect the Power BI Service to Dynamics 365 Business Central: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics 365 Business Central from PowerBI.com to provide real-time Dynamics 365 Business Central data across the organization.
-
Use the CData ODBC Driver for SparkPost from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SparkPost to connect to SparkPost data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SparkPost data in Excel.
-
Build a Simple VCL Application for Active Directory Data
How to build a simple VCL Application to view Active Directory data in RAD Studio using the CData ODBC Driver for Active Directory.
-
DataBind Controls to Asana Data in Delphi
DataBind to Asana data in Delphi with standard data access components and controls.
-
Integrating GitHub Copilot with Highrise 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.
-
How to Connect to Live Typeform 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 Typeform data for you.
-
Connect to Blackbaud FE NXT Data in NetBeans
Connect to Blackbaud FE NXT data in NetBeans with the data source configuration wizard.
-
Publish IBM Cloud Object Storage-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Cloud Object Storage data.
-
Getting Started with the CData ADO.NET Provider for Asana
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Asana.
-
Interact with Live Adobe Target Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Adobe Target data.
-
Access Live Clockify Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Clockify data into the statistical analysis tools available in SAS JMP. This article shows how to use Clockify data in the Graph Builder and Query Builder.
-
Easily Integrate Amazon S3 Data in Lazarus Pascal IDE
Learn how to easily integrate live Amazon S3 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Link GitLab with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate GitLab data in Filemaker Pro for Mac or Windows.
-
Replicate Multiple Pinterest Accounts via the CData Sync CLI
Replicate multiple Pinterest accounts to one or many databases.
-
Connect to Elasticsearch Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Elasticsearch Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Live eBay Analytics Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your eBay Analytics data for you.
-
Integrate REST Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live REST data from Informatica Cloud.
-
Connect to ZohoExpense Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ZohoExpense Data and connect to ZohoExpense data in Akorbi Digital RunMyProcess.
-
Provide OData Services of Freshservice Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Freshservice data by developing a WCF Service Application.
-
Query SparkPost Data as a SQL Server Database in Node.js
Execute SQL Server queries against SparkPost data from Node.js.
-
Migrating data from Cassandra to Google BigQuery using CData SSIS Components.
Easily push Cassandra data to Google BigQuery using the CData SSIS Tasks for Cassandra and Google BigQuery.
-
Connect to Cvent Data in Claris FileMaker Pro
Use the CData ODBC Driver for Cvent in FileMaker Pro to connect to Cvent and work with Cvent data in your FileMaker applications.
-
Load ADP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ADP data to a database.
-
Interact with Live Notion Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Notion data.
-
Integrate Microsoft Exchange Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Exchange data in the Pentaho Data Integration tool.
-
Build an OLAP Cube in SSAS from Printful Data
Establish a connection to Printful data data from SQL Server Analysis Services, and use the Printful Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Odoo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Odoo replication to IBM DB2.
-
Build AI/ML Models with Live Sage Intacct Data using Dataiku
Connect Sage Intacct Data with Dataiku using the CData JDBC Driver for Sage Intacct.
-
Visualize Vault CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Vault CRM data.
-
Integrate Trae with Live Klaviyo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Klaviyo data from within the AI-powered IDE.
-
Build Shopify Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Shopify data and build visualizations in Tableau.
-
Connect to Freshteam Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Freshteam data from Filemaker Pro on Mac.
-
Query Quaderno Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Quaderno data from Node.js.
-
Connect to LinkedIn Ads Data in HULFT Integrate
Connect to LinkedIn Ads as a JDBC data source in HULFT Integrate
-
How to connect to Klipfolio Data in DBVisualizer
Integrate Klipfolio data with visual data analysis tools and data connection wizards in DBVisualizer
-
Easily Integrate Sage 200 Data in Lazarus Pascal IDE
Learn how to easily integrate live Sage 200 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live FreshBooks Data in Excel 365 Online (Excel for the web)
Connect to FreshBooks data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Data Visualizations in Cognos BI with Office 365 Data
Access Office 365 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to SAP Business Warehouse Data in Aqua Data Studio
Access SAP Business Warehouse data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Charts with SAP Business Warehouse Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Business Warehouse data in Clear Analytics.
-
Use the CData ODBC Driver for Azure Data Lake Storage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Data Lake Storage to connect to Azure Data Lake Storage data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Data Lake Storage data in Excel.
-
Analyze Testmonitor Data in Cognos Analytics
Use CData Connect AI to connect to Testmonitor Data from Cognos Analytics and analyze live Testmonitor data.
-
Build a Singer.io Tap for Azure Data Catalog With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure Data Catalog data using the CData Python Connector.
-
Automated Continuous Postmark Replication to Oracle
Use CData Sync for automated, continuous, customizable Postmark replication to Oracle.
-
Connect to Freshdesk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Freshdesk data in Airbyte.
-
Viewing SAP Netweaver Gateway Data in RAD Studio Data Explorer
How to view SAP Netweaver Gateway data in RAD Studio Data Explorer using the CData ODBC Driver for SAP Netweaver Gateway.
-
View Reports on Real-Time CloudConvert Data in Power BI Report Server
Use the CData ODBC Driver for CloudConvert to visualize CloudConvert data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connecting Agentforce with ConstantContact 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 ConstantContact data for you.
-
Integrate Sybase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sybase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sybase data.
-
Getting Started with the CData Power BI Connector for Optimizely
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automate YouTube Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access YouTube Analytics data from PowerShell? This article demonstrates how to utilize the YouTube Analytics Cmdlets for tasks like connecting to YouTube Analytics data, automating operations, downloading data, and more.
-
Integrating GitHub Copilot with Qualaroo 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.
-
Create Data Visualizations in Cognos BI with QuickBooks Time Data
Access QuickBooks Time data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Web
Connect to SAP HANA data in MicroStrategy Web using the CData Software ODBC Driver for SAP HANA.
-
Build Semantic Layer Views for Bright Data Data in APOS Live Data Gateway
Use the CData Connector for Bright Data in APOS Live Data Gateway to build Semantic Layer Views for Bright Data data.
-
LINQ to Workday 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 Workday Data Provider.
-
How to Connect to & Open Google Sheets Data in Microsoft Excel
This article uses the CData ODBC driver for Google Sheets to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Moving Data from Vercel to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Vercel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Semantic Layer Views for Asana Data in APOS Live Data Gateway
Use the CData Connector for Asana in APOS Live Data Gateway to build Semantic Layer Views for Asana data.
-
DataBind Controls to PDFMonkey Data in C++Builder
DataBind to PDFMonkey data in C++Builder with standard components and controls.
-
Connect to Foursquare Data in NetBeans
Connect to Foursquare data in NetBeans with the data source configuration wizard.