CData Software - Knowledge Base
Recent Articles
-
Natively Connect to MarkLogic Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MarkLogic data. Leverage the native support for ODBC in PHP.
-
Build Apps with Live SQL Analysis Services data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SQL Analysis Services data into the Adalo platform and build custom mobile and web applications with real-time SQL Analysis Services data.
-
Add ShipEngine Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ShipEngine with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to CockroachDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CockroachDB data. Leverage the pyodbc module for ODBC in Python.
-
Automate Redshift Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Redshift data from PowerShell? This article demonstrates how to utilize the Redshift Cmdlets for tasks like connecting to Redshift data, automating operations, downloading data, and more.
-
Getting Started with the CData Connect AI Python SDK for Reckon
Install the CData Connect AI Python SDK to read and write live Reckon data with standard DB-API 2.0 Python code.
-
Getting Started with the CData Excel Add-In for Close
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Close.
-
How to Connect the Power BI Service to Lakebase: Complete Guide
Connect to the CData Software Power BI Connector for Lakebase from PowerBI.com to provide real-time Lakebase data across the organization.
-
How to Visualize Wistia 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 Wistia data in Python.
-
Trigger Azure Synapse IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Azure Synapse with standard wizards in Logic Apps.
-
Connect to xBase Data from AWS Glue
Use CData Connect AI to gain access to live xBase data from your AWS Glue jobs.
-
How to Seamlessly Import AfterShip Data into IBM SPSS Modeler
Integrate AfterShip data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Pipelines with Live Freshservice Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Freshservice from Google Cloud Data Fusion, enabling the integration of live Freshservice data into the building and management of effective data pipelines.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Planner Data
Use CData Power BI Connectors to visualize Microsoft Planner data in Power BI.
-
Automated Continuous SAP Business One Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Business One replication to Snowflake.
-
Write a Simple Go Application to work with GraphQL Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GraphQL data.
-
Integrate Live Dynamics 365 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Dynamics 365 data to Blue Prism using the CData ODBC Driver for Dynamics 365 to create automated workflows for repetitive business tasks.
-
How to Query Live ConstantContact Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ConstantContact data data in natural language using Python.
-
Create SSAS Tabular Models from Telegram Data
How to build a SQL Server Analysis Service Tabular Model from Telegram data using CData drivers.
-
Operational Reporting on Google Analytics Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Analytics data.
-
Connect to Copper Data in NetBeans
Connect to Copper data in NetBeans with the data source configuration wizard.
-
Visualize Live SageHR Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SageHR data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating LangGraph with HubDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on HubDB data within automated workflows.
-
Use the CData Software ODBC Driver for Factorial in MicroStrategy
Connect to Factorial data in MicroStrategy Developer using the CData Software ODBC Driver for Factorial.
-
Connect to Active Directory Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Active Directory and the Script function in FileMaker Pro to connect to Active Directory and work with Active Directory data in your FileMaker application.
-
Automated Continuous Autopilot Replication to MongoDB
Use CData Sync for automated, continuous, customizable Autopilot replication to MongoDB.
-
Connect to Spark Data in HULFT Integrate
Connect to Spark as a JDBC data source in HULFT Integrate
-
Access Oracle Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle data from your Oracle system.
-
How to Connect the Power BI Service to Sage Intacct: Complete Guide
Connect to the CData Software Power BI Connector for Sage Intacct from PowerBI.com to provide real-time Sage Intacct data across the organization.
-
Automate Mailjet Data Replication to Azure Data Lake
Use CData Sync to customize and automate Mailjet data replication to Azure Data Lake.
-
How to Connect to Live Couchbase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Couchbase data securely in real time.
-
Import Real-Time Float Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Float data in ColdFusion.
-
Automated Continuous Jira Assets Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Jira Assets replication to delimited files (CSV/TSV).
-
Integrate Live Google Ad Manager Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Ad Manager data to Blue Prism using the CData ODBC Driver for Google Ad Manager to create automated workflows for repetitive business tasks.
-
Automated Continuous OpenWeatherMap Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to Google Cloud SQL.
-
How to create an RPA flow for LeadDesk Data in UiPath Studio
Use the LeadDesk ODBC Driver to create workflows that access real-time LeadDesk data without any coding.
-
Visualize Raisers Edge NXT Data in TIBCO Spotfire through OData
Integrate Raisers Edge NXT data into dashboards in TIBCO Spotfire.
-
Access Live YouTube Analytics Data in AWS Lambda
Connect to live YouTube Analytics data in AWS Lambda using the CData JDBC Driver.
-
Integrating OpenCode with Outlook 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 DBeaver to PolarTeamPro via a JDBC Driver
Manage PolarTeamPro data with visual tools in DBeaver like the query browser.
-
Build Semantic Layer Views for Sage 300 Data in APOS Live Data Gateway
Use the CData Connector for Sage 300 in APOS Live Data Gateway to build Semantic Layer Views for Sage 300 data.
-
ODBC Driver Getting Started Guide
A basic guide to connecting applications to data from anywhere using the CData ODBC Driver
-
Bind Live AlloyDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live AlloyDB data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to connect PolyBase to Oracle HCM Cloud
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle HCM Cloud data.
-
Back Up Tickspot 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 Tickspot data data.
-
Automate Cloudant Data Replication to Couchbase
Use CData Sync to Customize and automate Cloudant data replication to Couchbase.
-
Integrating Boomi Agentstudio with Toggl Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Toggl data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Dashboards and Visualize Live Microsoft Teams Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Teams data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize Live Bugsnag Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bugsnag data.
-
Build Data Flows from Retently to SQL Server using SSIS
Easily back up Retently data to SQL Server using the SSIS components for Retently.
-
Operational Reporting on SAP Concur Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Concur data.
-
How to Easily Query MySQL Data in OpenOffice Base
Connect to MySQL data in OpenOffice Base using the CData ODBC Driver for MySQL and generate reports with live data insights.
-
How to Build an ETL App for Mistral AI Data in Python with CData
Create ETL applications and real-time data pipelines for Mistral AI data in Python with petl.
-
Automated Continuous Airtable Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Airtable replication to AlloyDB.
-
Build Dashboards with Telegram Data in DBxtra
Create dynamic dashboards and perform analytics based on Telegram data in DBxtra.
-
Build a PostgreSQL Interface for Pinterest Data using the CData JDBC Driver
Use the Remoting features of the Pinterest JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Tasks Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Tasks data using standard SQL.
-
How to Work with Asana Data in ETL Validator JDBC
Connect to Asana from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Billsby Data in HULFT Integrate
Connect to Billsby as a JDBC data source in HULFT Integrate
-
Analyze Live SingleStore Data in SAS Viya
Use CData Connect AI to connect to SingleStore data from SAS Viya and deploy self-service analytics using live SingleStore data.
-
Integrate with PayPal Data in SnapLogic
Use CData Connect AI to connect to and integrate with live PayPal data in SnapLogic.
-
Getting Started with the CData Tableau Connector for Unbounce
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect MYOB AccountRight to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MYOB AccountRight data using the CData Python MCP Server.
-
Build AI/ML Models with Live CouchDB Data using Dataiku
Connect CouchDB Data with Dataiku using the CData JDBC Driver for CouchDB.
-
Easily Integrate Zuora Data in Lazarus Pascal IDE
Learn how to easily integrate live Zuora data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData SSIS Components to Insert New or Update Existing Hive Records from SQL Server
Easily push SQL Server data to Hive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Hive or update existing records with data from a SQL Server database.
-
Integrating Adobe Commerce Data in Talend Cloud Data Management Platform
Connect Adobe Commerce Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Adobe Commerce.
-
Publish Productboard-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Productboard data.
-
Integrate with Discord Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Discord data to a JSON file on disk.
-
Build AI Agents with Adobe Commerce Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Adobe Commerce data through CData Connect AI.
-
Automate Webex Data Replication to Couchbase
Use CData Sync to Customize and automate Webex data replication to Couchbase.
-
Integrate with Live HDFS Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to HDFS from the MuleSoft Anypoint Platform to integrate live HDFS data into custom reports and dashboards.
-
Integrating GitHub Copilot with SAS Data Sets 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.
-
Integrate Dify with Live Dynamics 365 Business Central Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Dynamics 365 Business Central data.
-
How to Work with LinkedIn Ads Data in AWS Glue Jobs Using JDBC
Connect to LinkedIn Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Informatica Mappings From/To a JDBC Data Source for MailerSend
Create MailerSend data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to work with Workday Data in Apache Spark using SQL
Access and process Workday Data in Apache Spark using the CData Software JDBC Driver.
-
Perform Batch Operations with Smartsheet Data in Apache NiFi
Connect to Smartsheet data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Reckon Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Reckon data from your Oracle system.
-
How to Create Power BI Visual Reports with Real-Time Close Data
Use CData Power BI Connectors to visualize Close data in Power BI.
-
How to Visualize Google Drive 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 Google Drive data in Python.
-
Create Google Cloud Storage-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Cloud Storage Data from Klipfolio and build custom visualizations using live Google Cloud Storage data.
-
How to Query Live ElevenLabs Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ElevenLabs data data in natural language using Python.
-
Working with Nethunt Data in LINQPad
Execute LINQ queries to Nethunt data in LINQPad.
-
Create Power BI Reports on Real-Time Everhour Data
Use the CData ODBC Driver for Everhour to visualize Everhour data in Power BI Desktop.
-
Query FreeAgent Data through ODBC in Node.js
Use node-odbc to execute SQL queries against FreeAgent data from Node.js.
-
Integrate Freshteam with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Freshteam with External Services.
-
How to Connect DBeaver to Miro via a JDBC Driver
Manage Miro data with visual tools in DBeaver like the query browser.
-
Connect to Microsoft Teams Data in JRuby
Create a simple JRuby app with access to live Microsoft Teams data.
-
How to Connect to Jira Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Jira data. Leverage the pyodbc module for ODBC in Python.
-
Work with Live Redis Data in Power Query
Use CData Connect AI to connect to Redis data and work with live Redis data in Microsoft Power Query.
-
Connect to Todoist 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 Todoist and work with Todoist data in your FileMaker application.
-
Integrating Kiro with SAP BusinessObjects BI 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.
-
Connect to SAP HANA XS Advanced Data from AWS Glue
Use CData Connect AI to gain access to live SAP HANA XS Advanced data from your AWS Glue jobs.
-
Publish Scrapfly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Scrapfly data.
-
Using the CData Software ODBC Driver for GraphQL in PyCharm
Connect to GraphQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for GraphQL.
-
Query SpaceX Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SpaceX data from Node.js.
-
Integrate Kafka Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Kafka data from Informatica Cloud.
-
Integrating Boomi Agentstudio with Gong Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Gong data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Live Neo4J 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 Neo4J data for you.