CData Software - Knowledge Base
Recent Articles
-
Migrating data from Splunk to Snowflake using CData SSIS Components.
Easily push Splunk to Snowflake using the CData SSIS Tasks for Splunk and Snowflake.
-
How to Query Live Oracle Service Cloud Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Service Cloud data in natural language using Python.
-
Build Data Flows from Teamwork to SQL Server using SSIS
Easily back up Teamwork to SQL Server using the SSIS components for Teamwork.
-
Back Up Teamgate 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 Teamgate data.
-
Integrate Vimeo Data in the Pentaho Report Designer
Publish reports based on Vimeo in the Pentaho BI tool.
-
Integrating Discourse Data in Talend Cloud Data Management Platform
Connect Discourse Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for Brex in MicroStrategy
Connect to Brex in MicroStrategy Developer using the CData Software JDBC Driver for Brex.
-
Visualize Live Lakebase Data in the Power BI Service
Use CData Connect AI to connect to live Lakebase and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Dynamic SparkPost Grids Using the Infragistics XamDataGrid
Learn how you can connect SparkPost to Infragistics XamDataGrid to build dynamic grids.
-
Access Live ChartMogul Data in AWS Lambda
Connect to live ChartMogul in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Snowflake in MicroStrategy Desktop
Connect to Snowflake in MicroStrategy Desktop using the CData Software ODBC Driver for Snowflake.
-
DataBind Controls to Gmail Data in Delphi
DataBind to Gmail in Delphi with standard data access components and controls.
-
Analyze BigCommerce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BigCommerce from Power Pivot. You will use the Table Import Wizard to load BigCommerce. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Charts to ShipStation Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ShipStation from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Visualize Simplesat Data in TIBCO Spotfire through ADO.NET
Integrate Simplesat into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Connect AI Python SDK for Redis
Install the CData Connect AI Python SDK to read and write live Redis with standard DB-API 2.0 Python code.
-
Build Pipelines with Live Bullhorn CRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Bullhorn CRM from Google Cloud Data Fusion, enabling the integration of live Bullhorn CRM into the building and management of effective data pipelines.
-
Rapidly Develop Tanda-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Tanda.
-
Integrate Hubstaff with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Hubstaff with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Hubstaff.
-
Query SAP Fieldglass Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Fieldglass.
-
Build Sage Intacct-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sage Intacct Data from Zoho Analytics and import live Sage Intacct.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Entra ID Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Entra ID.
-
Automate eBay Data Replication to SAP HANA
Use CData Sync to customize and automate eBay replication to SAP HANA.
-
Connect to Airtable from Asprova with CData Software ODBC Driver for Airtable
This article shows how to connect faster to Airtable data from Asprova.
-
Create Informatica Mappings From/To an ODBC Data Source for Tanda
Create an ODBC connection to Tanda in Informatica and browse and transfer Tanda.
-
Build AI/ML Models with Live Google Translate Data using Dataiku
Connect Google Translate Data with Dataiku using the CData API Driver for JDBC.
-
How to integrate Bitbucket with Apache Airflow
Access and process Bitbucket in Apache Airflow using the CData JDBC Driver.
-
Connect Presto to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Presto using the CData Python MCP Server.
-
Build Automated Workflows with Live SAS xpt Data in Workato
Use CData Connect AI to connect to live SAS XPORT and build automated workflows in Workato.
-
Publish Crystal Reports on eBay Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date eBay.
-
Connect to SharePoint Excel Services Data in Aqua Data Studio
Access SharePoint Excel Services from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Aweber Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Aweber replication to OneLake in Microsoft Fabric.
-
Use the CData Software ODBC Driver for PDFMonkey in SAS for Real-Time Reporting and Analytics
Connect to real-time PDFMonkey in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PDFMonkey.
-
Connect Greenhouse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Greenhouse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Analysis Services within intelligent workflows.
-
Analyze Amazon DynamoDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Amazon DynamoDB and visualize Amazon DynamoDB in SAP Analytics Cloud.
-
Automated Continuous SuiteCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Databricks.
-
Automated Continuous BambooHR Replication to Vertica
Use CData Sync for automated, continuous, customizable BambooHR replication to Vertica.
-
Connect to Copper Data in HULFT Integrate
Connect to Copper as a JDBC data source in HULFT Integrate
-
Import Real-Time Okta Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Okta in ColdFusion.
-
How to Work with ServiceDesk Plus Data in AWS Glue Jobs Using JDBC
Connect to ServiceDesk Plus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to PabblySubscriptions Data in RapidMiner
Integrate PabblySubscriptions with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Manus AI to Talk to Your Epicor Kinetic 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 Epicor Kinetic.
-
Seamlessly Bring Xero Data into Retool Using CData Connect AI
Integrate Xero data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Zoom-Connected Applications in Appsmith
Connect to Zoom Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zoom.
-
How to Connect to Live Klaviyo Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Klaviyo without replication.
-
Use ChatGPT to Talk to Your MarkLogic 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 MarkLogic for you.
-
Access Live Xero Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Xero Accounting from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Tavily Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Tavily from HeidiSQL.
-
Integrate Live Azure Data Lake Storage Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Data Lake Storage from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Data Lake Storage.
-
Integrate Microsoft Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Ads with External Services.
-
Use Manus AI to Talk to Your Lakebase 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 Lakebase.
-
View Reports on Real-Time Act CRM Data in Power BI Report Server
Use the CData ODBC Driver for Act CRM to visualize Act CRM in Power BI Desktop and then publish them to Power BI Report Server.
-
How to import JotForm Data into Apache Solr
Use the CData Software JDBC Driver for JotForm in Data Import Handler and create an automated import of JotForm to Apache Solr Enterprise Search platform.
-
How to Connect Flowise AI Agents to Live Azure DevOps 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 Azure DevOps without replication.
-
Extract, Transform, and Load Google Calendar Data in Informatica PowerCenter
Create a simple Workflow for Google Calendar in Informatica PowerCenter.
-
ClickTime Reporting in OBIEE with the ClickTime JDBC Driver
Deploy the ClickTime JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Factorial Data from MySQL in PHP
Connect to Factorial through the standard MySQL libraries in PHP.
-
Analyze LDAP Objects in R via JDBC
Use standard R functions and the development environment of your choice to analyze LDAP with the CData JDBC Driver for LDAP.
-
How to create an RPA flow for SparkPost Data in UiPath Studio
Use the SparkPost ODBC Driver to create workflows that access real-time SparkPost without any coding.
-
Visualize Google Tasks Data in Tableau
The CData ODBC driver for Google Tasks enables you integrate Google Tasks into Tableau dashboards.
-
Operational Reporting on Helpscout Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Helpscout.
-
Connect to Access Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Access to connect to Microsoft Access and execute queries in PowerBuilder.
-
Create SpaceX Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SpaceX data access from reports, embedded analytics, and more.
-
Connect to Oracle HCM Cloud Data in Aqua Data Studio
Access Oracle HCM Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to SingleStore Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SingleStore.
-
How to connect to JotForm Data in DBVisualizer
Integrate JotForm with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Google Contacts Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Contacts in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for Azure Synapse in MicroStrategy Web
Connect to Azure Synapse in MicroStrategy Web using the CData Software ODBC Driver for Azure Synapse.
-
Connect to Greenhouse Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Greenhouse in Airbyte.
-
Connect to Real-Time Billsby Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Billsby in Power Apps.
-
Getting Started with the CData Tableau Connector for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Campaign Manager 360.
-
Access Live OData Services 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 OData through MCP integration.
-
LINQ to Email 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 Email Data Provider.
-
Work with Live Authorize.Net Data in Power Query
Use CData Connect AI to connect to Authorize.Net and work with live Authorize.Net in Microsoft Power Query.
-
Validate Float Data with QuerySurge
Access and validate Float in QuerySurge using the CData JDBC Driver.
-
How to Seamlessly Import IBM Informix Data into IBM SPSS Modeler
Integrate IBM Informix data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Establish a Live Connection with Tanda Data using Tableau Bridge
The CData ODBC Driver for Tanda enables you to integrate live Tanda into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Boomi Agentstudio with Power BI XMLA Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Power BI XMLA, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Todoist Replication to Vertica
Use CData Sync for automated, continuous, customizable Todoist replication to Vertica.
-
Create SSAS Tabular Models from Unbounce Data
How to build a SQL Server Analysis Service Tabular Model from Unbounce using CData drivers.
-
How to Connect DBeaver to Oracle SCM via a JDBC Driver
Manage Oracle SCM with visual tools in DBeaver like the query browser.
-
How to connect and process Unbounce from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Unbounce.
-
Build Apps with Live Accelo Data Using the Low-Code Development Platform of Mendix
Connect Accelo with Mendix to build apps using the CData API Driver for JDBC.
-
Work with Google Translate Data in FoxPro
Load Google Translate into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access Live Snapchat Ads Data in Visual Studio Code via Cline
Run CData MCP Server for Snapchat Ads on Windows Subsytem for Linux (WSL) and connect to live Snapchat Ads from the Cline extension in Visual Studio Code.
-
How to Connect the Power BI Service to SAP BusinessObjects BI: Complete Guide
Connect to the CData Software Power BI Connector for SAP BusinessObjects BI from PowerBI.com to provide real-time SAP BusinessObjects BI across the organization.
-
Create Datasets from Demio in Domo Workbench and Build Visualizations of Demio Data in Domo
Use the CData Software ODBC Driver for Demio to create datasets from Demio in Domo Workbench and then build visualizations in the Domo service.
-
Publish Microsoft Exchange-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Exchange.
-
Import and Visualize Amazon Athena Data in Power View
Create data visualizations based on Amazon Athena in Excel.
-
Connect to PDFMonkey Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to PDFMonkey and work with PDFMonkey in your FileMaker application.
-
Write a Simple Go Application to work with FreeAgent Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to FreeAgent.
-
How to load Google Ad Manager data into Elasticsearch via Logstash
Introducing a simple method to load Google Ad Manager data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Migrating data from SAP SuccessFactors LMS to Google BigQuery using CData SSIS Components.
Easily push SAP SuccessFactors LMS to Google BigQuery using the CData SSIS Tasks for SAP SuccessFactors LMS and Google BigQuery.
-
How to Connect Zoho CRM 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 Zoho CRM data in real time using natural language.
-
Automated Continuous IBM Cloud Object Storage Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Apache Cassandra.
-
Build JotForm-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to JotForm and build web apps with connectivity to live JotForm.
-
eBay Reporting in OBIEE with the eBay JDBC Driver
Deploy the eBay JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Boomi Agentstudio with PayPal Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to PayPal, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Dashboards with Gorgias Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gorgias in Dundas BI.