CData Software - Knowledge Base
Recent Articles
-
Connect to Google Search Results in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Search in the Denodo Virtual DataPort Administrator.
-
How to Work with Bullhorn CRM in ETL Validator JDBC
Connect to Bullhorn CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from Microsoft Project to Databricks using CData SSIS Components.
Easily push Microsoft Project to Databricks using the CData SSIS Tasks for Microsoft Project and Databricks.
-
Replicate Google Search Results in Heroku for Use in Salesforce Connect
Replicate Google Search to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import Oracle into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle and provide access to live Oracle Database for custom reports in the Power BI Service.
-
How to load WordPress data into Elasticsearch via Logstash
Introducing a simple method to load WordPress data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to publish and share Dynamics CRM dashboards with Tableau Server
The CData ODBC driver for Dynamics CRM enables you integrate Microsoft Dynamics CRM into Tableau dashboards.
-
Use the CData Software ODBC Driver for HarperDB in MicroStrategy Web
Connect to HarperDB in MicroStrategy Web using the CData Software ODBC Driver for HarperDB.
-
How to Connect to Live eBay from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your eBay for you.
-
Build Voice Agents in ElevenLabs with access to Live Azure Active Directory
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Active Directory.
-
Create Reports from Google Spanner in Looker Studio
Use CData Connect AI to gain access to live Google Spanner and create custom reports in Looker Studio.
-
Analyze Power BI XMLA in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Power BI XMLA and visualize live Power BI XMLA in Infragistics Reveal.
-
PowerShell Scripting to Replicate Microsoft Planner to MySQL
Write a simple PowerShell script to replicate Microsoft Planner to a MySQL database.
-
Visualize Live Jira Service Management in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Atlassian Jira Service Management into custom reports in Power BI.
-
Connect to xBase as an External Source in Dremio
Use the CData JDBC Driver to connect to xBase as an External Source in Dremio.
-
Build Salesforce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Salesforce & Force.com.
-
Explore Geographical Relationships in DocuSign with Power Map
Create data visualizations with DocuSign in Power Map.
-
How to create an RPA flow for Tableau CRM Analytics in UiPath Studio
Use the Tableau CRM Analytics ODBC Driver to create workflows that access real-time Tableau CRM Analytics without any coding.
-
Bidirectional Access to JSON Services from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate JSON in Filemaker Pro for Mac or Windows.
-
Connecting Agentforce with GitHub via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your GitHub for you.
-
Connect to API from AWS Glue
Use CData Connect AI to gain access to live API from your AWS Glue jobs.
-
Automated Continuous Redis Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Redis replication to PostgreSQL.
-
Create SAP Concur-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Concur from Nintex Workflow Cloud and build custom workflows using live SAP Concur.
-
How to Access Live NetSuite in Power Automate Desktop via ODBC
The CData ODBC Driver for NetSuite enables you to integrate NetSuite CRM & ERP into workflows built using Microsoft Power Automate Desktop.
-
Deploy the ADO.NET Provider for Azure Data Catalog on an SSRS Report Server
Connect to Azure Data Catalog 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.
-
Build an OLAP Cube in SSAS from Oracle SCM
Establish a connection to Oracle SCM data from SQL Server Analysis Services, and use the Oracle SCM Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to import Microsoft Exchange into Apache Solr
Use the CData Software JDBC Driver for Microsoft Exchange in Data Import Handler and create an automated import of Microsoft Exchange to Apache Solr Enterprise Search platform.
-
Rapidly Develop HDFS-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Automated Continuous Salesloft Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesloft replication to OneLake in Microsoft Fabric.
-
Replicate Sage Intacct from PowerShell
Write a quick PowerShell script to query Sage Intacct. Use connectivity to the live data to replicate Sage Intacct to SQL Server.
-
How to work with Stripe in Apache Spark using SQL
Access and process Stripe in Apache Spark using the CData Software JDBC Driver.
-
Connect to LDAP Objects in RapidMiner
Integrate LDAP with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Work with Bullhorn CRM in AWS Glue Jobs Using JDBC
Connect to Bullhorn CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Visualize NetSuite Data in Python with pandas
Use pandas and other modules to analyze and visualize live NetSuite CRM & ERP in Python.
-
How to integrate Power BI XMLA with Apache Airflow
Access and process Power BI XMLA in Apache Airflow using the CData JDBC Driver.
-
Visualize Live MailChimp in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MailChimp.
-
Prepare, Blend, and Analyze Couchbase in Alteryx Designer (ODBC)
Build workflows to access live Couchbase for self-service data analytics.
-
Use the CData ODBC Driver for MongoDB in Microsoft Power Query
You can use the CData MongoDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MongoDB into Microsoft Power Query.
-
Replicate Vault CRM to Multiple Databases via the CData Sync CLI
Replicate Veeva Vault & Vault CRM to disparate databases with a single configuration.
-
Build Data Flows from Aha to SQL Server using SSIS
Easily back up Aha! to SQL Server using the SSIS components for Aha.
-
Create a Data Access Object for Confluence using JDBI
A brief overview of creating a SQL Object API for Atlassian Confluence in JDBI.
-
Using the CData Software ODBC Driver for SAP BusinessObjects BI in PyCharm
Connect to SAP BusinessObjects BI as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP BusinessObjects BI.
-
Load HBase to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache HBase to a database.
-
Operational Reporting on Reckon from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Reckon.
-
Publish HDFS-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache HDFS.
-
Build an OLAP Cube in SSAS from Oracle Service Cloud
Establish a connection to Oracle Service Cloud data from SQL Server Analysis Services, and use the Oracle Service Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Using the CData Software ODBC Driver for Klipfolio in PyCharm
Connect to Klipfolio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Klipfolio.
-
Connect to Google Directory in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Directory in Airbyte.
-
Automated Continuous Box Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Box replication to Google Cloud SQL.
-
How to work with HBase in Apache Spark using SQL
Access and process HBase in Apache Spark using the CData Software JDBC Driver.
-
Integrating Dataiku with Microsoft Project via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Project.
-
Integrate ActiveCampaign into Automated Tasks with Power Automate
Use CData Connect AI to connect to ActiveCampaign and integrate live ActiveCampaign into your Power Automate tasks.
-
Integrate with Avro using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Avro to a JSON file on disk.
-
Access Live HarperDB in AWS Lambda
Connect to live HarperDB in AWS Lambda using the CData JDBC Driver.
-
Integrate Aha with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Aha with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Aha!.
-
Integrate Cvent in Pentaho Data Integration
Build ETL pipelines based on Cvent in the Pentaho Data Integration tool.
-
Replicate Parquet to Multiple Databases via the CData Sync CLI
Replicate Apache Parquet to disparate databases with a single configuration.
-
Integrate SAP HANA in the Pentaho Report Designer
Publish reports based on SAP HANA in the Pentaho BI tool.
-
Integrate Real-Time Access to Phoenix in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Phoenix in real time.
-
Getting Started with the CData Power BI Connector for YouTube Analytics
-