CData Software - Knowledge Base
Recent Articles
-
How to import ChartMogul Data into Apache Solr
Use the CData Software JDBC Driver for ChartMogul in Data Import Handler and create an automated import of ChartMogul to Apache Solr Enterprise Search platform.
-
Connect to and Query Insightly Data in QlikView over ODBC
Create data visualizations with Insightly in QlikView.
-
Edit and Search External Cloudant Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of IBM Cloudant to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cloudant Data objects that you can access from apps and the dashboard.
-
How to Query Live Microsoft Planner Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Planner data in natural language using Python.
-
Connect to Live NetSuite SuiteAnalytics Data in MicroStrategy through CData Connect AI
Create a live connection to NetSuite SuiteAnalytics Data in CData Connect AI and connect to your NetSuite SuiteAnalytics from MicroStrategy.
-
Connect to SparkPost Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to SparkPost and work with SparkPost in your FileMaker application.
-
Getting Started with the CData JDBC Driver for AfterShip
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for AfterShip.
-
Viewing Bright Data Data in RAD Studio Data Explorer
How to view Bright Data in RAD Studio Data Explorer using the CData ODBC Driver for Bright Data.
-
Visualize Browserless Data in TIBCO Spotfire through ADO.NET
Integrate Browserless into dashboards in TIBCO Spotfire.
-
Integrate Live ADP Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ADP and integrate live ADP into apps built in Microsoft Power Apps.
-
Integrate with MailChimp Data in JReport Designer
Create charts and reports based on MailChimp in JReport Designer.
-
Load Adobe Target Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Target to a database.
-
Create Reports with Wistia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wistia.
-
Manage Azure Data Lake Storage Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Data Lake Storage.
-
Connect to Browserless Data in DBArtisan
Use wizards in DBArtisan to configure Browserless as a data source.
-
Integrate Cline with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Paylocity from within your IDE.
-
Automated Continuous Autopilot Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Autopilot replication to OneLake in Microsoft Fabric.
-
Analyze Dropbox Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Dropbox with the CData JDBC Driver for Dropbox.
-
How to Visualize Jira Data in Python with pandas
Use pandas and other modules to analyze and visualize live Atlassian Jira in Python.
-
Migrating data from Hubstaff to Snowflake using CData SSIS Components.
Easily push Hubstaff to Snowflake using the CData SSIS Tasks for Hubstaff and Snowflake.
-
Build Jira-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Atlassian Jira.
-
Publish Reports with FHIR Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FHIR.
-
Trigger Microsoft Planner IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Planner with standard wizards in Logic Apps.
-
Using the CData Software ODBC Driver for ZohoMarketingHub in PyCharm
Connect to ZohoMarketingHub as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZohoMarketingHub.
-
How to Connect to & Open Humanity Data in Microsoft Excel
This article uses the CData ODBC driver for Humanity to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Cloudflare Reporting in OBIEE with the Cloudflare JDBC Driver
Deploy the Cloudflare JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Add Factorial Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Factorial with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Act-On Replication to Snowflake
Use CData Sync for automated, continuous, customizable Act-On replication to Snowflake.
-
Build Dashboards with Zuora Data in DBxtra
Create dynamic dashboards and perform analytics based on Zuora in DBxtra.
-
Import MariaDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MariaDB Data and provide access to live MariaDB for custom reports in the Power BI Service.
-
Analyze MySQL Data in Looker
Use CData Connect AI to connect to MySQL Data from Looker and build custom apps using live MySQL.
-
How to Easily Query SendInBlue Data in OpenOffice Base
Connect to SendInBlue data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Epicor Kinetic Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Epicor Kinetic facts in real time.
-
Access SAP HANA 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 SAP HANA.
-
Integrate Theia IDE with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Raisers Edge NXT Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Raisers Edge NXT and build visualizations in Tableau Cloud.
-
Connect to Elorus Data in JRuby
Create a simple JRuby app with access to live Elorus.
-
Access Avaza Data from MySQL in Amazon QuickSight
Connect to Avaza and build visualizations of Avaza using a MySQL Connection in Amazon QuickSight.
-
How to create Raisers Edge NXT federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Raisers Edge NXT in MySQL .
-
Publish Vault CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Veeva Vault & Vault CRM.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google BigQuery within intelligent workflows.
-
Query Bullhorn CRM Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Bullhorn CRM and perform CRUD operations on Bullhorn CRM from Node.js.
-
Integrating Dataiku with Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apache Hive.
-
Connect to HubDB from Asprova with CData Software ODBC Driver for HubDB
This article shows how to connect faster to HubDB data from Asprova.
-
Automated Continuous Shippo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Shippo replication to Google Cloud SQL.
-
Automate Tanda Data Replication to Couchbase
Use CData Sync to Customize and automate Tanda replication to Couchbase.
-
Replicate LinkedIn Ads Data in Heroku for Use in Salesforce Connect
Replicate LinkedIn Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect Lakebase 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 Lakebase data in real time using natural language.
-
Automated Tally Data Replication to Teradata
Use CData Sync to Customize and automate Tally ERP replication to Teradata.
-
A PostgreSQL Interface for Google Directory Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Directory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Google Cloud Storage-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Cloud Storage and build web apps with connectivity to live Google Cloud Storage.
-
Natively Connect to Couchbase Data in PHP
The CData ODBC driver for Couchbase enables you to create PHP applications with connectivity to Couchbase. Leverage the native support for ODBC in PHP.
-
Automated Continuous Odoo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Odoo replication to Apache Cassandra.
-
Use the CData API Server to Access BigQuery Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google BigQuery in the Power Pivot business intelligence tool.
-
Publish Crystal Reports on Raisers Edge NXT Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Raisers Edge NXT.
-
Connect to Spark Data in DBArtisan
Use wizards in DBArtisan to configure Apache Spark SQL as a data source.
-
Visualize Azure Data Catalog Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Data Catalog.
-
ETL xBase in Oracle Data Integrator
This article shows how to transfer xBase into a data warehouse using Oracle Data Integrator.
-
Connect to Freshdesk Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Freshdesk Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to GitLab 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 GitLab.
-
How to work with Teamgate Data in Apache Spark using SQL
Access and process Teamgate Data in Apache Spark using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Google Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Ads for self-service data analytics.
-
Connect to LionDesk Data in CloverDX (formerly CloverETL)
Transfer LionDesk using the visual workflow in the CloverDX data integration tool.
-
Integrate Open WebUI with Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Quickbase from within the chat interface.
-
Viewing eBay Analytics Data in RAD Studio Data Explorer
How to view eBay Analytics in RAD Studio Data Explorer using the CData ODBC Driver for eBay Analytics.
-
Write a Simple Go Application to work with LionDesk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LionDesk.
-
Connect to ZeroBounce Data in DBeaver
Use the CData ODBC Driver to connect to ZeroBounce in DBeaver.
-
Query Neo4J Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Neo4J and perform CRUD operations on Neo4J from Node.js.
-
Automated Continuous Mailjet Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Mailjet replication to OneLake in Microsoft Fabric.
-
How to Build an ETL App for Procore Data in Python with CData
Create ETL applications and real-time data pipelines for Procore in Python with petl.
-
Connecting Pipedream with SAS xpt 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 SAS xpt data in real time.
-
Connect to iContact Data in Aqua Data Studio
Access iContact from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import and Visualize Zuora Data in Power View
Create data visualizations based on Zuora in Excel.
-
Rapidly Develop Adobe Experience Manager-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 Adobe Experience Manager.
-
Create SAP Business Warehouse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Business Warehouse data access from reports, embedded analytics, and more.
-
Publish Crystal Reports on Customer.io Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Customer.io.
-
Build CSV-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for CSV Data and create custom apps in Mendix.
-
Operational Reporting on Avro Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Avro.
-
Replicate Epicor Kinetic Data from PowerShell
Write a quick PowerShell script to query Epicor Kinetic. Use connectivity to the live data to replicate Epicor Kinetic to SQL Server.
-
Create Datasets from SageHR in Domo Workbench and Build Visualizations of SageHR Data in Domo
Use the CData Software ODBC Driver for SageHR to create datasets from SageHR in Domo Workbench and then build visualizations in the Domo service.
-
How to Easily Query Google Sheets Data in OpenOffice Base
Connect to Google Sheets data in OpenOffice Base using the CData ODBC Driver for Google Sheets and generate reports with live data insights.
-
Integrate Epicor Kinetic Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Epicor Kinetic from Informatica Cloud.
-
Stream Vimeo Data into Apache Kafka Topics
Access and stream Vimeo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Load Aircall Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Aircall to a database.
-
Connect to and Query HubSpot Data in QlikView over ODBC
Create data visualizations with HubSpot in QlikView.
-
Connect to Telegram Data in JRuby
Create a simple JRuby app with access to live Telegram.
-
Automated Continuous API Replication to AlloyDB
Use CData Sync for automated, continuous, customizable API replication to AlloyDB.
-
Connect to Tickspot Data in DBeaver
Use the CData ODBC Driver to connect to Tickspot in DBeaver.
-
Use JayDeBeApi to access Presto Data in Python
Use standard Python scripting and the development environment of your choice to access live Presto.
-
Integrate with Timely Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Timely to a JSON file on disk.
-
Viewing Freshdesk Data in RAD Studio Data Explorer
How to view Freshdesk in RAD Studio Data Explorer using the CData ODBC Driver for Freshdesk.
-
Getting Started with the CData JDBC Driver for Jira Assets
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Jira Assets.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho Projects
Create an ODBC connection to Zoho Projects in Informatica and browse and transfer Zoho Projects.
-
Migrating data from Short.io to Snowflake using CData SSIS Components.
Easily push Short.io to Snowflake using the CData SSIS Tasks for Short.io and Snowflake.
-
How to Access Live Oracle Eloqua Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle Eloqua enables you to integrate Oracle Eloqua into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live Salesforce Pardot Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesforce Pardot.
-
Migrating data from NASA to Google BigQuery using CData SSIS Components.
Easily push NASA to Google BigQuery using the CData SSIS Tasks for NASA and Google BigQuery.
-
Query SAS xpt Data in DataGrip
Create a Data Source for SAS xpt in DataGrip and use SQL to query live SAS XPORT.
-
Integrate LibreChat with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure DevOps from within the chat interface.
-
Manage Acumatica Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Acumatica.