CData Software - Knowledge Base
Recent Articles
-
Natively Connect to FHIR Data in PHP
The CData ODBC driver for FHIR enables you to create PHP applications with connectivity to FHIR. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Discord 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 Discord into a Java-based ORM framework, Hibernate.
-
LINQ to Bullhorn CRM 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 Bullhorn CRM Data Provider.
-
How to Connect to & Open PingOne Data in Microsoft Excel
This article uses the CData ODBC driver for PingOne to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Using the CData Software ODBC Driver for BigQuery in PyCharm
Connect to BigQuery as an ODBC data source in PyCharm using the CData Software ODBC Driver for BigQuery.
-
Connect to SQL Server Data in Ruby
Connect to Microsoft SQL Server in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to OData Services from AWS Glue
Use CData Connect AI to gain access to live OData from your AWS Glue jobs.
-
Bidirectional Access to Vault CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Veeva Vault & Vault CRM in Filemaker Pro for Mac or Windows.
-
Build AI/ML Models with Live FTP Data using Dataiku
Connect FTP Data with Dataiku using the CData JDBC Driver for FTP.
-
Integrating Kiro CLI with SAP Ariba Source 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.
-
Automated Continuous Google Campaign Manager 360 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MongoDB.
-
Load Bugsnag Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bugsnag to a database.
-
How to work with SAP Fieldglass Data in Apache Spark using SQL
Access and process SAP Fieldglass Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Snapchat Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Snapchat Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Agents in Relevance AI with Access to Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sybase IQ within intelligent agent workflows.
-
Automate Dynamics 365 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Dynamics 365 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Build an ETL App for Email Data in Python with CData
Create ETL applications and real-time data pipelines for Email in Python with petl.
-
Moving Data from Oracle SCM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle SCM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI Agents with SAP Business One 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 SAP Business One through CData Connect AI.
-
Access Raisers Edge NXT Data from MySQL in Amazon QuickSight
Connect to Raisers Edge NXT and build visualizations of Raisers Edge NXT using a MySQL Connection in Amazon QuickSight.
-
Connect to Google Ads Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Ads.
-
Build Data Flows from Opsgenie to SQL Server using SSIS
Easily back up Opsgenie to SQL Server using the SSIS components for Opsgenie.
-
Moving Data from Printful to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Printful data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Object-Relational Mapping (ORM) with CSV 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 CSV/TSV Files into a Java-based ORM framework, Hibernate.
-
DataBind Controls to Chargebee Data in Delphi
DataBind to Chargebee in Delphi with standard data access components and controls.
-
Operational Reporting on Hubstaff Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Hubstaff.
-
Integrating Boomi Agentstudio with Google Search Results via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Search, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData Excel Add-In for Aha!
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Aha!.
-
Connect to CapsuleCRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CapsuleCRM.
-
Automated Continuous Egnyte Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Egnyte replication to Amazon Redshift.
-
Opsgenie Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Opsgenie facts in real time.
-
Build Apps with Live Couchbase in Adalo using CData Connect AI
Use CData Connect AI to integrate live Couchbase into the Adalo platform and build custom mobile and web applications with real-time Couchbase.
-
Connect to Email Data in Claris FileMaker Pro
Use the CData ODBC Driver for Email in FileMaker Pro to connect to Email and work with Email in your FileMaker applications.
-
Publish CockroachDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CockroachDB.
-
Connect to and Query eBay Analytics Data in QlikView over ODBC
Create data visualizations with eBay Analytics in QlikView.
-
Validate Gong Data with QuerySurge
Access and validate Gong in QuerySurge using the CData JDBC Driver.
-
Replicate Authorize.Net Data to Multiple Databases
Replicate Authorize.Net to disparate databases with a point-and-click configuration.
-
Create a Data Access Object for Gorgias Data using JDBI
A brief overview of creating a SQL Object API for Gorgias in JDBI.
-
Consume Mouseflow OData Feeds in PowerBuilder
This article demonstrates how to consume Mouseflow as OData feeds from PowerBuilder using the API Server.
-
Automate Invoiced Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Invoiced from PowerShell? This article demonstrates how to utilize the Invoiced Cmdlets for tasks like connecting to Invoiced, automating operations, downloading data, and more.
-
How to Access Live GetResponse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for GetResponse enables you to integrate GetResponse into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code with Jira Assets Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Jira Assets within assisted coding and automated development workflows.
-
Build Automated Salesforce Pardot-Connected Workflows in Zapier
Use CData Connect AI to connect to live Salesforce Pardot and build automated workflows in Zapier.
-
Publish ZohoSubscriptions-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoSubscriptions.
-
How to load Calendly data into Elasticsearch via Logstash
Introducing a simple method to load Calendly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use JayDeBeApi to access Invoiced Data in Python
Use standard Python scripting and the development environment of your choice to access live Invoiced.
-
Replicate Multiple LinkedIn Ads Accounts via the CData Sync CLI
Replicate multiple LinkedIn Ads accounts to one or many databases.
-
Build Automated Asana-Connected Workflows in Zapier
Use CData Connect AI to connect to live Asana and build automated workflows in Zapier.
-
Model, Search, and Visualize Live Elasticsearch Data in ThoughtSpot
Use CData Connect AI to connect to live Elasticsearch for modeling, searching, and visualizing.
-
Connect to Todoist Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Todoist using standard SQL.
-
Use the CData ODBC Driver for Planio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Planio to connect to Planio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Planio in Excel.
-
Query Live NetSuite SuiteAnalytics Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live NetSuite SuiteAnalytics directly from the development environment.
-
Create Informatica Mappings From/To an ODBC Data Source for HDFS
Create an ODBC connection to HDFS in Informatica and browse and transfer Apache HDFS.
-
Provide OData Services of Microsoft Teams Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Teams by developing a WCF Service Application.
-
Publish Crystal Reports on CockroachDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CockroachDB.
-
How to Connect the Power BI Service to BambooHR: Complete Guide
Connect to the CData Software Power BI Connector for BambooHR from PowerBI.com to provide real-time BambooHR across the organization.
-
Integrate with Highrise Data in JReport Designer
Create charts and reports based on Highrise CRM in JReport Designer.
-
Automated Continuous Perplexity Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Perplexity replication to Amazon Redshift.
-
Integrate Freshsales Data in Pentaho Data Integration
Build ETL pipelines based on Freshsales in the Pentaho Data Integration tool.
-
Integrate Real-Time Access to SAS Data Sets in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAS Data Sets in real time.
-
Integrate Live SAP Ariba Source Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Ariba Source from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Ariba Source.
-
Connect to Okta Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Okta using standard SQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Mistral AI to Power BI dashboards. Simply drag and drop Mistral AI into data visuals on the Power BI canvas.
-
How to Connect to Live Google Spanner 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 Google Spanner for you.
-
Connect to Jira Data in Jaspersoft Studio
Execute SQL to remote Atlassian Jira in Jaspersoft Studio.
-
Import and Visualize YouTube Analytics Data in Power View
Create data visualizations based on YouTube Analytics in Excel.
-
Edit and Search Miro External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Miro to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Miro objects that you can access from apps and the dashboard.
-
Feed MailerLite Data into FineReport
How to set MailerLite as a JDBC data source in FineReport.
-
Back Up Vercel to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Vercel data.
-
Import Real-Time SAP Hybris C4C Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Hybris C4C in ColdFusion.
-
Extend Google Sheets with Zoom Data
Make calls to Zoom from Google Apps Script via the API Server.
-
How to create Perplexity federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Perplexity in MySQL .
-
Visualize ShipStation Data in TIBCO Spotfire through OData
Integrate ShipStation into dashboards in TIBCO Spotfire.
-
Connect to Outreach.io Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Outreach.io and the Script function in FileMaker Pro to connect to Outreach.io and work with Outreach.io in your FileMaker application.
-
How to Work with Greenhouse Data in ETL Validator JDBC
Connect to Greenhouse from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating GitHub Copilot CLI with Apache Kafka 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.
-
Integrating LlamaIndex with Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoho Projects in real time.
-
Natively Connect to Bullhorn CRM Data in PHP
The CData ODBC driver for Bullhorn CRM enables you to create PHP applications with connectivity to Bullhorn CRM. Leverage the native support for ODBC in PHP.
-
Operational Reporting on LinkedIn Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LinkedIn.
-
Build Data Flows from SQL Server to OneNote through SSIS
Easily push SQL Server data to OneNote using the CData SSIS Tasks for OneNote.
-
Process & Analyze Workday Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Workday Data.
-
Integrate Live Oracle Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use the CData Software ODBC Driver for Paymo in MicroStrategy
Connect to Paymo in MicroStrategy Developer using the CData Software ODBC Driver for Paymo.
-
Build Dashboards with OneNote Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft OneNote in Dundas BI.
-
Publish Reports with Attio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Attio.
-
How to Connect the Power BI Service to Gmail: Complete Guide
Connect to the CData Software Power BI Connector for Gmail from PowerBI.com to provide real-time Gmail across the organization.
-
Build Semantic Layer Views for Mailjet Data in APOS Live Data Gateway
Use the CData Connector for Mailjet in APOS Live Data Gateway to build Semantic Layer Views for Mailjet.
-
Build a PostgreSQL Interface for Jira Assets Data using the CData JDBC Driver
Use the Remoting features of the Jira Assets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Printify Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Printify from your Oracle system.
-
Create Reports from Cloudant Data in Looker Studio
Use CData Connect AI to gain access to live IBM Cloudant and create custom reports in Looker Studio.
-
Working with ChartMogul Data in LINQPad
Execute LINQ queries to ChartMogul in LINQPad.
-
Migrating data from Printful to Google BigQuery using CData SSIS Components.
Easily push Printful to Google BigQuery using the CData SSIS Tasks for Printful and Google BigQuery.
-
How to Seamlessly Import Typeform Data into IBM SPSS Modeler
Integrate Typeform data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Cursor with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Eloqua from within the editor.
-
Shopify Reporting in OBIEE with the Shopify JDBC Driver
Deploy the Shopify JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Access Live GitLab Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live GitLab from the Cline extension in Visual Studio Code.
-
How to Connect the Power BI Service to Wrike: Complete Guide
Connect to the CData Software Power BI Connector for Wrike from PowerBI.com to provide real-time Wrike across the organization.
-
Automated Continuous Mailgun Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mailgun replication to SingleStore.
-
Automated Continuous Drip Replication to MySQL
Use CData Sync for automated, continuous, customizable Drip replication to MySQL.
-
Automated Continuous Salesforce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce replication to SQL Server.