CData Software - Knowledge Base
Recent Articles
-
Access Live GitHub Data in AWS Lambda
Connect to live GitHub in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Certinia Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Certinia replication to Azure SQL Database.
-
Analyze Google Directory Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Directory and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use Dash to Build to Web Apps on SendPulse Data
Create Python applications that use pandas and Dash to build SendPulse-connected web apps.
-
Automated Continuous Planio Replication to Databricks
Use CData Sync for automated, continuous, customizable Planio replication to Databricks.
-
Migrating data from Opsgenie to Google BigQuery using CData SSIS Components.
Easily push Opsgenie to Google BigQuery using the CData SSIS Tasks for Opsgenie and Google BigQuery.
-
Integrate GitHub with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate GitHub with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to GitHub.
-
Query Certinia Data in DataGrip
Create a Data Source for Certinia in DataGrip and use SQL to query live Certinia.
-
Automated Continuous Avalara AvaTax Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Google Cloud SQL.
-
Build Dashboards with LaunchDarkly Data in Dundas BI
Create dynamic dashboards and perform analytics based on LaunchDarkly in Dundas BI.
-
Access Live ActiveCampaign Data in Coginiti Pro
Connect to and query live ActiveCampaign from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build HBase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache HBase and build web apps with connectivity to live Apache HBase.
-
Connect to OpenWeatherMap Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect PolyBase to Gorgias
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Gorgias.
-
Connect Pinecone Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Pinecone using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to load Freshsales data into Elasticsearch via Logstash
Introducing a simple method to load Freshsales data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Mouseflow Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Mouseflow from Power Pivot. You will use the Table Import Wizard to load Mouseflow. You can visually build the import query or use any SQL supported by the driver.
-
Build Data Flows from Microsoft Entra ID to SQL Server using SSIS
Easily back up Microsoft Entra ID to SQL Server using the SSIS components for Microsoft Entra ID.
-
Prepare, Blend, and Analyze Customer.io Data in Alteryx Designer (ODBC)
Build workflows to access live Customer.io for self-service data analytics.
-
Extend Google Sheets with Amazon Athena Data
Make calls to Amazon Athena from Google Apps Script via the API Server.
-
Use the CData Software ODBC Driver for ChargeOver in MicroStrategy
Connect to ChargeOver in MicroStrategy Developer using the CData Software ODBC Driver for ChargeOver.
-
Use JayDeBeApi to access Discourse Data in Python
Use standard Python scripting and the development environment of your choice to access live Discourse.
-
Build Dashboards with Bugsnag Data in DBxtra
Create dynamic dashboards and perform analytics based on Bugsnag in DBxtra.
-
Connect to Moosend Data in CloverDX (formerly CloverETL)
Transfer Moosend using the visual workflow in the CloverDX data integration tool.
-
Build Dashboards with Basecamp Data in DBxtra
Create dynamic dashboards and perform analytics based on Basecamp in DBxtra.
-
Integrating FHIR Data in Talend Cloud Data Management Platform
Connect FHIR Data with Talend Cloud Data Management Platform using the CData JDBC Driver for FHIR.
-
Back Up HubDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HubDB. In this article, we will employ an SSIS workflow to populate a database with HubDB data.
-
How to connect PolyBase to Wistia
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Wistia.
-
How to Query Live CapsuleCRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CapsuleCRM data in natural language using Python.
-
How to Seamlessly Import Cassandra Data into IBM SPSS Modeler
Integrate Cassandra data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Data Flows from Testmonitor to SQL Server using SSIS
Easily back up Testmonitor to SQL Server using the SSIS components for Testmonitor.
-
Access Live MYOB AccountRight Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MYOB AccountRight from your Excel spreadsheets.
-
Use Microsoft Copilot Studio to talk to your SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft SQL Server for you.
-
Connect to and Query Cosmos DB Data in QlikView over ODBC
Create data visualizations with Azure Cosmos DB in QlikView.
-
Access Live SAP Netweaver Gateway Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Netweaver Gateway from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Apps with Live Access Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Access with Mendix to build apps using the CData JDBC Driver for Access.
-
Connecting Pipedream with SAP Fieldglass 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 SAP Fieldglass data in real time.
-
Add Dynamics 365 Business Central Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dynamics 365 Business Central with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Manus AI to Talk to Your Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Microsoft Exchange.
-
Add Microsoft Dataverse Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Dataverse with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for RabbitMQ on an SSRS Report Server
Connect to RabbitMQ 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.
-
Publish Reports with Snapchat Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Snapchat Ads.
-
How to Work with eBay Data in AWS Glue Jobs Using JDBC
Connect to eBay from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to FreeAgent Data in Ruby
Connect to FreeAgent in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Multiple Procore Accounts via the CData Sync CLI
Replicate multiple Procore accounts to one or many databases.
-
Use Azure AI Foundry to Talk to Your QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your QuickBooks Time for you.
-
Automate Wrike Data Replication to Azure Synapse
Use CData Sync to customize and automate Wrike replication to Azure Synapse.
-
Create Azure DevOps-Connected Business Apps in AppSheet
Connect to Azure DevOps Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure DevOps.
-
How to connect PolyBase to GraphQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live GraphQL.
-
Use Biml to Build SSIS Tasks to Replicate Missive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Missive to SQL Server.
-
Analyze Zoho CRM Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho CRM and visualize live Zoho CRM in Infragistics Reveal.
-
Integrate with Vercel Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Vercel to a JSON file on disk.
-
Back Up Freshservice 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 Freshservice data.
-
Automated Continuous CockroachDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CockroachDB replication to Amazon Redshift.
-
Connect to Typeform Data from a Connection Pool in JBoss
Integrate Typeform into Java servlets: Use the Management Console in JBoss to install the Typeform JDBC Driver.
-
Migrating data from Paymo to Databricks using CData SSIS Components.
Easily push Paymo to Databricks using the CData SSIS Tasks for Paymo and Databricks.
-
Using the CData Software ODBC Driver for Float in PyCharm
Connect to Float as an ODBC data source in PyCharm using the CData Software ODBC Driver for Float.
-
Integrating Cursor CLI with TigerGraph 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.
-
Integrating LangChain with Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoho Creator within automated workflows.
-
Replicate SAP Data from PowerShell
Write a quick PowerShell script to query SAP ERP/NetWeaver. Use connectivity to the live data to replicate SAP ERP/NetWeaver to SQL Server.
-
Visualize Stack Exchange Data in Sisense
Create an ElastiCube in Sisense app with access to Stack Exchange.
-
How to Access Live Bright Data Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bright Data enables you to integrate Bright Data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Gumloop with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Certinia within automated workflows.
-
Prepare, Blend, and Analyze Dropbox Data in Alteryx Designer (ODBC)
Build workflows to access live Dropbox for self-service data analytics.
-
Connect to Unbounce Data in CloverDX (formerly CloverETL)
Transfer Unbounce using the visual workflow in the CloverDX data integration tool.
-
Connect to OneNote Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Manage Microsoft Dataverse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Dataverse.
-
Analyze SAP SuccessFactors Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP SuccessFactors from Power Pivot. You will use the Table Import Wizard to load SAP SuccessFactors. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Live Freshservice Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Freshservice using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open ChartMogul Data in Microsoft Excel
This article uses the CData ODBC driver for ChartMogul to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live MarkLogic Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live MarkLogic through MCP integration.
-
Connect to Zoho Creator Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho Creator Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous ShipEngine Replication to MongoDB
Use CData Sync for automated, continuous, customizable ShipEngine replication to MongoDB.
-
Integrate Live OData Services into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to OData and integrate live OData into apps built in Microsoft Power Apps.
-
Integrate Open WebUI with Live Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Couchbase from within the chat interface.
-
Migrating data from GetResponse to Google BigQuery using CData SSIS Components.
Easily push GetResponse to Google BigQuery using the CData SSIS Tasks for GetResponse and Google BigQuery.
-
Operational Reporting on BambooHR Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote BambooHR.
-
How to Connect the Power BI Service to Placid: Complete Guide
Connect to the CData Software Power BI Connector for Placid from PowerBI.com to provide real-time Placid across the organization.
-
Getting Started with the CData Excel Add-In for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZeroBounce.
-
Getting Started with the CData ODBC Driver for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for YouTube Analytics.
-
Integrate Snapchat Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Snapchat Ads from Informatica Cloud.
-
Build Dynamics CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Dynamics CRM and build web apps with connectivity to live Microsoft Dynamics CRM.
-
Publish Landbot-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Landbot.
-
Connect to Autopilot in SpagoBI
Create reports featuring live Autopilot in SpagoBI Studio. Host Autopilot reports on SpagoBI Server.
-
Access Live Autopilot Data in AWS Lambda
Connect to live Autopilot in AWS Lambda using the CData JDBC Driver.
-
DataBind Controls to PagerDuty Data in C++Builder
DataBind to PagerDuty in C++Builder with standard components and controls.
-
Integrating Boomi Agentstudio with HubSpot Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to HubSpot, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automate SAP Ariba Source Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Ariba Source replication to Azure Synapse.
-
Build Semantic Layer Views for OData Services in APOS Live Data Gateway
Use the CData Connector for OData in APOS Live Data Gateway to build Semantic Layer Views for OData.
-
How to connect to TaxJar Data from IntelliJ
Integrate connectivity to TaxJar with wizards in IntelliJ.
-
Prepare, Blend, and Analyze Codat Data in Alteryx Designer (ODBC)
Build workflows to access live Codat for self-service data analytics.
-
Access Live Wrike Data in AWS Lambda
Connect to live Wrike in AWS Lambda using the CData JDBC Driver.
-
Replicate PivotalTracker Data from PowerShell
Write a quick PowerShell script to query PivotalTracker. Use connectivity to the live data to replicate PivotalTracker to SQL Server.
-
Access Live Adobe Commerce Data in Coginiti Pro
Connect to and query live Adobe Commerce from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Dashboards and Visualize Live Google Campaign Manager 360 Data in Geckoboard
Use CData Connect AI to connect to live Google Campaign Manager 360 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Data Visualizations in Cognos BI with Factorial Data
Access Factorial as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Hive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache Hive in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Google Ad Manager Data in the Pentaho Report Designer
Publish reports based on Google Ad Manager in the Pentaho BI tool.
-
Integrate FreeAgent with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate FreeAgent with External Services.
-
A PostgreSQL Interface for Snowflake Data using the CData ODBC Driver
Use the SQL Gateway and Snowflake ODBC Driver to create a PostgreSQL entry-point for data access.