CData Software - Knowledge Base
Recent Articles
-
Migrating data from Google Translate to Google BigQuery using CData SSIS Components.
Easily push Google Translate to Google BigQuery using the CData SSIS Tasks for Google Translate and Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Reckon
Provide connectivity to Reckon through an SAP BusinessObjects universe.
-
Visualize Pingdom Data in TIBCO Spotfire through ADO.NET
Integrate Pingdom into dashboards in TIBCO Spotfire.
-
Build Data Flows from SAP Ariba Source to SQL Server using SSIS
Easily back up SAP Ariba Source to SQL Server using the SSIS components for SAP Ariba Source.
-
View Reports on Real-Time Pipeline CRM Data in Power BI Report Server
Use the CData ODBC Driver for Pipeline CRM to visualize Pipeline CRM in Power BI Desktop and then publish them to Power BI Report Server.
-
How to create an RPA flow for HDFS Data in UiPath Studio
Use the HDFS ODBC Driver to create workflows that access real-time Apache HDFS without any coding.
-
Build Semantic Layer Views for ShipEngine Data in APOS Live Data Gateway
Use the CData Connector for ShipEngine in APOS Live Data Gateway to build Semantic Layer Views for ShipEngine.
-
Build Visualizations of OpenWeatherMap Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of OpenWeatherMap in Birst.
-
How to Work with Paymo Data in ETL Validator JDBC
Connect to Paymo from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Codat Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Codat in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize SAP Fieldglass 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 SAP Fieldglass into TIBCO Spotfire.
-
DataBind Vimeo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Vimeo to a chart.
-
How to work with Twitter Ads Data in Apache Spark using SQL
Access and process Twitter Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Google Sheets in SpagoBI
Create reports featuring live Google Sheets in SpagoBI Studio. Host Google Sheets reports on SpagoBI Server.
-
Build a Singer.io Tap for Vimeo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Vimeo data using
-
Connecting Pipedream with Amazon Athena Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Amazon Athena data in real time.
-
Prepare, Blend, and Analyze Qualaroo Data in Alteryx Designer (ODBC)
Build workflows to access live Qualaroo for self-service data analytics.
-
Build AI/ML Models with Live Kafka Data using Dataiku
Connect Kafka Data with Dataiku using the CData JDBC Driver for Kafka.
-
How to connect to Paddle Data from IntelliJ
Integrate connectivity to Paddle with wizards in IntelliJ.
-
Easily Integrate Oracle Eloqua Reporting Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Eloqua Reporting in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Python Connector for Everhour
Learn to install and license the CData Python Connector
-
Rapidly Develop SendGrid-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 SendGrid.
-
Automated Continuous Mailgun Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mailgun replication to Apache Kafka.
-
Connect to Webex Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Webex as an External Source in Dremio.
-
Connect to and Query Clio Data in QlikView over ODBC
Create data visualizations with Clio in QlikView.
-
Access ConvertKit Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ConvertKit.
-
Connect to Reply.io Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Reply.io in the Denodo Virtual DataPort Administrator.
-
Object-Relational Mapping (ORM) with SAP SuccessFactors 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 SAP SuccessFactors into a Java-based ORM framework, Hibernate.
-
Connect to SingleStore Data from a Connection Pool in JBoss
Integrate SingleStore into Java servlets: Use the Management Console in JBoss to install the SingleStore JDBC Driver.
-
Connect to SuiteCRM Data in DBeaver
Use the CData ODBC Driver to connect to SuiteCRM in DBeaver.
-
Back Up Short.io 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 Short.io data.
-
Connect to CircleCI from Asprova with CData Software ODBC Driver for CircleCI
This article shows how to connect faster to CircleCI data from Asprova.
-
Connect to MailerLite Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MailerLite as an External Source in Dremio.
-
Build a Singer.io Tap for SAP SuccessFactors LMS With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP SuccessFactors LMS data using
-
Connect to CockroachDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for CockroachDB and the Script function in FileMaker Pro to connect to CockroachDB and work with CockroachDB in your FileMaker application.
-
Integrate Live Ontraport Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Ontraport to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Easily Query Paddle Data in OpenOffice Base
Connect to Paddle data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to IBM Cloud Object Storage from Asprova with CData Software ODBC Driver for IBM Cloud Object Storage
This article shows how to connect faster to IBM Cloud Object Storage data from Asprova.
-
How to integrate Metabase with SAP Business One Data
Use CData Connect AI to connect to live SAP Business One and create an interactive dashboard in Metabase from SAP Business One.
-
Getting Started with the CData SSIS Components for Parquet
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Parquet.
-
Getting Started with the CData SSIS Components for Elorus
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Elorus.
-
How to Work with LDAP Objects in AWS Glue Jobs Using JDBC
Connect to LDAP from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Amazon Marketplace Data in Google Apps Script via Connect AI
Use CData Connect AI to access Amazon Marketplace in Google Apps Script.
-
Build Dashboards with Impala Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache Impala in DBxtra.
-
Connect to Discord Data in DBArtisan
Use wizards in DBArtisan to configure Discord as a data source.
-
Connect to Shortcut Data in JRuby
Create a simple JRuby app with access to live Shortcut.
-
Validate Microsoft Exchange Data with QuerySurge
Access and validate Microsoft Exchange in QuerySurge using the CData JDBC Driver.
-
Query SFTP Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SFTP entities in PHP by modeling them as objects.
-
Connect Attio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Attio using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Sage Cloud Accounting Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Snowflake.
-
Add Azure Data Catalog Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Data Catalog with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting Moonlit Workflow with Zoho Creator Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zoho Creator in real time.
-
Automated Continuous Basecamp Replication to SQL Server
Use CData Sync for automated, continuous, customizable Basecamp replication to SQL Server.
-
How to connect PolyBase to SingleStore
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SingleStore.
-
Connect to Hubstaff in SpagoBI
Create reports featuring live Hubstaff in SpagoBI Studio. Host Hubstaff reports on SpagoBI Server.
-
Connect to Salesforce Pardot Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce Pardot and the SQL Gateway to access Salesforce Pardot from Google Apps Script.
-
Query, Visualize, and Share live Reckon Accounts Hosted Data in Redash
Use CData Connect AI to connect to live Reckon Accounts Hosted in Redash for querying, visualizing, and sharing.
-
Connect to HBase Data from HeidiSQL
Use CData Connect AI to connect to and query live Apache HBase from HeidiSQL.
-
Use the CData Software ODBC Driver for Avro in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Avro in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Avro.
-
Query Google Ad Manager Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Ad Manager.
-
How to Connect the Power BI Service to RabbitMQ: Complete Guide
Connect to the CData Software Power BI Connector for RabbitMQ from PowerBI.com to provide real-time RabbitMQ across the organization.
-
Getting Started with the CData Python Connector for Klipfolio
Learn to install and license the CData Python Connector
-
Build Visualizations of VWO Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of VWO in Birst.
-
Automated Continuous Google Cloud Storage Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to AlloyDB.
-
Connect to Oracle Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle Database in the Denodo Virtual DataPort Administrator.
-
Connect to Live Zoho Projects Data in MicroStrategy through CData Connect AI
Create a live connection to Zoho Projects Data in CData Connect AI and connect to your Zoho Projects from MicroStrategy.
-
How to Easily Query Accelo Data in OpenOffice Base
Connect to Accelo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Dashboards with Insightly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Insightly in Dundas BI.
-
How to Import Data from ShipStation into Google Sheets
Import ShipStation into a Google spreadsheet that is automatically refreshed.
-
Connecting Moonlit Workflow with Tally Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Tally ERP in real time.
-
Automated Microsoft Entra ID Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Entra ID replication to Teradata.
-
Easily Integrate Zoom Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoom in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Apps from Zuora Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zuora Data and build apps from live Zuora in Qlik Sense Cloud.
-
How to import Opsgenie Data into Apache Solr
Use the CData Software JDBC Driver for Opsgenie in Data Import Handler and create an automated import of Opsgenie to Apache Solr Enterprise Search platform.
-
Build an OLAP Cube in SSAS from Anaplan Data
Establish a connection to Anaplan data from SQL Server Analysis Services, and use the Anaplan Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate Webex Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Webex from PowerShell? This article demonstrates how to utilize the Webex Cmdlets for tasks like connecting to Webex, automating operations, downloading data, and more.
-
Create Data Visualizations in Cognos BI with Zoho Recruit Data
Access Zoho Recruit as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Oracle Service Cloud Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle Service Cloud from Informatica Cloud.
-
Automated Continuous CapsuleCRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to MongoDB.
-
How to Connect Microsoft OneDrive Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Microsoft OneDrive data in real time using natural language.
-
Visualize Live HubSpot Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HubSpot.
-
Automate Hubstaff Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Hubstaff from PowerShell? This article demonstrates how to utilize the Hubstaff Cmdlets for tasks like connecting to Hubstaff, automating operations, downloading data, and more.
-
Build Microsoft Exchange-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Microsoft Exchange Data from Zoho Analytics and import live Microsoft Exchange.
-
Build Semantic Layer Views for Azure Data Lake Storage Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Data Lake Storage.
-
Consume HDFS OData Feeds in PowerBuilder
This article demonstrates how to consume Apache HDFS as OData feeds from PowerBuilder using the API Server.
-
Establish a Live Connection with Salesforce Marketing Data using Tableau Bridge
The CData ODBC Driver for Salesforce Marketing enables you to integrate live Salesforce Marketing Cloud into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Nethunt Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Nethunt.
-
Analyze Vault CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Veeva Vault & Vault CRM in Microsoft R Open.
-
How to Query Live Excel Online Data in Perplexity MacOS Desktop
Connect to and query live Excel Online Data in Perplexity Desktop using CData MCP Server.
-
DataBind Controls to AdRoll Data in Delphi
DataBind to AdRoll in Delphi with standard data access components and controls.
-
Replicate Customer.io Data from PowerShell
Write a quick PowerShell script to query Customer.io. Use connectivity to the live data to replicate Customer.io to SQL Server.
-
Connect to Facebook Data from a Connection Pool in Jetty
The Facebook JDBC Driver supports connection pooling: This article shows how to connect faster to Facebook from Web apps in Jetty.
-
How to create Discord federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Discord in MySQL .
-
How to update CouchDB from Excel
This article explains how to transfer data from Excel to CouchDB using the Excel Add-In for CouchDB.
-
Manage Elasticsearch Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Elasticsearch.
-
Getting Started with the CData Python Connector for MYOB AccountRight
Learn to install and license the CData Python Connector
-
Integrate Theia IDE with Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create a Data Access Object for Grafana Data using JDBI
A brief overview of creating a SQL Object API for Grafana in JDBI.
-
Connect to Bugsnag Data in Ruby
Connect to Bugsnag in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Databricks Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Databricks for you.