CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time ConstantContact Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ConstantContact in Power Apps.
-
Access Live Wistia Data in AWS Lambda
Connect to live Wistia in AWS Lambda using the CData JDBC Driver.
-
Bridge NetSuite Connectivity with Apache NiFi
Access and process NetSuite CRM & ERP in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Office 365 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Office 365 replication to Azure SQL Database.
-
Use Biml to Build SSIS Tasks to Replicate Discord Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Discord to SQL Server.
-
Build WordPress-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for WordPress to explore live WordPress Data in GitHub Copilot to assist with building WordPress-powered applications.
-
Automated Continuous NetSuite Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable NetSuite replication to delimited files (CSV/TSV).
-
Choosing the Best Method to Connect Marketo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Marketo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Gumloop with Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Bullhorn CRM within automated workflows.
-
Automated Continuous Outreach.io Replication to MongoDB
Use CData Sync for automated, continuous, customizable Outreach.io replication to MongoDB.
-
Excel Spreadsheet Automation on Productboard Data with the QUERY Formula
Pull data from Productboard, automate spreadsheets, and more with the QUERY formula.
-
Connecting Pipedream with Greenplum Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Greenplum data in real time.
-
Build Apps with Live PDFMonkey Data Using the Low-Code Development Platform of Mendix
Connect PDFMonkey with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate with Airtable Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Airtable in SnapLogic.
-
Build Dashboards with Perplexity Data in Dundas BI
Create dynamic dashboards and perform analytics based on Perplexity in Dundas BI.
-
Visualize Freshsales Data in TIBCO Spotfire through ADO.NET
Integrate Freshsales into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Power BI Connector for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Hybris C4C.
-
How to Connect DBeaver to ZarMoney via a JDBC Driver
Manage ZarMoney with visual tools in DBeaver like the query browser.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live MailChimp within intelligent workflows.
-
Create Data Visualizations in Cognos BI with Azure Data Lake Storage Data
Access Azure Data Lake Storage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Simplesat Data in Coginiti Pro
Connect to and query live Simplesat from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Confluence-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Confluence to explore live Confluence Data in GitHub Copilot to assist with building Confluence-powered applications.
-
Publish Humanity-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Humanity.
-
Connect Vimeo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Vimeo using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create a Data Access Object for Avaza Data using JDBI
A brief overview of creating a SQL Object API for Avaza in JDBI.
-
Getting Started with the CData Power BI Connector for Cloudflare
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Datasets from Pipedrive in Domo Workbench and Build Visualizations of Pipedrive Data in Domo
Use the CData Software ODBC Driver for Pipedrive to create datasets from Pipedrive in Domo Workbench and then build visualizations in the Domo service.
-
Natively Connect to Salesforce Pardot Data in PHP
The CData ODBC driver for Salesforce Pardot enables you to create PHP applications with connectivity to Salesforce Pardot. Leverage the native support for ODBC in PHP.
-
Model MySQL Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MySQL, enabling the direct import of real-time MySQL.
-
Integrating OpenCode Terminal with SAP HANA XS Advanced 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 Access AgileCRM Data Using Entity Framework
This article shows how to access AgileCRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to and Query Acumatica Data in QlikView over ODBC
Create data visualizations with Acumatica ERP in QlikView.
-
Natively Connect to Hive Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache Hive. Leverage the native support for ODBC in PHP.
-
Build Procore-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Procore.
-
How to connect to Freshservice Data from IntelliJ
Integrate connectivity to Freshservice with wizards in IntelliJ.
-
Replicate Anaplan Data from PowerShell
Write a quick PowerShell script to query Anaplan. Use connectivity to the live data to replicate Anaplan to SQL Server.
-
Automated Continuous Teradata Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Teradata replication to OneLake in Microsoft Fabric.
-
Load Scrapfly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Scrapfly to a database.
-
Create Informatica Mappings From/To a JDBC Data Source for Bannerbear
Create Bannerbear data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Prepare, Blend, and Analyze LeadDesk Data in Alteryx Designer (ODBC)
Build workflows to access live LeadDesk for self-service data analytics.
-
Design BIRT Reports on Nethunt Data
Provide current Nethunt to your embedded analytics.
-
Choosing the Best Method to Connect SAP Fieldglass to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Fieldglass from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Semantic Layer Views for Greenhouse Data in APOS Live Data Gateway
Use the CData Connector for Greenhouse in APOS Live Data Gateway to build Semantic Layer Views for Greenhouse.
-
Connect to Webex Data in CloverDX (formerly CloverETL)
Transfer Webex using the visual workflow in the CloverDX data integration tool.
-
Load Google Forms Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Forms to a database.
-
Connect to Simplesat Data from PowerBuilder via ADO.NET
This article demonstrates how to access Simplesat from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating OpenCode Terminal with Recurly 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.
-
Publish Reports with Active Directory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Active Directory.
-
Model Excel Online Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Excel Online, enabling the direct import of real-time Microsoft Excel Online.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CircleCI
Provide connectivity to CircleCI through an SAP BusinessObjects universe.
-
Visualize Everhour Data in Sisense
Create an ElastiCube in Sisense app with access to Everhour.
-
Explore Geographical Relationships in QuickBooks Time Data with Power Map
Create data visualizations with QuickBooks Time in Power Map.
-
Replicate Freshteam Data to Multiple Databases via the CData Sync CLI
Replicate Freshteam to disparate databases with a single configuration.
-
Design BIRT Reports on LeadDesk Data
Provide current LeadDesk to your embedded analytics.
-
How to Access Live MongoDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MongoDB enables you to integrate MongoDB into workflows built using Microsoft Power Automate Desktop.
-
How to update SQL Server from Excel
This article explains how to transfer data from Excel to SQL Server using the Excel Add-In for SQL Server.
-
How to Access Live ShipEngine Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ShipEngine enables you to integrate ShipEngine into workflows built using Microsoft Power Automate Desktop.
-
Trigger IBM Informix IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for IBM Informix with standard wizards in Logic Apps.
-
Establish a Live Connection with Paylocity Data using Tableau Bridge
The CData ODBC Driver for Paylocity enables you to integrate live Paylocity into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for Spotify in MicroStrategy
Connect to Spotify in MicroStrategy Developer using the CData Software JDBC Driver for Spotify.
-
Manage Exa Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Exa.
-
Back Up Microsoft Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Ads. In this article, we will employ an SSIS workflow to populate a database with Microsoft Ads data.
-
Build Visualizations of Oracle Financials Cloud Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Financials Cloud in Birst.
-
How to Query Jodoo Data in MySQL Workbench
Execute MySQL queries against live Jodoo from MySQL Workbench.
-
Prepare, Blend, and Analyze Parallel Data in Alteryx Designer (ODBC)
Build workflows to access live Parallel for self-service data analytics.
-
Connect to AdRoll Data in Ruby
Connect to AdRoll in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Bitly Data in JRuby
Create a simple JRuby app with access to live Bitly.
-
Automated Continuous Power BI XMLA Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Apache Kafka.
-
Automated Sage 300 Data Replication to Teradata
Use CData Sync to Customize and automate Sage 300 replication to Teradata.
-
Create Informatica Mappings From/To an ODBC Data Source for CampaignMonitor
Create an ODBC connection to CampaignMonitor in Informatica and browse and transfer CampaignMonitor.
-
How to connect to Float Data in DBVisualizer
Integrate Float with visual data analysis tools and data connection wizards in DBVisualizer
-
A PostgreSQL Interface for Mailjet Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mailjet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Zendesk Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zendesk from your Google Sheets.
-
Connect to ZohoExpense Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoExpense from PowerBuilder using the ZohoExpense JDBC Driver.
-
Integrating Claude Code CLI with Chargebee 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.
-
Build Apps with Live Google Calendar in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Calendar into the Adalo platform and build custom mobile and web applications with real-time Google Calendar.
-
Import and Visualize ServiceNow Data in Power View
Create data visualizations based on ServiceNow in Excel.
-
Connect to SAP Ariba Source Data in JRuby
Create a simple JRuby app with access to live SAP Ariba Source.
-
Build NetSuite-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live NetSuite CRM & ERP.
-
How to connect and process PivotalTracker from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PivotalTracker.
-
Using the CData Software ODBC Driver for Optimizely in PyCharm
Connect to Optimizely as an ODBC data source in PyCharm using the CData Software ODBC Driver for Optimizely.
-
Connect to PhantomBuster from Asprova with CData Software ODBC Driver for PhantomBuster
This article shows how to connect faster to PhantomBuster data from Asprova.
-
Use JayDeBeApi to access Raisers Edge NXT Data in Python
Use standard Python scripting and the development environment of your choice to access live Raisers Edge NXT.
-
Integrate Open WebUI with Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Dynamics 365 from within the chat interface.
-
How to use SQLAlchemy ORM to access SharePoint Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft SharePoint.
-
Seamlessly Bring Google Spanner Data into Retool Using CData Connect AI
Integrate Google Spanner data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Back Up LaunchDarkly 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 LaunchDarkly data.
-
Build ServiceNow-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for ServiceNow to explore live ServiceNow Data in GitHub Copilot to assist with building ServiceNow-powered applications.
-
HCL Domino Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HCL Domino facts in real time.
-
Build Apps with Live GitLab Data Using the Low-Code Development Platform of Mendix
Connect GitLab with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating LlamaIndex with Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Amazon DynamoDB in real time.
-
Integrating HDFS Data in Talend Cloud Data Management Platform
Connect HDFS Data with Talend Cloud Data Management Platform using the CData JDBC Driver for HDFS.
-
How to Build an ETL App for Vault CRM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Veeva Vault & Vault CRM in Python with petl and the CData Connect AI Python SDK.
-
Configure the CData JDBC Driver for SAP Ariba Source in a Connection Pool in Tomcat
Connect to SAP Ariba Source from a connection pool in Tomcat.
-
Automated Continuous SharePoint Excel Services Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to delimited files (CSV/TSV).
-
Object-Relational Mapping (ORM) with EnterpriseDB Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to EnterpriseDB into a Java-based ORM framework, Hibernate.
-
Connecting GenSpark with Gong Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Gong without any replication or custom integration required.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Chargebee
Provide connectivity to Chargebee through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live CSV Data in ThoughtSpot
Use CData Connect AI to connect to live CSV/TSV Files for modeling, searching, and visualizing.
-
Visualize Adobe Experience Manager Data in TIBCO Spotfire through ADO.NET
Integrate Adobe Experience Manager into dashboards in TIBCO Spotfire.