CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To an ODBC Data Source for ClickTime
Create an ODBC connection to ClickTime in Informatica and browse and transfer ClickTime data.
-
Build Data Flows from SQL Server to Oracle Sales through SSIS
Easily push SQL Server data to Oracle Sales using the CData SSIS Tasks for Oracle Sales.
-
Access Live Oracle SCM Data in Coginiti Pro
Connect to and query live Oracle SCM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Operational Reporting on Pipedrive Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pipedrive data.
-
Build Microsoft Dataverse-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Dataverse Data from Choreo and build custom apps using live Microsoft Dataverse data.
-
Migrating data from PagerDuty to Google BigQuery using CData SSIS Components.
Easily push PagerDuty data to Google BigQuery using the CData SSIS Tasks for PagerDuty and Google BigQuery.
-
Connect to Google Tasks Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Tasks.
-
Build an OLAP Cube in SSAS from Slack Data
Establish a connection to Slack data data from SQL Server Analysis Services, and use the Slack Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access ZohoExpense Data from MySQL in PHP
Connect to ZohoExpense through the standard MySQL libraries in PHP.
-
Viewing SAP Business Warehouse Data in RAD Studio Data Explorer
How to view SAP Business Warehouse data in RAD Studio Data Explorer using the CData ODBC Driver for SAP Business Warehouse.
-
Use the CData ODBC Driver for LinkedIn Ads in Microsoft Power Query
You can use the CData LinkedIn Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import LinkedIn Ads data into Microsoft Power Query.
-
Use the CData Software JDBC Driver for SAP Fieldglass in MicroStrategy Web
Connect to SAP Fieldglass data in MicroStrategy Web using the CData Software JDBC Driver for SAP Fieldglass.
-
Integrate Trae with Live Azure Synapse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Azure Synapse data from within the AI-powered IDE.
-
Publish Airtable-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Airtable data.
-
Import and Visualize Gumroad Data in Power View
Create data visualizations based on Gumroad data in Excel.
-
Use Dash to Build to Web Apps on OnePageCrm Data
Create Python applications that use pandas and Dash to build OnePageCrm-connected web apps.
-
Access Live Outreach.io Data in Excel 365 Online (Excel for the web)
Connect to Outreach.io data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to create an RPA flow for Dynamics CRM Data in UiPath Studio
Use the Dynamics CRM ODBC Driver to create workflows that access real-time Dynamics CRM data without any coding.
-
Getting Started with the CData Power BI Connector for Discourse
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Automated Box-Connected Workflows in Zapier
Use CData Connect AI to connect to live Box data and build automated workflows in Zapier.
-
LINQ to Avro 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 Avro Data Provider.
-
How to import Zoho Inventory Data into Apache Solr
Use the CData Software JDBC Driver for Zoho Inventory in Data Import Handler and create an automated import of Zoho Inventory data to Apache Solr Enterprise Search platform.
-
Access Live MYOB AccountRight Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MYOB AccountRight data from your Excel spreadsheets.
-
Connect to Notion Data in HULFT Integrate
Connect to Notion as a JDBC data source in HULFT Integrate
-
Use Agno to Talk to Your XML 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 XML data for you.
-
How to work with PagerDuty Data in Apache Spark using SQL
Access and process PagerDuty Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Freshdesk 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 Freshdesk data.
-
Integrate Zoho CRM Data into Power Automate Desktop using CData Connect
CData Connect for Zoho CRM Data enables you to integrate Zoho CRM data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Codex with Discord 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.
-
Automated Continuous ZohoInvoice Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to AlloyDB.
-
Moving Data from HDFS to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live HDFS data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Easily Integrate SAP Business Warehouse Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Business Warehouse data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to IBM Informix Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for IBM Informix data in Airbyte.
-
How to connect Amazon QuickSight to OneNote Data
Create a connection to OneNote data in CData Connect AI and insert OneNote data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Excel Add-In for Lakebase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Lakebase.
-
Visualize Auth0 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Auth0 data.
-
ETL Greenhouse in Oracle Data Integrator
This article shows how to transfer Greenhouse data into a data warehouse using Oracle Data Integrator.
-
Analyze Mixpanel Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mixpanel data in Microsoft R Open.
-
Create Dynamic Browserless Grids Using the Infragistics XamDataGrid
Learn how you can connect Browserless to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Freshdesk Data in NetBeans
Connect to Freshdesk data in NetBeans with the data source configuration wizard.
-
How to publish and share Pingdom Data dashboards with Tableau Server
The CData ODBC driver for Pingdom enables you integrate Pingdom data into Tableau dashboards.
-
Replicate Strava Data from PowerShell
Write a quick PowerShell script to query Strava data. Use connectivity to the live data to replicate Strava data to SQL Server.
-
Create Reckon Accounts Hosted-Connected Applications in Appsmith
Connect to Reckon Accounts Hosted Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Reckon Accounts Hosted data.
-
How to Visualize Basecamp Data in Python with pandas
Use pandas and other modules to analyze and visualize live Basecamp data in Python.
-
Search External SAS xpt Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAS xpt data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAS xpt Data objects that you can access from apps and the dashboard.
-
Build Data Flows from Paddle to SQL Server using SSIS
Easily back up Paddle data to SQL Server using the SSIS components for Paddle.
-
Automated Continuous Zoho Recruit Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to Google BigQuery.
-
Integrate Live Microsoft Teams Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Teams data and integrate live Microsoft Teams data into apps built in Microsoft Power Apps.
-
Load Elasticsearch Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Elasticsearch data to a database.
-
How to integrate Pipedrive with Apache Airflow
Access and process Pipedrive data in Apache Airflow using the CData JDBC Driver.
-
Publish Hugging Face-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Hugging Face data.
-
Analyze Okta Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Okta data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Informatica Mappings From/To an ODBC Data Source for Greenhouse
Create an ODBC connection to Greenhouse in Informatica and browse and transfer Greenhouse data.
-
How to Connect to Live Trello 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 Trello data for you.
-
Build Dynamics 365-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Dynamics 365 data and build Dynamics 365-connected web apps with Axios.
-
Analyze Azure Data Lake Storage Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Data Lake Storage data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Oracle HCM Cloud Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle HCM Cloud from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData ODBC Driver for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Adobe Analytics.
-
Provide OData Services of Highrise Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Highrise data by developing a WCF Service Application.
-
Integrating OpenCode with Cloudflare 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.
-
Analyze HCL Domino Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HCL Domino data with the CData JDBC Driver for HCL Domino.
-
How to create NASA federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for NASA data in MySQL .
-
Build Dashboards with Google Translate Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Translate data in Dundas BI.
-
Build Automated Trello-Connected Workflows in Zapier
Use CData Connect AI to connect to live Trello data and build automated workflows in Zapier.
-
How to Query Live ZarMoney Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZarMoney data data in natural language using Python.
-
Use Dash to Build to Web Apps on Oracle SCM Data
Create Python applications that use pandas and Dash to build Oracle SCM-connected web apps.
-
Create Google Cloud Storage-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Cloud Storage Data from OutSystems and build custom enterprise apps using live Google Cloud Storage data.
-
Visualize Live MongoDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MongoDB data.
-
Working with Superchat Data in LINQPad
Execute LINQ queries to Superchat data in LINQPad.
-
Edit and Search External Azure Synapse Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Synapse data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Synapse Data objects that you can access from apps and the dashboard.
-
Connect to Real-Time Dynamics CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Dynamics CRM and Dataflow to import and use Dynamics CRM data in Power Apps.
-
How to Seamlessly Import Oracle Financials Cloud Data into IBM SPSS Modeler
Integrate Oracle Financials Cloud data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to and Query Azure Synapse Data in QlikView over ODBC
Create data visualizations with Azure Synapse data in QlikView.
-
How to Connect to Live SAP Ariba Source 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 SAP Ariba Source data for you.
-
How to update HubDB from Excel
This article explains how to transfer data from Excel to HubDB using the Excel Add-In for HubDB.
-
Visualize SendInBlue Data in Sisense
Create an ElastiCube in Sisense app with access to SendInBlue data.
-
Use the CData ODBC Driver for Wrike from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Wrike to connect to Wrike data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Wrike data in Excel.
-
Integrating SAP SuccessFactors Data in Talend Cloud Data Management Platform
Connect SAP SuccessFactors Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP SuccessFactors.
-
Connect to CloudConvert Data in CloverDX (formerly CloverETL)
Transfer CloudConvert data using the visual workflow in the CloverDX data integration tool.
-
Build AI/ML Models with Live Teamgate Data using Dataiku
Connect Teamgate Data with Dataiku using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for Front
Create Front data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Work with Keap Data in AWS Glue Jobs Using JDBC
Connect to Keap from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Design BIRT Reports on Hive Data
Provide current Hive data to your embedded analytics.
-
Automated Continuous Phoenix Replication to SQL Server
Use CData Sync for automated, continuous, customizable Phoenix replication to SQL Server.
-
Build Data Flows from SQL Server to Snapchat Ads through SSIS
Easily push SQL Server data to Snapchat Ads using the CData SSIS Tasks for Snapchat Ads.
-
Build Charts with BigQuery Data in Clear Analytics
Create dynamic charts and perform analytics based on BigQuery data in Clear Analytics.
-
Connect to ZohoSubscriptions Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ZohoSubscriptions.
-
Query Pipeliner CRM Data in DataGrip
Create a Data Source for Pipeliner CRM in DataGrip and use SQL to query live Pipeliner CRM data.
-
Connect to Webflow Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Webflow data.
-
Connect to Smartsheet Data in Google Apps Script via Connect AI
Use CData Connect AI to access Smartsheet data in Google Apps Script.
-
Connect to SAP Concur Data in HULFT Integrate
Connect to SAP Concur as a JDBC data source in HULFT Integrate
-
Use Manus AI to Talk to Your MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on MailerLite data.
-
Automated Continuous Short.io Replication to MySQL
Use CData Sync for automated, continuous, customizable Short.io replication to MySQL.
-
Query, Visualize, and Share live Snapchat Ads Data in Redash
Use CData Connect AI to connect to live Snapchat Ads data in Redash for querying, visualizing, and sharing.
-
Bind Live Twilio Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Twilio data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Use Biml to Build SSIS Tasks to Replicate Mailjet Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mailjet data to SQL Server.
-
Use the CData Software ODBC Driver for Insightly in MicroStrategy Desktop
Connect to Insightly data in MicroStrategy Desktop using the CData Software ODBC Driver for Insightly.
-
LINQ to Strava 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 Strava Data Provider.
-
Connect to BigQuery Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BigQuery to connect to BigQuery data and execute queries in PowerBuilder.
-
Automated Continuous Asana Replication to MongoDB
Use CData Sync for automated, continuous, customizable Asana replication to MongoDB.