CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with Amazon S3 Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon S3 in DBxtra.
-
Automate Mailjet Data Replication to Azure Synapse
Use CData Sync to customize and automate Mailjet replication to Azure Synapse.
-
Use JayDeBeApi to access Gorgias Data in Python
Use standard Python scripting and the development environment of your choice to access live Gorgias.
-
Rapidly Develop Trello-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 Trello.
-
Access Live Lakebase Data in Excel 365 Online (Excel for the web)
Connect to Lakebase from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Office 365 Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Office 365 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Informatica Mappings From/To an ODBC Data Source for QuickBooks Online
Create an ODBC connection to QuickBooks Online in Informatica and browse and transfer QuickBooks Online.
-
Edit and Search Zoho Inventory External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Zoho Inventory to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Zoho Inventory objects that you can access from apps and the dashboard.
-
Getting Started with the CData SSIS Components for Rootly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Rootly.
-
Stream Optimizely Data into Apache Kafka Topics
Access and stream Optimizely in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Azure Table Data in DBVisualizer
Integrate Azure Table Storage with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to ActiveCampaign Data from IntelliJ
Integrate connectivity to ActiveCampaign with wizards in IntelliJ.
-
Operational Reporting on CSV Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CSV/TSV Files.
-
Integrate with Instantly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Instantly to a JSON file on disk.
-
How to load SAP BusinessObjects BI data into Elasticsearch via Logstash
Introducing a simple method to load SAP BusinessObjects BI data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to ShipEngine Data in DBVisualizer
Integrate ShipEngine with visual data analysis tools and data connection wizards in DBVisualizer
-
Build a Simple VCL Application for Google Search Results
How to build a simple VCL Application to view Google Search in RAD Studio using the CData ODBC Driver for Google Search.
-
Build Agents in Relevance AI with Access to Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Dropbox within intelligent agent workflows.
-
How to integrate Bitly with Apache Airflow
Access and process Bitly in Apache Airflow using the CData JDBC Driver.
-
Build AI/ML Models with Live Wave Financial Data using Dataiku
Connect Wave Financial Data with Dataiku using the CData JDBC Driver for Wave Financial.
-
Connect to Landbot from a Connection Pool in WebLogic
Use the CData JDBC Driver for Landbot to connect to Landbot from Web applications running on WebLogic.
-
DataBind PhantomBuster Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PhantomBuster to a chart.
-
DataBind Controls to ElevenLabs Data in C++Builder
DataBind to ElevenLabs in C++Builder with standard components and controls.
-
Import Real-Time ShipStation Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ShipStation in ColdFusion.
-
Establish a Live Connection with Neo4J Data using Tableau Bridge
The CData ODBC Driver for Neo4J enables you to integrate live Neo4J into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to CockroachDB Data in DBArtisan
Use wizards in DBArtisan to configure CockroachDB as a data source.
-
Use JayDeBeApi to access Rootly Data in Python
Use standard Python scripting and the development environment of your choice to access live Rootly.
-
Automated Continuous FreeAgent Replication to SQL Server
Use CData Sync for automated, continuous, customizable FreeAgent replication to SQL Server.
-
Extract, Transform, and Load Toggl Data in Informatica PowerCenter
Create a simple Workflow for Toggl in Informatica PowerCenter.
-
Access Live Twilio Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twilio from your Excel spreadsheets.
-
Connect to Google Contacts from Asprova with CData Software ODBC Driver for Google Contacts
This article shows how to connect faster to Google Contacts data from Asprova.
-
Automated Continuous CockroachDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CockroachDB replication to OneLake in Microsoft Fabric.
-
Integrating Claude Code CLI with Square 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.
-
Dotmailer Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dotmailer facts in real time.
-
Integrate Open WebUI with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live FHIR from within the chat interface.
-
How to Connect to Oracle Service Cloud Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Service Cloud. Leverage the pyodbc module for ODBC in Python.
-
Query Qualaroo Data in ColdFusion
Write standard ColdFusion data access code to connect to Qualaroo.
-
Query Google Calendars, Contacts, and Documents from PowerShell
Are you looking for a quick and easy way to access Google Drive and other Google Apps from PowerShell? The CData Google Apps Data Provider provides an easy-to-use ADO.NET interface that you can take advantage of from your PowerShell scripts. The provider simplifies authentication and interaction with Google Apps. Simply use the included .NET objects in your PowerShell scripts to connect to your Google Apps accounts and synchronize, automate, download, and more!
-
Integrating LangChain with Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoom within automated workflows.
-
Analyze Live Act CRM Data in SAS Viya
Use CData Connect AI to connect to Act CRM from SAS Viya and deploy self-service analytics using live Act CRM.
-
Integrating Antigravity CLI with AgileCRM via CData CLI
Connect AgileCRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Odoo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Odoo Data and create custom apps in Mendix.
-
Visualize Monday.com Data in Sisense
Create an ElastiCube in Sisense app with access to Monday.com.
-
How to Connect the Power BI Service to Google Cloud Storage: Complete Guide
Connect to the CData Software Power BI Connector for Google Cloud Storage from PowerBI.com to provide real-time Google Cloud Storage across the organization.
-
Getting Started with the CData JDBC Driver for SendPulse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SendPulse.
-
Choosing the Best Method to Connect Tally to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Tally ERP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Semantic Layer Views for Paylocity Data in APOS Live Data Gateway
Use the CData Connector for Paylocity in APOS Live Data Gateway to build Semantic Layer Views for Paylocity.
-
Connect to SAP BusinessObjects BI Data from PowerBuilder via JDBC
This article demonstrates how to access SAP BusinessObjects BI from PowerBuilder using the SAP BusinessObjects BI JDBC Driver.
-
Automate Greenhouse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Greenhouse from PowerShell? This article demonstrates how to utilize the Greenhouse Cmdlets for tasks like connecting to Greenhouse, automating operations, downloading data, and more.
-
Replicate AfterShip Data from PowerShell
Write a quick PowerShell script to query AfterShip. Use connectivity to the live data to replicate AfterShip to SQL Server.
-
Publish Crystal Reports on Adobe Analytics Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Adobe Analytics.
-
Use the CData Software ODBC Driver for Redis in MicroStrategy
Connect to Redis in MicroStrategy Developer using the CData Software ODBC Driver for Redis.
-
Google Analytics Reporting in OBIEE with the Google Analytics JDBC Driver
Deploy the Google Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData ADO.NET Provider for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use Dash to Build Web Apps on Google Spanner Data via CData Connect AI
Build interactive Dash web apps on live Google Spanner using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Drip Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Drip replication to delimited files (CSV/TSV).
-
Connecting Moonlit Workflow with Pipedrive 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 Pipedrive in real time.
-
Connect to Retently Data from a Connection Pool in JBoss
Integrate Retently into Java servlets: Use the Management Console in JBoss to install the Retently JDBC Driver.
-
Integrating LangChain with Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle Sales within automated workflows.
-
Getting Started with the CData Excel Add-In for Keap
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Keap.
-
Connect to Avalara AvaTax from a Connection Pool in WebLogic
Use the CData JDBC Driver for Avalara AvaTax to connect to Avalara AvaTax from Web applications running on WebLogic.
-
Getting Started with the CData ADO.NET Provider for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Amazon Athena.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed IBM Cloudant to Power BI dashboards. Simply drag and drop IBM Cloudant into data visuals on the Power BI canvas.
-
Build Dashboards with ClickTime Data in DBxtra
Create dynamic dashboards and perform analytics based on ClickTime in DBxtra.
-
Excel Spreadsheet Automation on Dynamics 365 Business Central Data with the QUERY Formula
Pull data from Dynamics 365 Business Central, automate spreadsheets, and more with the QUERY formula.
-
Connect to BambooHR Data in CloverDX (formerly CloverETL)
Transfer BambooHR using the visual workflow in the CloverDX data integration tool.
-
Create Power BI Reports on Real-Time GraphQL Data
Use the CData ODBC Driver for GraphQL to visualize GraphQL in Power BI Desktop.
-
How to Connect to Live Google Drive Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Drive securely in real time.
-
Enable the Keap JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Keap.
-
Connect to Live Twitter Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Twitter Ads in CData Connect AI and connect to your Twitter Ads from PostgreSQL.
-
Use the CData Software JDBC Driver for Reckon in MicroStrategy Desktop
Connect to Reckon in MicroStrategy Desktop using the CData Software JDBC Driver for Reckon.
-
Access Live Excel Data in TIBCO Data Virtualization
Use the Excel Tibco DV Adapter to create a Microsoft Excel data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Excel from your TDV Server.
-
Publish Reports with Pinecone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinecone.
-
Create Zoho Creator-Connected Applications in Appsmith
Connect to Zoho Creator Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zoho Creator.
-
Use JayDeBeApi to access Microsoft Teams Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Teams.
-
Landbot Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Landbot facts in real time.
-
Choosing the Best Method to Connect Mixpanel to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mixpanel from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Add Odoo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Odoo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Validate SAP Netweaver Gateway Data with QuerySurge
Access and validate SAP Netweaver Gateway in QuerySurge using the CData JDBC Driver.
-
Connect to Real-Time SAP ByDesign Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP ByDesign and Dataflow to import and use SAP Business ByDesign in Power Apps.
-
Migrating data from Paddle to Snowflake using CData SSIS Components.
Easily push Paddle to Snowflake using the CData SSIS Tasks for Paddle and Snowflake.
-
How to Access ZohoInvoice Data Using Entity Framework
This article shows how to access ZohoInvoice using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate GraphQL Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live GraphQL and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Planio Replication to SQLite
Use CData Sync for automated, continuous, customizable Planio replication to SQLite.
-
Visualize Bullhorn CRM Data in Tableau
The CData ODBC driver for Bullhorn CRM enables you integrate Bullhorn CRM into Tableau dashboards.
-
How to load AfterShip data into Elasticsearch via Logstash
Introducing a simple method to load AfterShip data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Cline with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live CSV/TSV Files from within your IDE.
-
Build Automated Workflows with Live Cvent Data in Workato
Use CData Connect AI to connect to live Cvent and build automated workflows in Workato.
-
Integrating Antigravity CLI with Zoho Books via CData CLI
Connect Zoho Books to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Greenplum-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Greenplum Data and create custom apps in Mendix.
-
Enable the Workday JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Workday.
-
How to Query Live Redshift Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amazon Redshift data in natural language using Python.
-
Automated Continuous Flowlu Replication to MongoDB
Use CData Sync for automated, continuous, customizable Flowlu replication to MongoDB.
-
Automated Continuous Kafka Replication to Snowflake
Use CData Sync for automated, continuous, customizable Kafka replication to Snowflake.
-
Automated Continuous Printful Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Printful replication to Amazon Redshift.
-
A PostgreSQL Interface for Freshsales Data using the CData ODBC Driver
Use the SQL Gateway and Freshsales ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build an OLAP Cube in SSAS from Shortcut Data
Establish a connection to Shortcut data from SQL Server Analysis Services, and use the Shortcut Data Provider to build OLAP cubes for use in analytics and reporting.
-
Working with Salesforce Data 360 Data in LINQPad
Execute LINQ queries to Salesforce Data 360 in LINQPad.
-
Create Power BI Reports on Real-Time SageHR Data
Use the CData ODBC Driver for SageHR to visualize SageHR in Power BI Desktop.
-
How to Query Oracle HCM Cloud Data in MySQL Workbench
Execute MySQL queries against live Oracle HCM Cloud from MySQL Workbench.