CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of QuickBooks Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of QuickBooks Desktop in Birst.
-
Prepare, Blend, and Analyze Procore Data in Alteryx Designer (ODBC)
Build workflows to access live Procore for self-service data analytics.
-
Analyze PDFMonkey Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of PDFMonkey and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating OpenCode Terminal with Testmonitor 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 to Zoho Books Data from Spring Boot
Connect to Zoho Books in a Spring Boot Application using the CData JDBC Driver for Zoho Books
-
Deploy the ADO.NET Provider for Teamgate on an SSRS Report Server
Connect to Teamgate 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.
-
Analyze ZohoPeople Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of ZohoPeople and visualize live ZohoPeople in Infragistics Reveal.
-
Integrate Live Zoho Books Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Books from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Books.
-
Enable the Google Campaign Manager 360 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Campaign Manager 360.
-
How to connect to TigerGraph Data with Squirrel SQL client
Connect to TigerGraph and execute queries in the Squirrel SQL Client.
-
Import SAP SuccessFactors Data Using Azure Data Factory
Use CData Connect AI to connect to SAP SuccessFactors Data from Azure Data Factory and import live SAP SuccessFactors.
-
Consume Epicor Kinetic OData Feeds in PowerBuilder
This article demonstrates how to consume Epicor Kinetic as OData feeds from PowerBuilder using the API Server.
-
Access Freshteam Data from MySQL in Amazon QuickSight
Connect to Freshteam and build visualizations of Freshteam using a MySQL Connection in Amazon QuickSight.
-
Work with Live Freshdesk Data in Power Query
Use CData Connect AI to connect to Freshdesk and work with live Freshdesk in Microsoft Power Query.
-
Bidirectional Access to Bullhorn CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bullhorn CRM in Filemaker Pro for Mac or Windows.
-
Use the CData SSIS Components to Insert New or Update Existing Cloudant Records from SQL Server
Easily push SQL Server data to Cloudant using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cloudant or update existing records with data from a SQL Server database.
-
Design BIRT Reports on Oracle Eloqua Data
Provide current Oracle Eloqua to your embedded analytics.
-
Connect to Microsoft Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Ads from Filemaker Pro on Mac.
-
Consume Rebilly OData Feeds in PowerBuilder
This article demonstrates how to consume Rebilly as OData feeds from PowerBuilder using the API Server.
-
FAQ: Licensing and Deploying Builds of Finished Applications
Follow these instructions to test, build, and distribute apps using the CData single developer, royalty-free license.
-
Connect to Apollo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Apollo to connect to Apollo and execute queries in PowerBuilder.
-
Analyze LinkedIn Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LinkedIn Ads and visualize live LinkedIn Ads in Infragistics Reveal.
-
Build Dashboards with Yelp Data in DBxtra
Create dynamic dashboards and perform analytics based on Yelp in DBxtra.
-
Query Retently Data in DataGrip
Create a Data Source for Retently in DataGrip and use SQL to query live Retently.
-
Integrating LangChain with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Search within automated workflows.
-
Use Azure AI Foundry to Talk to Your Shopify 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 Shopify for you.
-
Analyze Autopilot Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Autopilot and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to xBase from a Connection Pool in WebLogic
Use the CData JDBC Driver for xBase to connect to xBase from Web applications running on WebLogic.
-
Object-Relational Mapping (ORM) with Vault CRM 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 Veeva Vault & Vault CRM into a Java-based ORM framework, Hibernate.
-
Viewing Google Ads Data in RAD Studio Data Explorer
How to view Google Ads in RAD Studio Data Explorer using the CData ODBC Driver for Google Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for Amplitude
Create an ODBC connection to Amplitude in Informatica and browse and transfer Amplitude.
-
Build Brex-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Brex and build web apps with connectivity to live Brex.
-
Use CData Connect AI to Access Cosmos DB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Azure Cosmos DB in the Power Pivot business intelligence tool.
-
Build Apps with Live Databricks Data Using the Low-Code Development Platform of Mendix
Connect Databricks with Mendix to build apps using the CData JDBC Driver for Databricks.
-
How to Create Power BI Visual Reports with Real-Time Gumroad Data
Use CData Power BI Connectors to visualize Gumroad in Power BI.
-
Access Live Scrapfly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Scrapfly into the statistical analysis tools available in SAS JMP. This article shows how to use Scrapfly in the Graph Builder and Query Builder.
-
Integrate with Avro Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Avro to a JSON file on disk.
-
Integrate with Dropbox Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Dropbox in SnapLogic.
-
Connect to Zendesk Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zendesk.
-
How to connect and process Sentry from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sentry.
-
How to integrate Slack with Apache Airflow
Access and process Slack in Apache Airflow using the CData JDBC Driver.
-
Integrating LlamaIndex with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle SCM in real time.
-
How to Easily Query Perplexity Data in OpenOffice Base
Connect to Perplexity data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Greenplum Replication to Oracle
Use CData Sync for automated, continuous, customizable Greenplum replication to Oracle.
-
Connect to Adobe Target Data in RazorSQL
Connect to Adobe Target from wizards and query Adobe Target from the GUI in the RazorSQL database management tool.
-
Query, Visualize, and Share live Slack Data in Redash
Use CData Connect AI to connect to live Slack in Redash for querying, visualizing, and sharing.
-
Object-Relational Mapping (ORM) with DocuSign 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 DocuSign into a Java-based ORM framework, Hibernate.
-
Create MariaDB-Connected Dashboards in Grafana
Connect to MariaDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MariaDB.
-
Connecting GenSpark with SAP SuccessFactors LMS Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP SuccessFactors LMS without any replication or custom integration required.
-
Bidirectional Access to Oracle Sales Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Sales in Filemaker Pro for Mac or Windows.
-
Replicate EnterpriseDB Data to Multiple Databases via the CData Sync CLI
Replicate EnterpriseDB to disparate databases with a single configuration.
-
Migrating data from Google Contacts to Snowflake using CData SSIS Components.
Easily push Google Contacts to Snowflake using the CData SSIS Tasks for Google Contacts and Snowflake.
-
Automate Freshsales Data Replication to Azure Data Lake
Use CData Sync to customize and automate Freshsales replication to Azure Data Lake.
-
How to connect to Zuora Data with Squirrel SQL client
Connect to Zuora and execute queries in the Squirrel SQL Client.
-
Build Automated Workflows with Live QuickBooks Time Data in Workato
Use CData Connect AI to connect to live QuickBooks Time and build automated workflows in Workato.
-
Build Google Drive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Drive Data and create custom apps in Bubble.
-
How to Query LightSpeedRetail Data in MySQL Workbench
Execute MySQL queries against live LightSpeedRetail from MySQL Workbench.
-
Automated Continuous Aweber Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Aweber replication to IBM DB2.
-
Use the CData Software ODBC Driver for AfterShip in SAS for Real-Time Reporting and Analytics
Connect to real-time AfterShip in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for AfterShip.
-
Visualize Live Oracle Sales Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle Sales into custom reports in Power BI.
-
Automate JobNimbus Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live JobNimbus and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Easily Integrate GetResponse Data in Lazarus Pascal IDE
Learn how to easily integrate live GetResponse in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Charts to Webflow Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Webflow 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.
-
How to Work with Browserless Data in ETL Validator JDBC
Connect to Browserless from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Microsoft Exchange Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Exchange from PowerShell? This article demonstrates how to utilize the Microsoft Exchange Cmdlets for tasks like connecting to Microsoft Exchange, automating operations, downloading data, and more.
-
Create Salesforce CRM Analytics-Connected Nintex Workflows
Use CData Connect AI to connect to Salesforce CRM Analytics Data from Nintex Workflow Cloud and build custom workflows using live Salesforce CRM Analytics.
-
Design BIRT Reports on Vault CRM Data
Provide current Veeva Vault & Vault CRM to your embedded analytics.
-
Build Power BI XMLA-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Power BI XMLA.
-
Automated Continuous PolarTeamPro Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Google Cloud SQL.
-
How to Connect to Live SAS xpt 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 SAS XPORT for you.
-
Connect to Jumpseller Data in Ruby
Connect to Jumpseller in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Consume Amazon Athena OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon Athena as OData feeds from PowerBuilder using the API Server.
-
Connect to Suadeo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Suadeo from Appeon PowerBuilder using the CData ADO.NET Provider for Suadeo.
-
Connect SuiteCRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SuiteCRM with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Controls to Oracle Data in C++Builder
DataBind to Oracle Database in C++Builder with standard components and controls.
-
How to Query Live Pingdom Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pingdom data in natural language using Python.
-
Automate Email Data Replication to Azure Data Lake
Use CData Sync to customize and automate Email replication to Azure Data Lake.
-
Connect to Workday Data from a Connection Pool in JBoss
Integrate Workday into Java servlets: Use the Management Console in JBoss to install the Workday JDBC Driver.
-
Integrate FreshBooks with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FreshBooks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FreshBooks.
-
Bind Live GraphQL Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live GraphQL data
-
Build Semantic Layer Views for SendPulse Data in APOS Live Data Gateway
Use the CData Connector for SendPulse in APOS Live Data Gateway to build Semantic Layer Views for SendPulse.
-
Publish PDFMonkey-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PDFMonkey.
-
Connect Miro Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Miro using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Building Dynamic Web Pages with Cvent Data Using AngularJS
Create single-page applications with live connectivity to Cvent using the CData API Server.
-
Build an OLAP Cube in SSAS from SAP ByDesign Data
Establish a connection to SAP Business ByDesign data from SQL Server Analysis Services, and use the SAP ByDesign Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Dashboards with Yelp Data in Dundas BI
Create dynamic dashboards and perform analytics based on Yelp in Dundas BI.
-
Connect to Google Search Results in HULFT Integrate
Connect to Google Search as a JDBC data source in HULFT Integrate
-
How to use SQLAlchemy ORM to access Yelp Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Yelp.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Amazon Athena
Provide connectivity to Amazon Athena through an SAP BusinessObjects universe.
-
Query Redshift Data as a MySQL Database in Node.js
Execute MySQL queries against Amazon Redshift from Node.js.
-
Getting Started with the CData Power BI Connector for Wrike
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Query ZohoDesk Data in MySQL Workbench
Execute MySQL queries against live ZohoDesk from MySQL Workbench.
-
Getting Started with the CData Excel Add-In for Anaplan
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Anaplan.
-
Use the CData Software ODBC Driver for Email in MicroStrategy Desktop
Connect to Email in MicroStrategy Desktop using the CData Software ODBC Driver for Email.
-
Access Live Microsoft Exchange Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Exchange in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create a Data Access Object for Impala Data using JDBI
A brief overview of creating a SQL Object API for Apache Impala in JDBI.
-
How to integrate NetSuite with Apache Airflow
Access and process NetSuite CRM & ERP in Apache Airflow using the CData JDBC Driver.
-
Bidirectional Access to Perigon Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Perigon in Filemaker Pro for Mac or Windows.
-
Automated Continuous Zoho Creator Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Databricks.
-
Use JayDeBeApi to access Tavily Data in Python
Use standard Python scripting and the development environment of your choice to access live Tavily.