CData Software - Knowledge Base
Recent Articles
-
Connect to GitHub Data from a Connection Pool in JBoss
Integrate GitHub data into Java servlets: Use the Management Console in JBoss to install the GitHub JDBC Driver.
-
Getting Started with the CData JDBC Driver for Gmail
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Gmail.
-
How to Access Elorus Data Using Entity Framework
This article shows how to access Elorus data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software JDBC Driver for Apify in MicroStrategy
Connect to Apify data in MicroStrategy Developer using the CData Software JDBC Driver for Apify.
-
Connect to Live Outreach.io Data in MicroStrategy through CData Connect AI
Create a live connection to Outreach.io Data in CData Connect AI and connect to your Outreach.io data from MicroStrategy.
-
Access Live Mistral AI Data in AWS Lambda
Connect to live Mistral AI data in AWS Lambda using the CData JDBC Driver.
-
Create Email-Connected Nintex Workflows
Use CData Connect AI to connect to Email Data from Nintex Workflow Cloud and build custom workflows using live Email data.
-
Connect to Onfleet Data in RapidMiner
Integrate Onfleet data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Shortcut Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Shortcut data and visualize Shortcut data in SAP Analytics Cloud.
-
Build Automated Paylocity-Connected Workflows in Zapier
Use CData Connect AI to connect to live Paylocity data and build automated workflows in Zapier.
-
Analyze Klaviyo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Klaviyo data and visualize Klaviyo data in SAP Analytics Cloud.
-
Build a PostgreSQL Interface for Sendwithus Data using the CData JDBC Driver
Use the Remoting features of the Sendwithus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple Greenhouse Accounts via the CData Sync CLI
Replicate multiple Greenhouse accounts to one or many databases.
-
Connect to Apollo Data in ACL Analytics
Connect to Apollo data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apollo data.
-
Integrate Impala Data in Pentaho Data Integration
Build ETL pipelines based on Impala data in the Pentaho Data Integration tool.
-
Use the CData Software ODBC Driver for MailChimp in MicroStrategy
Connect to MailChimp data in MicroStrategy Developer using the CData Software ODBC Driver for MailChimp.
-
Access eBay Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access eBay data from your Oracle system.
-
Build Stripe-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Stripe data and build Stripe-connected web apps with Axios.
-
Integrate Dify with Live Amazon Athena Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Amazon Athena data.
-
Working with SAP SuccessFactors LMS Data in LINQPad
Execute LINQ queries to SAP SuccessFactors LMS data in LINQPad.
-
Build Pipelines with Live Azure Data Lake Storage Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure Data Lake Storage from Google Cloud Data Fusion, enabling the integration of live Azure Data Lake Storage data into the building and management of effective data pipelines.
-
Integrate with QuickBooks Data in SnapLogic
Use CData Connect AI to connect to and integrate with live QuickBooks data in SnapLogic.
-
Use the CData ODBC Driver for Google Directory from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Directory to connect to Google Directory data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Directory data in Excel.
-
Automated Continuous CapsuleCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to delimited files (CSV/TSV).
-
Automated Continuous Oracle Eloqua Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Eloqua data replication to OneLake in Microsoft Fabric.
-
Integrating OpenCode with Pinterest 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.
-
Analyze Live Xero Data in SAS Viya
Use CData Connect AI to connect to Xero data from SAS Viya and deploy self-service analytics using live Xero data.
-
Stream Sybase IQ Data into Apache Kafka Topics
Access and stream Sybase IQ data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build an OLAP Cube in SSAS from Tanda Data
Establish a connection to Tanda data data from SQL Server Analysis Services, and use the Tanda Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Parallel in SAS for Real-Time Reporting and Analytics
Connect to real-time Parallel data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Parallel.
-
Operational Reporting on Highrise Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Highrise data.
-
Create Informatica Mappings From/To a JDBC Data Source for PDFMonkey
Create PDFMonkey data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Visualizations of Google Calendar Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Calendar data in Birst.
-
Rapidly Develop Shortcut-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 Shortcut.
-
Connect to Gumroad Data in RapidMiner
Integrate Gumroad data with standard components and data source configuration wizards in RapidMiner Studio.
-
Operational Reporting on Unbounce Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Unbounce data.
-
Use the CData Software JDBC Driver for Acumatica in MicroStrategy Desktop
Connect to Acumatica data in MicroStrategy Desktop using the CData Software JDBC Driver for Acumatica.
-
Automated Continuous Odoo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Odoo replication to Snowflake.
-
Configure the CData JDBC Driver for FHIR in a Connection Pool in Tomcat
Connect to FHIR data from a connection pool in Tomcat.
-
Connect to Everhour Data in NetBeans
Connect to Everhour data in NetBeans with the data source configuration wizard.
-
Analyze Timely Data in Looker
Use CData Connect AI to connect to Timely Data from Looker and build custom apps using live Timely data.
-
Connect to Supabase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Supabase Data and connect to Supabase data in Akorbi Digital RunMyProcess.
-
Connect FreeAgent to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect FreeAgent with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Oracle HCM Cloud Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle HCM Cloud and the SQL Gateway to access Oracle HCM Cloud data from Google Apps Script.
-
Publish Pipeline CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pipeline CRM data.
-
How to work with Yelp Data in Apache Spark using SQL
Access and process Yelp Data in Apache Spark using the CData Software JDBC Driver.
-
ETL Microsoft Teams in Oracle Data Integrator
This article shows how to transfer Microsoft Teams data into a data warehouse using Oracle Data Integrator.
-
How to connect to ChartMogul Data in DBVisualizer
Integrate ChartMogul data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Work with Mistral AI Data in AWS Glue Jobs Using JDBC
Connect to Mistral AI from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Google's Antigravity Agent with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Freshservice data using the Model Context Protocol.
-
Create Dashboards and Visualize Live Outreach.io Data in Geckoboard
Use CData Connect AI to connect to live Outreach.io data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Datadog Data in RazorSQL
Connect to Datadog from wizards and query Datadog data from the GUI in the RazorSQL database management tool.
-
How to Access Slack Data Using Entity Framework
This article shows how to access Slack data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to create Visio diagrams from Box Data
Automatically update Box data with the changes you make to Visio master shapes.
-
Configure the CData JDBC Driver for Planio in a Connection Pool in Tomcat
Connect to Planio data from a connection pool in Tomcat.
-
Connect to Power BI XMLA Data in Claris FileMaker Pro
Use the CData ODBC Driver for Power BI XMLA in FileMaker Pro to connect to Power BI XMLA and work with Power BI XMLA data in your FileMaker applications.
-
How to use SQLAlchemy ORM to access Dynamics 365 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dynamics 365 data.
-
Connect to Google Contacts Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Contacts data from Appeon PowerBuilder using the CData ADO.NET Provider for Google Contacts.
-
Create a Data Access Object for Oracle Service Cloud Data using JDBI
A brief overview of creating a SQL Object API for Oracle Service Cloud data in JDBI.
-
Connect to MailerLite Data from HeidiSQL
Use CData Connect AI to connect to and query live MailerLite data from HeidiSQL.
-
Operational Reporting on RSS Feeds from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote RSS feeds.
-
Connect to and Query Mailgun Data in QlikView over ODBC
Create data visualizations with Mailgun data in QlikView.
-
Integrate eBay Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live eBay Analytics data from Informatica Cloud.
-
Viewing QuickBooks Online Data in RAD Studio Data Explorer
How to view QuickBooks Online data in RAD Studio Data Explorer using the CData ODBC Driver for QuickBooks Online.
-
Build AI Agents with Certinia 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 Certinia data through CData Connect AI.
-
How to Connect to & Open Oracle Sales Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Sales to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Google Contacts Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Contacts data and build visualizations in Tableau Cloud.
-
A PostgreSQL Interface for SendGrid Data (MySQL Remoting via JDBC)
Use the Remoting features of the SendGrid JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live Mouseflow Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mouseflow data data in natural language using Python.
-
Access Live Rootly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Rootly data into the statistical analysis tools available in SAS JMP. This article shows how to use Rootly data in the Graph Builder and Query Builder.
-
Prepare, Blend, and Analyze WooCommerce Data in Alteryx Designer (Connect AI)
Build workflows to access live WooCommerce data for self-service data analytics.
-
Query Live Monday.com Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Monday.com data through a conversational interface.
-
Access Parallel Data from MySQL in PHP
Connect to Parallel through the standard MySQL libraries in PHP.
-
How to Connect the Power BI Service to OData: Complete Guide
Connect to the CData Software Power BI Connector for OData from PowerBI.com to provide real-time OData services across the organization.
-
Work with DB2 Data in FoxPro
Load DB2 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Model, Search, and Visualize Live Guru Data in ThoughtSpot
Use CData Connect AI to connect to live Guru data for modeling, searching, and visualizing.
-
Replicate Shopify Data in Heroku for Use in Salesforce Connect
Replicate Shopify data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to ZohoInvoice Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoInvoice as an External Source in Dremio.
-
Build Reckon Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Reckon data and build visualizations in Tableau.
-
How to Seamlessly Import Zoho Creator Data into IBM SPSS Modeler
Integrate Zoho Creator data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import and Visualize GitHub Data in Power View
Create data visualizations based on GitHub data in Excel.
-
Connect to SingleStore Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SingleStore and the Script function in FileMaker Pro to connect to SingleStore and work with SingleStore data in your FileMaker application.
-
Build Visualizations of Salesloft Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesloft data in Birst.
-
Integrate LibreChat with Live ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ZohoInvoice data from within the chat interface.
-
Access Live Klaviyo Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Klaviyo data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Deploy the ADO.NET Provider for Drip on an SSRS Report Server
Connect to Drip data 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 Marketo Data in Pentaho Data Integration
Build ETL pipelines based on Marketo data in the Pentaho Data Integration tool.
-
How to Connect to & Open Workable Data in Microsoft Excel
This article uses the CData ODBC driver for Workable to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous QuickBooks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks replication to Amazon Redshift.
-
Automated Continuous Factorial Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Factorial replication to Google BigQuery.
-
Create SSAS Tabular Models from Zuora Data
How to build a SQL Server Analysis Service Tabular Model from Zuora data using CData drivers.
-
Access Live MongoDB Data in TIBCO Data Virtualization
Use the MongoDB Tibco DV Adapter to create a MongoDB data data source in TIBCO Data Virtualization Studio and gain access to live MongoDB data from your TDV Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Freshdesk
Create Freshdesk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Excel Add-In for Mailgun
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mailgun.
-
Connect to Ontraport Data in DBArtisan
Use wizards in DBArtisan to configure Ontraport data as a data source.
-
Replicate Multiple LaunchDarkly Accounts
Replicate multiple LaunchDarkly accounts to one or many databases.
-
Integrate with Jira Assets Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Jira Assets data to a JSON file on disk.
-
Analyze Slack Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Slack from Power Pivot. You will use the Table Import Wizard to load Slack data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Zendesk Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zendesk data without replication.
-
Using the CData Software ODBC Driver for Oracle Financials Cloud in PyCharm
Connect to Oracle Financials Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Financials Cloud.