CData Software - Knowledge Base
Recent Articles
-
Connect to and Visualize Live Bannerbear Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bannerbear.
-
Use Dash to Build to Web Apps on ADP Data
Create Python applications that use pandas and Dash to build ADP-connected web apps.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Spanner using the Model Context Protocol.
-
Build SingleStore-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SingleStore to explore live SingleStore Data in Cursor to assist with building SingleStore-powered applications.
-
Use the CData Software JDBC Driver for Google Translate in MicroStrategy
Connect to Google Translate in MicroStrategy Developer using the CData Software JDBC Driver for Google Translate.
-
Migrating data from Mode to Databricks using CData SSIS Components.
Easily push Mode to Databricks using the CData SSIS Tasks for Mode and Databricks.
-
Analyze Adobe Commerce Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Adobe Commerce and visualize Adobe Commerce in SAP Analytics Cloud.
-
Getting Started with the CData Tableau Connector for Coda
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to publish and share MailerSend Data dashboards with Tableau Server
The CData ODBC driver for MailerSend enables you integrate MailerSend into Tableau dashboards.
-
Build CSV-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for CSV to explore live CSV Data in GitHub Copilot to assist with building CSV-powered applications.
-
Building Dynamic Web Pages with SAP Business One Data Using AngularJS
Create single-page applications with live connectivity to SAP Business One using the CData API Server.
-
LINQ to Outreach.io 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 Outreach.io Data Provider.
-
Visualize PayPal Data in Tableau
The CData ODBC driver for PayPal enables you integrate PayPal into Tableau dashboards.
-
Getting Started with the CData JDBC Driver for AlloyDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for AlloyDB.
-
Build Sage Intacct-Connected Apps in Choreo
Use CData Connect AI to connect to Sage Intacct Data from Choreo and build custom apps using live Sage Intacct.
-
Connect to AfterShip Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for AfterShip.
-
Query Oracle HCM Cloud Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle HCM Cloud from Node.js.
-
Replicate Multiple Lakebase Accounts via the CData Sync CLI
Replicate multiple Lakebase accounts to one or many databases.
-
Validate PabblySubscriptions Data with QuerySurge
Access and validate PabblySubscriptions in QuerySurge using the CData JDBC Driver.
-
Build Data Flows from Yelp to SQL Server using SSIS
Easily back up Yelp to SQL Server using the SSIS components for Yelp.
-
Analyze Salesloft Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesloft in Microsoft R Open.
-
Connect to and Query Stripe Data in QlikView over ODBC
Create data visualizations with Stripe in QlikView.
-
Visualize Live Zoho Inventory Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoho Inventory into custom reports in Power BI.
-
Use the CData SSIS Components to Insert New or Update Existing Klaviyo Records from SQL Server
Easily push SQL Server data to Klaviyo using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Klaviyo or update existing records with data from a SQL Server database.
-
Integrate with Invoiced Data in JReport Designer
Create charts and reports based on Invoiced in JReport Designer.
-
Easily Integrate Epicor Kinetic Data in Lazarus Pascal IDE
Learn how to easily integrate live Epicor Kinetic in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Excel Online-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Excel Online Data from Klipfolio and build custom visualizations using live Microsoft Excel Online.
-
Integrate Goose with Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Spanner from within the local AI agent.
-
Connect to LeadDesk Data in RapidMiner
Integrate LeadDesk with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Browserless Data in Ruby
Connect to Browserless in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Grafana Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Grafana from PowerShell? This article demonstrates how to utilize the Grafana Cmdlets for tasks like connecting to Grafana, automating operations, downloading data, and more.
-
How to connect to HubSpot Data from IntelliJ
Integrate connectivity to HubSpot with wizards in IntelliJ.
-
Automated Continuous SAP Fieldglass Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Oracle.
-
Automated Continuous Quickbase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Quickbase replication to IBM DB2.
-
Connect to Nuclia Data in Ruby
Connect to Nuclia in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to create Visio diagrams from Facebook Data
Automatically update Facebook with the changes you make to Visio master shapes.
-
Use Biml to Build SSIS Tasks to Replicate Bitly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bitly to SQL Server.
-
How to Access Live Insightly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Insightly enables you to integrate Insightly into workflows built using Microsoft Power Automate Desktop.
-
Automate REST Data Replication to Azure Data Lake
Use CData Sync to customize and automate REST replication to Azure Data Lake.
-
Getting Started with the CData Tableau Connector for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Projects.
-
Rapidly Develop GitLab-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 GitLab.
-
Build SuiteCRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SuiteCRM.
-
Use the CData Software ODBC Driver for Float in MicroStrategy Web
Connect to Float in MicroStrategy Web using the CData Software ODBC Driver for Float.
-
How to publish and share Oracle Sales Data dashboards with Tableau Server
The CData ODBC driver for Oracle Sales enables you integrate Oracle Sales into Tableau dashboards.
-
Build a Singer.io Tap for Email With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Email data using
-
Moving Data from Jumpseller to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Jumpseller data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Dataiku with Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Active Directory.
-
Query OData Services in ColdFusion
Write standard ColdFusion data access code to connect to OData.
-
Access Oracle SCM Data from MySQL in PHP
Connect to Oracle SCM through the standard MySQL libraries in PHP.
-
Create BigQuery-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BigQuery Data from OutSystems and build custom enterprise apps using live Google BigQuery.
-
Use Azure AI Foundry to Talk to Your Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Microsoft Dynamics 365 for you.
-
Import DocuSign Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to DocuSign Data and provide access to live DocuSign for custom reports in the Power BI Service.
-
Natively Connect to Simplesat Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Simplesat. Leverage the native support for ODBC in PHP.
-
Edit and Search PayPal External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of PayPal to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create PayPal objects that you can access from apps and the dashboard.
-
How to connect and process FHIR from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live FHIR.
-
Migrating data from Microsoft OneDrive to Databricks using CData SSIS Components.
Easily push Microsoft OneDrive to Databricks using the CData SSIS Tasks for Microsoft OneDrive and Databricks.
-
Bind Live Dynamics CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Dynamics CRM data
-
Choosing the Best Method to Connect Opsgenie to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Opsgenie from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Query GitLab Data in MySQL Workbench
Execute MySQL queries against live GitLab from MySQL Workbench.
-
Connect to Office 365 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Office 365, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
DataBind Controls to HBase Data in C++Builder
DataBind to Apache HBase in C++Builder with standard components and controls.
-
Build Dashboards with ConvertKit Data in Dundas BI
Create dynamic dashboards and perform analytics based on ConvertKit in Dundas BI.
-
Connect to Contentful 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 Contentful and work with Contentful in your FileMaker application.
-
Object-Relational Mapping (ORM) with Klaviyo 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 Klaviyo into a Java-based ORM framework, Hibernate.
-
Access Live Active Directory Data in AWS Lambda
Connect to live Active Directory in AWS Lambda using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for SAP Concur on an SSRS Report Server
Connect to SAP Concur from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live NetSuite CRM & ERP within intelligent workflows.
-
How to import Shippo Data into Apache Solr
Use the CData Software JDBC Driver for Shippo in Data Import Handler and create an automated import of Shippo to Apache Solr Enterprise Search platform.
-
Use Grok to Talk to Your Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apollo for you.
-
Use the CData ODBC Driver for Highrise from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Highrise to connect to Highrise CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Highrise CRM in Excel.
-
Query SurveyMonkey Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SurveyMonkey from Node.js.
-
DataBind Charts to PhantomBuster Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PhantomBuster 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.
-
Getting Started with the CData JDBC Driver for Aircall
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Aircall.
-
Access GitLab Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access GitLab from your Oracle system.
-
Create Informatica Mappings From/To an ODBC Data Source for Hacker News
Create an ODBC connection to Hacker News in Informatica and browse and transfer Hacker News.
-
Automated Continuous Epicor Kinetic Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Azure SQL Database.
-
Automated Zendesk Data Replication to Teradata
Use CData Sync to Customize and automate Zendesk replication to Teradata.
-
Use the CData Software JDBC Driver for Rebilly in MicroStrategy Web
Connect to Rebilly in MicroStrategy Web using the CData Software JDBC Driver for Rebilly.
-
Deploy the ADO.NET Provider for GraphQL on an SSRS Report Server
Connect to GraphQL from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Getting Started with the CData Python Connector for Jumpseller
Learn to install and license the CData Python Connector
-
Create Dynamic Freshsales Grids Using the Infragistics XamDataGrid
Learn how you can connect Freshsales to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to SurveyMonkey Data with Squirrel SQL client
Connect to SurveyMonkey and execute queries in the Squirrel SQL Client.
-
Connect to Procore Data in Jaspersoft Studio
Execute SQL to remote Procore in Jaspersoft Studio.
-
Deploy the ADO.NET Provider for Avaza on an SSRS Report Server
Connect to Avaza from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData Software JDBC Driver for Nethunt in MicroStrategy
Connect to Nethunt in MicroStrategy Developer using the CData Software JDBC Driver for Nethunt.
-
Connect to Excel Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Excel in DBeaver.
-
Connect and Query Live Facebook Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Facebook Ads into Databricks
-
Bidirectional Access to CloudConvert Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate CloudConvert in Filemaker Pro for Mac or Windows.
-
Automated Continuous Helpscout Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Helpscout replication to Google BigQuery.
-
Configure the CData JDBC Driver for Printify in a Connection Pool in Tomcat
Connect to Printify from a connection pool in Tomcat.
-
How to Build an ETL App for PingOne Data in Python with CData
Create ETL applications and real-time data pipelines for PingOne in Python with petl.
-
Build Apps with Live Amazon DynamoDB Data Using the Low-Code Development Platform of Mendix
Connect Amazon DynamoDB with Mendix to build apps using the CData JDBC Driver for Amazon DynamoDB.
-
Replicate Perplexity Data in Heroku for Use in Salesforce Connect
Replicate Perplexity to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
View Reports on Real-Time Google Drive Data in Power BI Report Server
Use the CData ODBC Driver for Google Drive to visualize Google Drive in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Connect AI Python SDK for Oracle SCM
Install the CData Connect AI Python SDK to read and write live Oracle SCM with standard DB-API 2.0 Python code.
-
How to Create Power BI Visual Reports with Real-Time MailChimp Data
Use CData Power BI Connectors to visualize MailChimp in Power BI.
-
Add PivotalTracker Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PivotalTracker with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Grok to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP Ariba Source for you.
-
Automate CampaignMonitor Data Replication to Couchbase
Use CData Sync to Customize and automate CampaignMonitor replication to Couchbase.
-
Build Voice Agents in ElevenLabs with access to Live MailChimp Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MailChimp.