CData Software - Knowledge Base
Recent Articles
-
How to Seamlessly Import Oracle Service Cloud Data into IBM SPSS Modeler
Integrate Oracle Service Cloud data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to create an RPA flow for Autopilot Data in UiPath Studio
Use the Autopilot ODBC Driver to create workflows that access real-time Autopilot without any coding.
-
How to Create Power BI Visual Reports with Real-Time Drip Data
Use CData Power BI Connectors to visualize Drip in Power BI.
-
Explore Geographical Relationships in Twitter Ads Data with Power Map
Create data visualizations with Twitter Ads in Power Map.
-
Connect to Exact Online Data in HULFT Integrate
Connect to Exact Online as a JDBC data source in HULFT Integrate
-
Build Basecamp-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Basecamp.
-
Connect to Samanage Data from a Connection Pool in JBoss
Integrate Samanage into Java servlets: Use the Management Console in JBoss to install the Samanage JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Odoo
Create an ODBC connection to Odoo in Informatica and browse and transfer Odoo ERP.
-
Create Informatica Mappings From/To a JDBC Data Source for Pinecone
Create Pinecone data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Feed Landbot Data into FineReport
How to set Landbot as a JDBC data source in FineReport.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoMarketingHub
Create ZohoMarketingHub data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate LibreChat with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ActiveCampaign from within the chat interface.
-
Create Data Visualizations in Cognos BI with Oracle Service Cloud Data
Access Oracle Service Cloud as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Datasets from MYOB AccountRight in Domo Workbench and Build Visualizations of MYOB AccountRight Data in Domo
Use the CData Software ODBC Driver for MYOB AccountRight to create datasets from MYOB AccountRight in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Live CSV 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 CSV/TSV Files for you.
-
Query Intercom Data as a MySQL Database in Node.js
Execute MySQL queries against Intercom from Node.js.
-
Create Slack Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Slack data access from reports, embedded analytics, and more.
-
Automated Continuous Vertica Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Vertica replication to delimited files (CSV/TSV).
-
How to Visualize SingleStore 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 SingleStore in Python.
-
Query Redshift Data in DataGrip
Create a Data Source for Redshift in DataGrip and use SQL to query live Amazon Redshift.
-
Automated Continuous Moosend Replication to MySQL
Use CData Sync for automated, continuous, customizable Moosend replication to MySQL.
-
Build Data Flows from Amazon DynamoDB to SQL Server using SSIS
Easily back up Amazon DynamoDB to SQL Server using the SSIS components for Amazon DynamoDB.
-
Use Dash to Build Web Apps on Confluence Data via CData Connect AI
Build interactive Dash web apps on live Atlassian Confluence using pandas and the CData Connect AI Python SDK.
-
Connect Mailgun Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mailgun using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Prepare, Blend, and Analyze Paymo Data in Alteryx Designer (ODBC)
Build workflows to access live Paymo for self-service data analytics.
-
Visualize Everhour Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Everhour into TIBCO Spotfire.
-
Replicate HBase Data from PowerShell
Write a quick PowerShell script to query Apache HBase. Use connectivity to the live data to replicate Apache HBase to SQL Server.
-
Integrate with Azure Data Lake Storage Data in JReport Designer
Create charts and reports based on Azure Data Lake Storage in JReport Designer.
-
Query Elorus Data as a MySQL Database in Node.js
Execute MySQL queries against Elorus from Node.js.
-
Connect to Keap Data in Jaspersoft Studio
Execute SQL to remote Keap in Jaspersoft Studio.
-
Load Avro Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Avro to a database.
-
Connect to and Visualize Live MYOB AccountRight Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MYOB AccountRight.
-
How to Seamlessly Import Templated Data into IBM SPSS Modeler
Integrate Templated data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Migrating data from Dynamics 365 to Snowflake using CData SSIS Components.
Easily push Microsoft Dynamics 365 to Snowflake using the CData SSIS Tasks for Dynamics 365 and Snowflake.
-
How to connect PolyBase to Eventbrite
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Eventbrite.
-
Publish Crystal Reports on ChartMogul Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ChartMogul.
-
Replicate Multiple Egnyte Accounts via the CData Sync CLI
Replicate multiple Egnyte accounts to one or many databases.
-
How to create Zuora federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zuora in MySQL .
-
How to Connect to ZohoExpense Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoExpense. Leverage the pyodbc module for ODBC in Python.
-
Replicate Pipeline CRM Data to Multiple Databases
Replicate Pipeline CRM to disparate databases with a point-and-click configuration.
-
Validate Hugging Face Data with QuerySurge
Access and validate Hugging Face in QuerySurge using the CData JDBC Driver.
-
How to Query LinkedIn Ads Data in MySQL Workbench
Execute MySQL queries against live LinkedIn Ads from MySQL Workbench.
-
Automated Continuous SageHR Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SageHR replication to Apache Kafka.
-
Use the CData Software ODBC Driver for Elorus in MicroStrategy Desktop
Connect to Elorus in MicroStrategy Desktop using the CData Software ODBC Driver for Elorus.
-
Excel Spreadsheet Automation on FormSite Data with the QUERY Formula
Pull data from FormSite, automate spreadsheets, and more with the QUERY formula.
-
Integrating OpenCode Terminal with BigQuery 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.
-
Viewing EmailOctopus Data in RAD Studio Data Explorer
How to view EmailOctopus in RAD Studio Data Explorer using the CData ODBC Driver for EmailOctopus.
-
Connect to Recurly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Recurly.
-
LINQ to ScrapingBee 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 ScrapingBee Data Provider.
-
Automated Continuous Mailgun Replication to Vertica
Use CData Sync for automated, continuous, customizable Mailgun replication to Vertica.
-
Build Automated Adobe Analytics-Connected Workflows in Zapier
Use CData Connect AI to connect to live Adobe Analytics and build automated workflows in Zapier.
-
Use the CData Software JDBC Driver for Egnyte in MicroStrategy Desktop
Connect to Egnyte in MicroStrategy Desktop using the CData Software JDBC Driver for Egnyte.
-
Connect to Drift Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Drift as an External Source in Dremio.
-
Migrating data from BenchmarkEmail to Databricks using CData SSIS Components.
Easily push BenchmarkEmail to Databricks using the CData SSIS Tasks for BenchmarkEmail and Databricks.
-
Excel Spreadsheet Automation on Webex Data with the QUERY Formula
Pull data from Webex, automate spreadsheets, and more with the QUERY formula.
-
Build Dashboards with Sybase IQ Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sybase IQ in Dundas BI.
-
Stream SpaceX Data into Apache Kafka Topics
Access and stream SpaceX in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Delighted Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Delighted with the CData JDBC Driver for Delighted.
-
How to Work with Dynamics 365 Data in ETL Validator JDBC
Connect to Dynamics 365 from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData API Server to Access Oracle Eloqua Reporting Data in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle Eloqua Reporting in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Intercom in MicroStrategy Desktop
Connect to Intercom in MicroStrategy Desktop using the CData Software ODBC Driver for Intercom.
-
Integrating LangGraph with Adobe Analytics Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Adobe Analytics within automated workflows.
-
Integrate with Basecamp Data in JReport Designer
Create charts and reports based on Basecamp in JReport Designer.
-
Using the CData Software ODBC Driver for TigerGraph in PyCharm
Connect to TigerGraph as an ODBC data source in PyCharm using the CData Software ODBC Driver for TigerGraph.
-
Build Data Flows from Confluence to SQL Server using SSIS
Easily back up Atlassian Confluence to SQL Server using the SSIS components for Confluence.
-
Create a Data Access Object for AgileCRM Data using JDBI
A brief overview of creating a SQL Object API for AgileCRM in JDBI.
-
Build Data Flows from ZohoDesk to SQL Server using SSIS
Easily back up ZohoDesk to SQL Server using the SSIS components for ZohoDesk.
-
Prepare, Blend, and Analyze Klaviyo Data in Alteryx Designer (ODBC)
Build workflows to access live Klaviyo for self-service data analytics.
-
Connect to QuickBooks Data in RazorSQL
Connect to QuickBooks from wizards and query QuickBooks Desktop from the GUI in the RazorSQL database management tool.
-
How to Work with Drift Data in ETL Validator JDBC
Connect to Drift from ETL Validator jobs using the CData Software JDBC Driver.
-
Establish a Live Connection with BenchmarkEmail Data using Tableau Bridge
The CData ODBC Driver for BenchmarkEmail enables you to integrate live BenchmarkEmail into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for FTP in MicroStrategy Desktop
Connect to FTP Servers in MicroStrategy Desktop using the CData Software JDBC Driver for FTP.
-
Connect to Zoho Books from Asprova with CData Software ODBC Driver for Zoho Books
This article shows how to connect faster to Zoho Books data from Asprova.
-
Natively Connect to Clio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Clio. Leverage the native support for ODBC in PHP.
-
Back Up GitLab 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 GitLab data.
-
How to Connect Flowise AI Agents to Live Authorize.Net 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 Authorize.Net without replication.
-
Replicate Azure Data Catalog Data to Multiple Databases
Replicate Azure Data Catalog to disparate databases with a point-and-click configuration.
-
Bridge SendPulse Connectivity with Apache NiFi
Access and process SendPulse in Apache NiFi using the CData JDBC Driver.
-
How to Query SurveyMonkey Data in MySQL Workbench
Execute MySQL queries against live SurveyMonkey from MySQL Workbench.
-
How to Connect to Live SQL Server 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 Microsoft SQL Server through natural language.
-
Connect to LionDesk Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connecting Agentforce with SAP SuccessFactors 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 SAP SuccessFactors for you.
-
Analyze Everhour Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Everhour in Microsoft R Open.
-
LINQ to Tickspot 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 Tickspot Data Provider.
-
Connect to Amazon DynamoDB Data from AWS Glue
Use CData Connect AI to gain access to live Amazon DynamoDB from your AWS Glue jobs.
-
Working with Dynamics 365 Business Central Data in LINQPad
Execute LINQ queries to Dynamics 365 Business Central in LINQPad.
-
Easily Integrate Discord Data in Lazarus Pascal IDE
Learn how to easily integrate live Discord in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Greenhouse Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Greenhouse and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to GraphQL Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for GraphQL in Airbyte.
-
Visualize Live ZohoDesk Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoDesk using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Adobe Experience Manager in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Experience Manager in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Experience Manager.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Planner Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Planner.
-
How to connect PolyBase to Paddle
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Paddle.
-
Creating Avalara AvaTax-Connected Applications in Unqork
You can use CData Connect AI to feed Avalara AvaTax to Unqork and build custom business apps.
-
Connecting GenSpark with Cvent Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Cvent without any replication or custom integration required.
-
Automated Continuous Act-On Replication to Vertica
Use CData Sync for automated, continuous, customizable Act-On replication to Vertica.
-
Connect Twitter Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Twitter Ads using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live OData Services in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live OData from your Google Sheets.
-
Build Oracle Financials Cloud-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle Financials Cloud Data and create custom apps in Bubble.
-
Replicate Samanage Data from PowerShell
Write a quick PowerShell script to query Samanage. Use connectivity to the live data to replicate Samanage to SQL Server.