CData Software - Knowledge Base
Recent Articles
-
Integrate Google Data Catalog in Pentaho Data Integration
Build ETL pipelines based on Google Data Catalog in the Pentaho Data Integration tool.
-
Connect WordPress to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your WordPress using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to work with IBM Informix in Apache Spark using SQL
Access and process IBM Informix in Apache Spark using the CData Software JDBC Driver.
-
Query SQL Server using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SQL Server entities in PHP by modeling them as objects.
-
Natively Connect to Eventbrite in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Eventbrite. Leverage the native support for ODBC in PHP.
-
Access Live CouchDB in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache CouchDB into the statistical analysis tools available in SAS JMP. This article shows how to use Apache CouchDB in the Graph Builder and Query Builder.
-
Automated Continuous Azure Blob Storage Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Oracle.
-
Create Datasets from Twilio in Domo Workbench and Build Visualizations of Twilio in Domo
Use the CData Software ODBC Driver for Twilio to create datasets from Twilio in Domo Workbench and then build visualizations in the Domo service.
-
How to load Pinterest data into Elasticsearch via Logstash
Introducing a simple method to load Pinterest data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Drift from Asprova with CData Software ODBC Driver for Drift
This article shows how to connect faster to Drift data from Asprova.
-
Use the CData Software JDBC Driver for Azure Analysis Services in MicroStrategy
Connect to Azure Analysis Services in MicroStrategy Developer using the CData Software JDBC Driver for Azure Analysis Services.
-
Integrate with Live API in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to API from the MuleSoft Anypoint Platform to integrate live API into custom reports and dashboards.
-
Getting Started with the CData ODBC Driver for Cvent
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cvent.
-
Replicate HubSpot to Multiple Databases via the CData Sync CLI
Replicate HubSpot to disparate databases with a single configuration.
-
Automated Continuous Workday Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Workday replication to Google BigQuery.
-
Use the CData ODBC Driver for BambooHR from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for BambooHR to connect to BambooHR from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring BambooHR in Excel.
-
Connect to Sugar CRM from HeidiSQL
Use CData Connect AI to connect to and query live Sugar CRM from HeidiSQL.
-
Trigger Bullhorn CRM IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Access ClickUp from MySQL in PHP
Connect to ClickUp through the standard MySQL libraries in PHP.
-
Query Facebook Ads using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Facebook Ads entities in PHP by modeling them as objects.
-
How to create an RPA flow for Google Analytics in UiPath Studio
Use the Google Analytics ODBC Driver to create workflows that access real-time Google Analytics without any coding.
-
How to Visualize Todoist Data in Python with pandas
Use pandas and other modules to analyze and visualize live Todoist in Python.
-
Load BigCommerce to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load BigCommerce to a database.
-
Automated Continuous Dynamics CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Apache Kafka.
-
Replicate Multiple SAP Fieldglass Accounts
Replicate multiple SAP Fieldglass accounts to one or many databases.
-
Use JayDeBeApi to access LDAP Objects in Python
Use standard Python scripting and the development environment of your choice to access live LDAP.
-
Analyze GraphQL with Power Pivot
This article walks you through the process of using the CData ODBC Driver for GraphQL from Power Pivot. You will use the Table Import Wizard to load GraphQL. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for CSV (MySQL Remoting via JDBC)
Use the Remoting features of the CSV JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI Agents with Google Calendar Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Build Presto-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Presto and build web apps with connectivity to live Presto.
-
Access Live Google Spanner in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Spanner in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import and Visualize Exact Online in Power View
Create data visualizations based on Exact Online in Excel.
-
How to Work with Pipedrive in ETL Validator JDBC
Connect to Pipedrive from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Claude to Talk to Your Active Directory via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Active Directory for you.
-
Using the CData Software ODBC Driver for SAP Ariba Source in PyCharm
Connect to SAP Ariba Source as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Ariba Source.
-
Connect to Kintone in DBArtisan
Use wizards in DBArtisan to configure Kintone as a data source.
-
Use the CData SSIS Components to Insert New or Update Existing Jira Assets Records from SQL Server
Easily push SQL Server data to Jira Assets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Jira Assets or update existing records with data from a SQL Server database.
-
DataBind Charts to Zoho Creator
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Creator 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.
-
Building Dynamic Web Pages with Cassandra Using AngularJS
Create single-page applications with live connectivity to Cassandra using the CData API Server.
-
Bridge Azure Data Lake Storage Connectivity with Apache NiFi
Access and process Azure Data Lake Storage in Apache NiFi using the CData JDBC Driver.
-
Access Live JDBC-ODBC Bridge in AWS Lambda
Connect to live JDBC-ODBC Bridge in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Google Ads from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google Ads for you.
-
Natively Connect to Amazon S3 in PHP
The CData ODBC driver for Amazon S3 enables you to create PHP applications with connectivity to Amazon S3. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Couchbase in Alteryx Designer (ODBC)
Build workflows to access live Couchbase for self-service data analytics.
-
How to Visualize Azure Analysis Services Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Analysis Services in Python.
-
Automate Exact Online Replication to Couchbase
Use CData Sync to Customize and automate Exact Online replication to Couchbase.
-
Building Dynamic Web Pages with Harvest Using AngularJS
Create single-page applications with live connectivity to Harvest using the CData API Server.
-
How to Easily Query HubDB in OpenOffice Base
-