CData Software - Knowledge Base
Recent Articles
-
Automate Certinia Data Replication to SAP HANA
Use CData Sync to customize and automate Certinia data replication to SAP HANA.
-
Integrate Odoo Data in the Pentaho Report Designer
Publish reports based on Odoo data in the Pentaho BI tool.
-
Integrate Devin with Live SAP Ariba Source Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SAP Ariba Source data.
-
Create Dynamic Klaviyo Grids Using the Infragistics XamDataGrid
Learn how you can connect Klaviyo to Infragistics XamDataGrid to build dynamic grids.
-
Interact with Live Freshteam Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Freshteam data.
-
Build Agents in Relevance AI with Access to Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Kintone data within intelligent agent workflows.
-
Integrate Live Aweber Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Aweber from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Aweber data.
-
A PostgreSQL Interface for Amazon Marketplace Data using the CData ODBC Driver
Use the SQL Gateway and Amazon Marketplace ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations Based On SAP Netweaver Gateway Data in Mode
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Mode and build visualizations using live SAP Netweaver Gateway data.
-
Connect to Mixpanel Data in JRuby
Create a simple JRuby app with access to live Mixpanel data.
-
How to connect and process ZohoMarketingHub data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZohoMarketingHub data.
-
Create Data Visualizations in Cognos BI with Anaplan Data
Access Anaplan data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Apps from IBM Informix Data in Qlik Sense Cloud
Use CData Connect AI to connect to IBM Informix Data and build apps from live IBM Informix data in Qlik Sense Cloud.
-
Connect to Cassandra Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Cassandra Data and connect to Cassandra data in Akorbi Digital RunMyProcess.
-
Build Voice Agents in ElevenLabs with access to Live AfterShip Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live AfterShip data.
-
Use Microsoft Copilot Studio to talk to your Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Asana data for you.
-
Getting Started with the CData ADO.NET Provider for LDAP
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for LDAP.
-
Explore Geographical Relationships in Shopify Data with Power Map
Create data visualizations with Shopify data in Power Map.
-
Query Oracle Service Cloud Data in DataGrip
Create a Data Source for Oracle Service Cloud in DataGrip and use SQL to query live Oracle Service Cloud data.
-
Automate Google Cloud Storage Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Cloud Storage data from PowerShell? This article demonstrates how to utilize the Google Cloud Storage Cmdlets for tasks like connecting to Google Cloud Storage data, automating operations, downloading data, and more.
-
Integrating Marketo Data in Talend Cloud Data Management Platform
Connect Marketo Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Marketo.
-
Establish a Live Connection with Amazon Athena Data using Tableau Bridge
The CData ODBC Driver for Amazon Athena enables you to integrate live Amazon Athena data into Tableau Cloud dashboards using the Tableau Bridge.
-
Working with ActiveCampaign Data in LINQPad
Execute LINQ queries to ActiveCampaign data in LINQPad.
-
Connect to Figshare Data in ACL Analytics
Connect to Figshare data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Figshare data.
-
Build Data Flows from SQL Server to Salesforce through SSIS
Easily push SQL Server data to Salesforce using the CData SSIS Tasks for Salesforce.
-
Analyze Snapchat Ads Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Snapchat Ads data in Microsoft R Open.
-
Query Calendly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Calendly data from Node.js.
-
Build Dashboards with Tanda Data in DBxtra
Create dynamic dashboards and perform analytics based on Tanda data in DBxtra.
-
How to work with SuiteCRM Data in Apache Spark using SQL
Access and process SuiteCRM Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to SAP BusinessObjects BI Data in DBArtisan
Use wizards in DBArtisan to configure SAP BusinessObjects BI data as a data source.
-
Connect to Instagram Data from AWS Glue
Use CData Connect AI to gain access to live Instagram data from your AWS Glue jobs.
-
Jira Assets Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Jira Assets data through CData Connect AI using different applications and tools.
-
Create Azure Analysis Services-Connected Nintex Workflows
Use CData Connect AI to connect to Azure Analysis Services Data from Nintex Workflow Cloud and build custom workflows using live Azure Analysis Services data.
-
Connect to and Visualize Live Keap Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Keap data.
-
Getting Started with the CData JDBC Driver for Omnisend
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Omnisend.
-
Replicate Figshare Data to Multiple Databases via the CData Sync CLI
Replicate Figshare data to disparate databases with a single configuration.
-
Visualize ShipEngine Data in Tableau
The CData ODBC driver for ShipEngine enables you integrate ShipEngine data into Tableau dashboards.
-
Getting Started with the CData Tableau Connector for Exact Online
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Exact Online.
-
Integrate Cursor with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Freshservice data from within the editor.
-
Use Databricks Agent Bricks to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your MYOB AccountRight data for you.
-
Visualize Reckon Accounts Hosted Data in Tableau
The CData ODBC driver for Reckon Accounts Hosted enables you integrate Reckon Accounts Hosted data into Tableau dashboards.
-
Automated Continuous Webflow Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Webflow replication to Azure SQL Database.
-
Create Data Visualizations in Cognos BI with Sage 200 Data
Access Sage 200 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Oracle SCM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle SCM data.
-
Lakebase Reporting in OBIEE with the Lakebase JDBC Driver
Deploy the Lakebase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Google Analytics Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Analytics replication to delimited files (CSV/TSV).
-
Build Semantic Layer Views for Pushbullet Data in APOS Live Data Gateway
Use the CData Connector for Pushbullet in APOS Live Data Gateway to build Semantic Layer Views for Pushbullet data.
-
Model, Search, and Visualize Live PayPal Data in ThoughtSpot
Use CData Connect AI to connect to live PayPal data for modeling, searching, and visualizing.
-
Integrate Couchbase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Couchbase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Couchbase data.
-
How to Connect the Power BI Service to Spotify: Complete Guide
Connect to the CData Software Power BI Connector for Spotify from PowerBI.com to provide real-time Spotify data across the organization.
-
Connect to Confluence Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Confluence data from Filemaker Pro on Mac.
-
How to Query QuickBooks Data in MySQL Workbench
Execute MySQL queries against live QuickBooks data from MySQL Workbench.
-
Integrate SAP Business Warehouse Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Business Warehouse data from Informatica Cloud.
-
Connect to Act-On Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Act-On.
-
Object-Relational Mapping (ORM) with ZohoDesk 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 ZohoDesk data into a Java-based ORM framework, Hibernate.
-
Access Live Demio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Demio data into the statistical analysis tools available in SAS JMP. This article shows how to use Demio data in the Graph Builder and Query Builder.
-
Connect to Datadog Data in Aqua Data Studio
Access Datadog data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from Raisers Edge NXT to Google BigQuery using CData SSIS Components.
Easily push Raisers Edge NXT data to Google BigQuery using the CData SSIS Tasks for Raisers Edge NXT and Google BigQuery.
-
Access Live ZohoInvoice Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZohoInvoice data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query Live ZohoSubscriptions Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoSubscriptions data data in natural language using Python.
-
Stream Invoiced Data into Apache Kafka Topics
Access and stream Invoiced data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
FreeAgent Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on FreeAgent facts in real time.
-
How to Use a Microsoft Access Database to Update Google Ad Manager Data in Real Time
Update Google Ad Manager data by creating a linked table in Microsoft Access with the CData Google Ad Manager ODBC Driver.
-
Excel Spreadsheet Automation on Presto Data with the QUERY Formula
Pull data from Presto, automate spreadsheets, and more with the QUERY formula.
-
ETL Azure Table in Oracle Data Integrator
This article shows how to transfer Azure Table data into a data warehouse using Oracle Data Integrator.
-
Building Dynamic Web Pages with Epicor Kinetic Data Using AngularJS
Create single-page applications with live connectivity to Epicor Kinetic using the CData API Server.
-
Migrating data from SurveyMonkey to Snowflake using CData SSIS Components.
Easily push SurveyMonkey data to Snowflake using the CData SSIS Tasks for SurveyMonkey and Snowflake.
-
Build AI Agents with Gmail Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Gmail data through CData Connect AI.
-
Automate JotForm Data Replication to Couchbase
Use CData Sync to Customize and automate JotForm data replication to Couchbase.
-
Build Visualizations of Tickspot Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Tickspot data in Birst.
-
Connect to WordPress Data in RazorSQL
Connect to WordPress from wizards and query WordPress data from the GUI in the RazorSQL database management tool.
-
Access Live SAP Ariba Procurement Data in AWS Lambda
Connect to live SAP Ariba Procurement data in AWS Lambda using the CData JDBC Driver.
-
How to Work with Freshdesk Data in AWS Glue Jobs Using JDBC
Connect to Freshdesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize SAP Data in TIBCO Spotfire through OData
Integrate SAP data into dashboards in TIBCO Spotfire.
-
Connect to SAP BusinessObjects BI Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP BusinessObjects BI and the Script function in FileMaker Pro to connect to SAP BusinessObjects BI and work with SAP BusinessObjects BI data in your FileMaker application.
-
Automate Google Directory Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Directory data from PowerShell? This article demonstrates how to utilize the Google Directory Cmdlets for tasks like connecting to Google Directory data, automating operations, downloading data, and more.
-
Link Auth0 with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Auth0 data in Filemaker Pro for Mac or Windows.
-
Process & Analyze SendInBlue Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SendInBlue Data.
-
Build Agents in Relevance AI with Access to Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Jira data within intelligent agent workflows.
-
Connect to OData Services as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for OData services.
-
Create Dynamic Jira Grids Using the Infragistics XamDataGrid
Learn how you can connect Jira to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Microsoft Teams Data to Multiple Databases
Replicate Microsoft Teams data to disparate databases with a point-and-click configuration.
-
Integrating OpenCode with Onfleet 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 Crystal Reports on Vimeo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Vimeo data.
-
Integrate Live eBay Analytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to eBay Analytics data and integrate live eBay Analytics data into apps built in Microsoft Power Apps.
-
Replicate Klipfolio Data in Heroku for Use in Salesforce Connect
Replicate Klipfolio data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Apps with Live Rebilly Data Using the Low-Code Development Platform of Mendix
Connect Rebilly data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Build an ETL App for Flowlu Data in Python with CData
Create ETL applications and real-time data pipelines for Flowlu data in Python with petl.
-
How to Connect the Power BI Service to Zoho Books: Complete Guide
Connect to the CData Software Power BI Connector for Zoho Books from PowerBI.com to provide real-time Zoho Books data across the organization.
-
Visualize Live Toggl Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Toggl data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Sentry Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sentry to connect to Sentry data and execute queries in PowerBuilder.
-
Integrate Mistral AI Data in Pentaho Data Integration
Build ETL pipelines based on Mistral AI data in the Pentaho Data Integration tool.
-
Query Okta Data as a SQL Server Database in Node.js
Execute SQL Server queries against Okta data from Node.js.
-
Access Live Clio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Clio data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Apps with Live SQL Analysis Services Data Using the Low-Code Development Platform of Mendix
Connect SQL Analysis Services data with Mendix to build apps using the CData JDBC Driver for SQL Analysis Services.
-
Connect to ActiveCampaign Data in Google Apps Script via Connect AI
Use CData Connect AI to access ActiveCampaign data in Google Apps Script.
-
Connect to SageHR Data in Google Apps Script via Connect AI
Use CData Connect AI to access SageHR data in Google Apps Script.
-
Replicate Brex Data in Heroku for Use in Salesforce Connect
Replicate Brex data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Apps with Live Campaigner data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Campaigner data into the Adalo platform and build custom mobile and web applications with real-time Campaigner data.
-
Rapidly Develop Aweber-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 Aweber.