CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to SendGrid via a JDBC Driver
Manage SendGrid with visual tools in DBeaver like the query browser.
-
Write a Simple Go Application to work with BigQuery Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google BigQuery.
-
How to Seamlessly Import SendGrid Data into IBM SPSS Modeler
Integrate SendGrid data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Nethunt Data to Multiple Databases via the CData Sync CLI
Replicate Nethunt to disparate databases with a single configuration.
-
Creating Bullhorn CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Bullhorn CRM to Unqork and build custom business apps.
-
Automated Oracle Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Database replication to Teradata.
-
How to Design IBM Informix Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to IBM Informix from mobile and tablet Power Apps.
-
Integrate Live Azure Data Lake Storage Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Azure Data Lake Storage and integrate live Azure Data Lake Storage into apps built in Microsoft Power Apps.
-
Process & Analyze Salesloft Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesloft Data.
-
Connect to Highrise Data in DBeaver
Use the CData ODBC Driver to connect to Highrise CRM in DBeaver.
-
Onfleet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Onfleet facts in real time.
-
Connect to SAP Netweaver Gateway Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Netweaver Gateway from Filemaker Pro on Mac.
-
How to connect and process HCL Domino from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HCL Domino.
-
Query Kafka Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Kafka entities in PHP by modeling them as objects.
-
How to Build an ETL App for Trello Data in Python with CData
Create ETL applications and real-time data pipelines for Trello in Python with petl.
-
Easily Integrate Testmonitor Data in Lazarus Pascal IDE
Learn how to easily integrate live Testmonitor in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect to Unbounce Data with Squirrel SQL client
Connect to Unbounce and execute queries in the Squirrel SQL Client.
-
Replicate PostgreSQL Data from PowerShell
Write a quick PowerShell script to query PostgreSQL. Use connectivity to the live data to replicate PostgreSQL to SQL Server.
-
How to Access Live Zuora Data in Visual Studio Code via Cline
Run CData MCP Server for Zuora on Windows Subsytem for Linux (WSL) and connect to live Zuora from the Cline extension in Visual Studio Code.
-
Natively Connect to PingOne Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PingOne. Leverage the native support for ODBC in PHP.
-
Connect to and Query Freshdesk Data in QlikView over ODBC
Create data visualizations with Freshdesk in QlikView.
-
How to connect to Recurly Data from IntelliJ
Integrate connectivity to Recurly with wizards in IntelliJ.
-
DataBind Controls to Workday Data in Delphi
DataBind to Workday in Delphi with standard data access components and controls.
-
Use Biml to Build SSIS Tasks to Replicate Google Directory Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Directory to SQL Server.
-
How to connect and process BenchmarkEmail from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live BenchmarkEmail.
-
Build Salesforce Pardot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce Pardot and build web apps with connectivity to live Salesforce Pardot.
-
Use the CData ODBC Driver for ClickUp in Microsoft Power Query
You can use the CData ClickUp ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ClickUp into Microsoft Power Query.
-
Moving Data from SAP Ariba Source to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Ariba Source data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Easily Query REST Data in OpenOffice Base
Connect to REST data in OpenOffice Base using the CData ODBC Driver for REST and generate reports with live data insights.
-
How to integrate Metabase with Zoho Inventory Data
Use CData Connect AI to connect to live Zoho Inventory and create an interactive dashboard in Metabase from Zoho Inventory.
-
How to connect PolyBase to HBase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache HBase.
-
Automated Continuous API Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable API replication to Google Cloud SQL.
-
Access Live NetSuite Data in AWS Lambda
Connect to live NetSuite CRM & ERP in AWS Lambda using the CData JDBC Driver.
-
DataBind Coda Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Coda to a chart.
-
Getting Started with the CData Connect AI Python SDK for Oracle Service Cloud
Install the CData Connect AI Python SDK to read and write live Oracle Service Cloud with standard DB-API 2.0 Python code.
-
Bidirectional Access to Azure DevOps Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Azure DevOps in Filemaker Pro for Mac or Windows.
-
Integrate API Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to API and integrate live API into your Power Automate tasks.
-
Connect to BenchmarkEmail Data in JRuby
Create a simple JRuby app with access to live BenchmarkEmail.
-
Connect to Close Data from PowerBuilder via ADO.NET
This article demonstrates how to access Close from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous Timely Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Timely replication to AlloyDB.
-
Bidirectional Access to Printful Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Printful in Filemaker Pro for Mac or Windows.
-
Connect to SAP Netweaver Gateway Data in Aqua Data Studio
Access SAP Netweaver Gateway from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Reports from SAP Hybris C4C Data in Looker Studio
Use CData Connect AI to gain access to live SAP Hybris C4C and create custom reports in Looker Studio.
-
Write a Simple Go Application to work with Klaviyo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Klaviyo.
-
Create MYOB AccountRight-Connected Nintex Workflows
Use CData Connect AI to connect to MYOB AccountRight Data from Nintex Workflow Cloud and build custom workflows using live MYOB AccountRight.
-
How to Query Live MessageBird Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MessageBird data in natural language using Python.
-
Connect to Live Avalara AvaTax Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Avalara AvaTax in CData Connect AI and connect to your Avalara AvaTax from PostgreSQL.
-
Visualize Couchbase 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 Couchbase into TIBCO Spotfire.
-
Build Freshsales-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Freshsales and build web apps with connectivity to live Freshsales.
-
Use Databricks Agent Bricks to Talk to Your Cassandra Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Apache Cassandra for you.
-
Use Grok to Talk to Your EnterpriseDB 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 EnterpriseDB for you.
-
Connect to Keap Data in JRuby
Create a simple JRuby app with access to live Keap.
-
Connect to Google Calendar Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Calendar in Airbyte.
-
Automate Square Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Square and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Amazon Athena Data in Talend Cloud Data Management Platform
Connect Amazon Athena Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Amazon Athena.
-
Automated Continuous SendPulse Replication to MySQL
Use CData Sync for automated, continuous, customizable SendPulse replication to MySQL.
-
Visualize Live SAP Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP ERP/NetWeaver.
-
Bidirectional Access to TaxJar Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate TaxJar in Filemaker Pro for Mac or Windows.
-
How to connect to Twitter Ads Data in DBVisualizer
Integrate Twitter Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Dash to Build Web Apps on Quickbase Data via CData Connect AI
Build interactive Dash web apps on live Quickbase using pandas and the CData Connect AI Python SDK.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Supabase
Provide connectivity to Supabase through an SAP BusinessObjects universe.
-
How to create an RPA flow for Google Ads Data in UiPath Studio
Use the Google Ads ODBC Driver to create workflows that access real-time Google Ads without any coding.
-
Integrate VWO Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live VWO from Informatica Cloud.
-
Build AI/ML Models with Live Klaviyo Data using Dataiku
Connect Klaviyo Data with Dataiku using the CData JDBC Driver for Klaviyo.
-
Use the CData Software JDBC Driver for Avro in MicroStrategy Desktop
Connect to Apache Avro in MicroStrategy Desktop using the CData Software JDBC Driver for Avro.
-
Access Redshift Data from MySQL in PHP
Connect to Redshift through the standard MySQL libraries in PHP.
-
Migrating data from SAS xpt to Google BigQuery using CData SSIS Components.
Easily push SAS XPORT to Google BigQuery using the CData SSIS Tasks for SAS xpt and Google BigQuery.
-
Analyze SQL Server Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft SQL Server in Microsoft R Open.
-
Getting Started with the CData SSIS Components for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics NAV.
-
Build SurveyMonkey-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SurveyMonkey to explore live SurveyMonkey Data in Cursor to assist with building SurveyMonkey-powered applications.
-
Automated Continuous SpaceX Replication to Vertica
Use CData Sync for automated, continuous, customizable SpaceX replication to Vertica.
-
Model Blackbaud FE NXT Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Blackbaud FE NXT, enabling the direct import of real-time Blackbaud FE NXT.
-
Connect to Reply.io Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Reply.io to connect to Reply.io and execute queries in PowerBuilder.
-
Connect to PhantomBuster Data in Ruby
Connect to PhantomBuster in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect Sybase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sybase with IBM WebSphere for seamless data integration and connectivity.
-
Explore Geographical Relationships in Pingdom Data with Power Map
Create data visualizations with Pingdom in Power Map.
-
Access Live Amazon Athena Data in TIBCO Data Virtualization
Use the Amazon Athena Tibco DV Adapter to create a Amazon Athena data source in TIBCO Data Virtualization Studio and gain access to live Amazon Athena from your TDV Server.
-
Edit and Search External Greenhouse Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Greenhouse to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Greenhouse Data objects that you can access from apps and the dashboard.
-
Create Basecamp-Connected Nintex Workflows
Use CData Connect AI to connect to Basecamp Data from Nintex Workflow Cloud and build custom workflows using live Basecamp.
-
Use Grok to Talk to Your NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics for you.
-
Connect to and Query VWO Data in QlikView over ODBC
Create data visualizations with VWO in QlikView.
-
Extend Google Sheets with Zoho CRM Data
Make calls to Zoho CRM from Google Apps Script via the API Server.
-
Connect to Couchbase Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Couchbase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Publish Crystal Reports on ActiveCampaign Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ActiveCampaign.
-
Build Visualizations of Zoho Projects Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Projects in Birst.
-
Create Datasets from Dynamics NAV in Domo Workbench and Build Visualizations of Dynamics NAV Data in Domo
Use the CData Software ODBC Driver for Dynamics NAV to create datasets from Microsoft Dynamics NAV in Domo Workbench and then build visualizations in the Domo service.
-
Object-Relational Mapping (ORM) with NetSuite 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 NetSuite CRM & ERP into a Java-based ORM framework, Hibernate.
-
Connect to CloudConvert Data in DBArtisan
Use wizards in DBArtisan to configure CloudConvert as a data source.
-
Establish a Live Connection with Acumatica Data using Tableau Bridge
The CData ODBC Driver for Acumatica enables you to integrate live Acumatica ERP into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Codex CLI with Tickspot 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.
-
Access MySQL Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MySQL from HeidiSQL.
-
How to connect to DocuSign Data with Squirrel SQL client
Connect to DocuSign and execute queries in the Squirrel SQL Client.
-
Add Sybase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sybase with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect and process Optimizely from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Optimizely.
-
Design BIRT Reports on eBay Data
Provide current eBay to your embedded analytics.
-
Connect to and Visualize Live OpenWeatherMap Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live OpenWeatherMap.
-
Design BIRT Reports on ScrapingBee Data
Provide current ScrapingBee to your embedded analytics.
-
Connect to SAS Data Sets Data in Aqua Data Studio
Access SAS Data Sets from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query, Visualize, and Share live Phoenix Data in Redash
Use CData Connect AI to connect to live Apache Phoenix in Redash for querying, visualizing, and sharing.
-
Replicate Multiple Salesforce Pardot Accounts
Replicate multiple Salesforce Pardot accounts to one or many databases.