CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to DB2 via a JDBC Driver
Manage IBM DB2 with visual tools in DBeaver like the query browser.
-
Automate Kafka Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Kafka replication to SAP HANA.
-
Automated Continuous TaxJar Replication to SingleStore
Use CData Sync for automated, continuous, customizable TaxJar replication to SingleStore.
-
Migrating data from Clio to Databricks using CData SSIS Components.
Easily push Clio to Databricks using the CData SSIS Tasks for Clio and Databricks.
-
How to create an RPA flow for Flowlu Data in UiPath Studio
Use the Flowlu ODBC Driver to create workflows that access real-time Flowlu without any coding.
-
Automate Google Sheets Data Replication to Couchbase
Use CData Sync to Customize and automate Google Sheets replication to Couchbase.
-
Natively Connect to Harvest Data in PHP
The CData ODBC driver for Harvest enables you to create PHP applications with connectivity to Harvest. Leverage the native support for ODBC in PHP.
-
Analyze WordPress Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze WordPress in Microsoft R Open.
-
Stream CapsuleCRM Data into Apache Kafka Topics
Access and stream CapsuleCRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Natively Connect to Hugging Face Data in PHP
The CData ODBC driver for Hugging Face enables you to create PHP applications with connectivity to Hugging Face. Leverage the native support for ODBC in PHP.
-
Connect to and Query Presto Data in QlikView over ODBC
Create data visualizations with Presto in QlikView.
-
Create Dynamic BambooHR Grids Using the Infragistics XamDataGrid
Learn how you can connect BambooHR to Infragistics XamDataGrid to build dynamic grids.
-
How to import Aweber Data into Apache Solr
Use the CData Software JDBC Driver for Aweber in Data Import Handler and create an automated import of Aweber to Apache Solr Enterprise Search platform.
-
Bind Live REST Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live REST data
-
Create Informatica Mappings From/To a JDBC Data Source for Landbot
Create Landbot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Hubstaff Data in DBArtisan
Use wizards in DBArtisan to configure Hubstaff as a data source.
-
Using the CData Software ODBC Driver for Act-On in PyCharm
Connect to Act-On as an ODBC data source in PyCharm using the CData Software ODBC Driver for Act-On.
-
Integrate with Flowlu Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Flowlu to a JSON file on disk.
-
Create MongoDB-Connected Applications in Appsmith
Connect to MongoDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MongoDB.
-
Moving Data from ZeroBounce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZeroBounce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Import Klaviyo Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Klaviyo Data and provide access to live Klaviyo for custom reports in the Power BI Service.
-
Connect to Tavily Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Tavily using standard SQL.
-
Enable the Typeform JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Typeform.
-
Easily Integrate Bright Data Data in Lazarus Pascal IDE
Learn how to easily integrate live Bright Data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Dynamics NAV Data in NetBeans
Connect to Microsoft Dynamics NAV in NetBeans with the data source configuration wizard.
-
How to Connect to EmailOctopus Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to EmailOctopus. Leverage the pyodbc module for ODBC in Python.
-
Connect to Oracle Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Database using standard SQL.
-
Build Exact Online-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Exact Online and build Exact Online-connected web apps with Axios.
-
How to connect to Datadog Data from Spring Boot
Connect to Datadog in a Spring Boot Application using the CData API Driver for JDBC
-
Access LaunchDarkly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LaunchDarkly from your Oracle system.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Email using the Model Context Protocol.
-
Create Data Visualizations Based On Google Contacts Data in Mode
Use CData Connect AI to connect to Google Contacts Data from Mode and build visualizations using live
-
Connect to TigerGraph Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for TigerGraph and the SQL Gateway to access TigerGraph from Google Apps Script.
-
Integrate with Aircall Data in JReport Designer
Create charts and reports based on Aircall in JReport Designer.
-
Getting Started with the CData ADO.NET Provider for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build MVC Applications with Connectivity to Todoist Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Todoist from an ASP.NET MVC application.
-
Connect to Adobe Target Data from a Connection Pool in Jetty
The Adobe Target JDBC Driver supports connection pooling: This article shows how to connect faster to Adobe Target from Web apps in Jetty.
-
Integrate with SendGrid Data in JReport Designer
Create charts and reports based on SendGrid in JReport Designer.
-
Work with Google Search Results in FoxPro
Load Google Search into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Reports with Google Translate Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Translate.
-
Connect to and Query Databricks Data in QlikView over ODBC
Create data visualizations with Databricks in QlikView.
-
Create Reports with Everhour Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Everhour.
-
How to Seamlessly Import Certinia Data into IBM SPSS Modeler
Integrate Certinia data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Simple VCL Application for Perplexity Data
How to build a simple VCL Application to view Perplexity in RAD Studio using the CData ODBC Driver for Perplexity.
-
Easily Integrate Cassandra Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache Cassandra in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Prepare, Blend, and Analyze CircleCI Data in Alteryx Designer (ODBC)
Build workflows to access live CircleCI for self-service data analytics.
-
Visualize Live Jira Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Atlassian Jira using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query ZohoDesk Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoDesk from Node.js.
-
Moving Data from Calendly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Calendly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Moving Data from Egnyte to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Egnyte data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live SharePoint Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft SharePoint securely in real time.
-
Automate Sage 200 Data Replication to Couchbase
Use CData Sync to Customize and automate Sage 200 replication to Couchbase.
-
Use Manus AI to Talk to Your YouTube Analytics 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 YouTube Analytics.
-
Getting Started with the CData Connect AI Python SDK for Zoho CRM
Install the CData Connect AI Python SDK to read and write live Zoho CRM with standard DB-API 2.0 Python code.
-
Moving Data from PayPal to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PayPal data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with SAP Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP ERP/NetWeaver to a JSON file on disk.
-
Build AI Agents with Vertica Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Vertica through CData Connect AI.
-
Connect to Opsgenie Data in DBArtisan
Use wizards in DBArtisan to configure Opsgenie as a data source.
-
Use Biml to Build SSIS Tasks to Replicate Salesforce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce & Force.com to SQL Server.
-
Automate Google Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Ads from PowerShell? This article demonstrates how to utilize the Google Ads Cmdlets for tasks like connecting to Google Ads, automating operations, downloading data, and more.
-
Integrate Klipfolio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Klipfolio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Klipfolio.
-
Access Live Act-On Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Act-On from your Excel spreadsheets.
-
Connect Raisers Edge NXT to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Raisers Edge NXT with IBM WebSphere for seamless data integration and connectivity.
-
Query Gumroad Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Gumroad from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Ads
Provide connectivity to Microsoft Ads through an SAP BusinessObjects universe.
-
Import SAP Ariba Source Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Ariba Source. In this article, you will use the OData format to import SAP Ariba Source into Microsoft Power Query.
-
Use Agno to Talk to Your ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your ADP for you.
-
Tickspot Reporting in OBIEE with the Tickspot JDBC Driver
Deploy the Tickspot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to PingOne in SpagoBI
Create reports featuring live PingOne in SpagoBI Studio. Host PingOne reports on SpagoBI Server.
-
Connect to NASA from a Connection Pool in WebLogic
Use the CData JDBC Driver for NASA to connect to NASA from Web applications running on WebLogic.
-
Configure the CData JDBC Driver for PDFMonkey in a Connection Pool in Tomcat
Connect to PDFMonkey from a connection pool in Tomcat.
-
Publish Twilio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Twilio.
-
Using the CData Software ODBC Driver for Shopify in PyCharm
Connect to Shopify as an ODBC data source in PyCharm using the CData Software ODBC Driver for Shopify.
-
Use Agno to Talk to Your SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft SharePoint for you.
-
Build an OLAP Cube in SSAS from Jodoo Data
Establish a connection to Jodoo data from SQL Server Analysis Services, and use the Jodoo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live ChargeOver Data in Coginiti Pro
Connect to and query live ChargeOver from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Operational Reporting on HubDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HubDB.
-
Connect to Freshservice Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Freshservice Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Bulk Import Tasks from Excel to MS Planner: Excel Add-In for MS Planner
Learn how to bulk import and manage Microsoft Planner tasks directly from Excel using the CData Excel Add-In
-
Automated Continuous PolarTeamPro Replication to SQLite
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to SQLite.
-
Build a Simple VCL Application for Pushbullet Data
How to build a simple VCL Application to view Pushbullet in RAD Studio using the CData ODBC Driver for Pushbullet.
-
How to Connect to Salesforce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce & Force.com. Leverage the pyodbc module for ODBC in Python.
-
Create Datasets from Shortcut in Domo Workbench and Build Visualizations of Shortcut Data in Domo
Use the CData Software ODBC Driver for Shortcut to create datasets from Shortcut in Domo Workbench and then build visualizations in the Domo service.
-
Connect ServiceDesk Plus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ServiceDesk Plus with IBM WebSphere for seamless data integration and connectivity.
-
How to use SQLAlchemy ORM to access Odoo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Odoo ERP.
-
Connect to Salesforce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce & Force.com using standard SQL.
-
Automated Continuous Grafana Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Grafana replication to Apache Kafka.
-
Connect to PostgreSQL Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
View Reports on Real-Time Apify Data in Power BI Report Server
Use the CData ODBC Driver for Apify to visualize Apify in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Gong Data in AWS Lambda
Connect to live Gong in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Microsoft Ads in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Ads.
-
Create Reports with Superchat Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Superchat.
-
A PostgreSQL Interface for Postmark Data using the CData ODBC Driver
Use the SQL Gateway and Postmark ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Notion in MicroStrategy
Connect to Notion in MicroStrategy Developer using the CData Software ODBC Driver for Notion.
-
How to load Wrike data into Elasticsearch via Logstash
Introducing a simple method to load Wrike data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Intercom Replication to Vertica
Use CData Sync for automated, continuous, customizable Intercom replication to Vertica.
-
Extract, Transform, and Load ZohoExpense Data in Informatica PowerCenter
Create a simple Workflow for ZohoExpense in Informatica PowerCenter.
-
Write a Simple Go Application to work with Sage Intacct Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage Intacct.
-
Operational Reporting on GraphQL Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote GraphQL.
-
How to Connect to Live Databricks Data 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 Databricks for you.