CData Software - Knowledge Base
Recent Articles
-
Build AI Agents with MailChimp 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 MailChimp through CData Connect AI.
-
Access Live Tanda Data in AWS Lambda
Connect to live Tanda in AWS Lambda using the CData JDBC Driver.
-
Load Samanage Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Samanage to a database.
-
Connect to Hugging Face Data in Ruby
Connect to Hugging Face in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create SSAS Tabular Models from Aha! Data
How to build a SQL Server Analysis Service Tabular Model from Aha! using CData drivers.
-
Create SurveyMonkey Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SurveyMonkey data access from reports, embedded analytics, and more.
-
Access Live QuickBooks Time Data in TIBCO Data Virtualization
Use the QuickBooks Time Tibco DV Adapter to create a QuickBooks Time data source in TIBCO Data Virtualization Studio and gain access to live QuickBooks Time from your TDV Server.
-
How to Use a Microsoft Access Database to Update HBase Data in Real Time
Update HBase data by creating a linked table in Microsoft Access with the CData HBase ODBC Driver.
-
Build Confluence-Connected Apps in Choreo
Use CData Connect AI to connect to Confluence Data from Choreo and build custom apps using live Atlassian Confluence.
-
Visualize Live JotForm Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live JotForm using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Reports from Basecamp Data in Looker Studio
Use CData Connect AI to gain access to live Basecamp and create custom reports in Looker Studio.
-
Access Workday 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 Workday.
-
Analyze Asana Data in Cognos Analytics
Use CData Connect AI to connect to Asana Data from Cognos Analytics and analyze live Asana.
-
How to connect to YouTube Analytics Data from IntelliJ
Integrate connectivity to YouTube Analytics with wizards in IntelliJ.
-
Analyze Okta Data in Cognos Analytics
Use CData Connect AI to connect to Okta Data from Cognos Analytics and analyze live Okta.
-
Migrating data from Acumatica to Google BigQuery using CData SSIS Components.
Easily push Acumatica ERP to Google BigQuery using the CData SSIS Tasks for Acumatica and Google BigQuery.
-
Replicate Jira Assets Data to Multiple Databases
Replicate Jira Assets to disparate databases with a point-and-click configuration.
-
Automated Continuous SAP Fieldglass Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Databricks.
-
Create Data Visualizations Based On SAP BusinessObjects BI Data in Mode
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Mode and build visualizations using live
-
Easily Integrate PhantomBuster Data in Lazarus Pascal IDE
Learn how to easily integrate live PhantomBuster in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to MySQL from a Connection Pool in WebLogic
Use the CData JDBC Driver for MySQL to connect to MySQL from Web applications running on WebLogic.
-
How to Query Live Twitter Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Twitter Ads data in natural language using Python.
-
Integrate Twitter Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Twitter Ads from Informatica Cloud.
-
How to Seamlessly Import Perigon Data into IBM SPSS Modeler
Integrate Perigon data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Semantic Layer Views for ChartMogul Data in APOS Live Data Gateway
Use the CData Connector for ChartMogul in APOS Live Data Gateway to build Semantic Layer Views for ChartMogul.
-
Connect to Aweber Data from a Connection Pool in Jetty
The Aweber JDBC Driver supports connection pooling: This article shows how to connect faster to Aweber from Web apps in Jetty.
-
Connect to Yelp Data from a Connection Pool in Jetty
The Yelp JDBC Driver supports connection pooling: This article shows how to connect faster to Yelp from Web apps in Jetty.
-
Automated Continuous AgileCRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable AgileCRM replication to Snowflake.
-
Build a PostgreSQL Interface for Zoho Creator Data using the CData JDBC Driver
Use the Remoting features of the Zoho Creator JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Snowflake Data in Delphi
DataBind to Snowflake in Delphi with standard data access components and controls.
-
Build QuickBooks Online Visualizations in Tableau Cloud
Use CData Connect AI to connect to live QuickBooks Online and build visualizations in Tableau Cloud.
-
Query Vercel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Vercel from Node.js.
-
How to Query Authorize.Net Data in MySQL Workbench
Execute MySQL queries against live Authorize.Net from MySQL Workbench.
-
Access Live SAP Business One Data in Excel 365 Online (Excel for the web)
Connect to SAP Business One from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Reports with BigQuery Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google BigQuery.
-
How to Connect to Live Avalara AvaTax Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Avalara AvaTax for you.
-
Integrate with Timely Data in JReport Designer
Create charts and reports based on Timely in JReport Designer.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Acumatica actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrating GitHub Copilot CLI with SendPulse 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.
-
Getting Started with the CData Power BI Connector for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Twitter Ads.
-
Bridge MySQL Connectivity with Apache NiFi
Access and process MySQL in Apache NiFi using the CData JDBC Driver.
-
Create Apps from Google Ad Manager Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Ad Manager Data and build apps from live Google Ad Manager in Qlik Sense Cloud.
-
Build Dashboards with Egnyte Data in Dundas BI
Create dynamic dashboards and perform analytics based on Egnyte in Dundas BI.
-
Query Azure Table Data in DataGrip
Create a Data Source for Azure Table in DataGrip and use SQL to query live Azure Table Storage.
-
Query Greenplum Data as a MySQL Database in Node.js
Execute MySQL queries against Pivotal GreenPlum from Node.js.
-
Build a Simple VCL Application for Brex Data
How to build a simple VCL Application to view Brex in RAD Studio using the CData ODBC Driver for Brex.
-
Create Dashboards and Visualize Live Quickbase Data in Geckoboard
Use CData Connect AI to connect to live Quickbase and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData ODBC Driver for Cvent in Microsoft Power Query
You can use the CData Cvent ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Cvent into Microsoft Power Query.
-
Automated Continuous ZarMoney Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZarMoney replication to Azure SQL Database.
-
Integrate with Wave Financial Data in JReport Designer
Create charts and reports based on Wave Financial in JReport Designer.
-
Create Reports with Amplitude Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amplitude.
-
Moving Data from Factorial to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Factorial data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating ZohoDesk Data in Talend Cloud Data Management Platform
Connect ZohoDesk Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Databricks Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Databricks and the Script function in FileMaker Pro to connect to Databricks and work with Databricks in your FileMaker application.
-
Connect to Facebook from a Connection Pool in WebLogic
Use the CData JDBC Driver for Facebook to connect to Facebook from Web applications running on WebLogic.
-
Getting Started with the CData Tableau Connector for Hubstaff
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Establish a Live Connection with LaunchDarkly Data using Tableau Bridge
The CData ODBC Driver for LaunchDarkly enables you to integrate live LaunchDarkly into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect and Visualize Live Zoho Projects Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoho Projects into the Databricks platform and create visualization dashboards with real-time Zoho Projects.
-
How to connect PolyBase to Avro
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Avro.
-
Build Azure Data Catalog-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Azure Data Catalog to explore live Azure Data Catalog Data in Claude Code to assist with building Azure Data Catalog-powered applications.
-
Visualize Mailjet Data in Sisense
Create an ElastiCube in Sisense app with access to Mailjet.
-
Publish Crystal Reports on Pingdom Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pingdom.
-
Bridge EmailOctopus Connectivity with Apache NiFi
Access and process EmailOctopus in Apache NiFi using the CData JDBC Driver.
-
Okta Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Okta through CData Connect AI using different applications and tools.
-
Integrate Theia IDE with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Bidirectional Access to FreeAgent Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate FreeAgent in Filemaker Pro for Mac or Windows.
-
Using the CData Software ODBC Driver for Salesloft in PyCharm
Connect to Salesloft as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesloft.
-
Connect to PhantomBuster Data in CloverDX (formerly CloverETL)
Transfer PhantomBuster using the visual workflow in the CloverDX data integration tool.
-
Connect to SFTP Data in Claris FileMaker Pro
Use the CData ODBC Driver for SFTP in FileMaker Pro to connect to SFTP and work with SFTP in your FileMaker applications.
-
Using the CData Software ODBC Driver for SparkPost in PyCharm
Connect to SparkPost as an ODBC data source in PyCharm using the CData Software ODBC Driver for SparkPost.
-
Connect to Oracle Sales Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Sales in Google Apps Script.
-
A PostgreSQL Interface for Twilio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Twilio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Salesforce-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Salesforce to explore live Salesforce Data in Cursor to assist with building Salesforce-powered applications.
-
Integrate with SAP BusinessObjects BI Data in JReport Designer
Create charts and reports based on SAP BusinessObjects BI in JReport Designer.
-
Publish Adobe Experience Manager-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Adobe Experience Manager.
-
Use the CData Software ODBC Driver for Contentful in MicroStrategy Web
Connect to Contentful in MicroStrategy Web using the CData Software ODBC Driver for Contentful.
-
How to import Chargebee Data into Apache Solr
Use the CData Software JDBC Driver for Chargebee in Data Import Handler and create an automated import of Chargebee to Apache Solr Enterprise Search platform.
-
Automate Outreach.io Data Replication to Couchbase
Use CData Sync to Customize and automate Outreach.io replication to Couchbase.
-
Create Greenplum-Connected Dashboards in Grafana
Connect to Greenplum Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Pivotal GreenPlum.
-
Migrating data from Stripe to Snowflake using CData SSIS Components.
Easily push Stripe to Snowflake using the CData SSIS Tasks for Stripe and Snowflake.
-
Provide OData Services of Reply.io Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Reply.io by developing a WCF Service Application.
-
Connect to Neo4J Data from AWS Glue
Use CData Connect AI to gain access to live Neo4J from your AWS Glue jobs.
-
Getting Started with the CData Python Connector for Planio
Learn to install and license the CData Python Connector
-
Integrating Codex CLI with Opsgenie 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.
-
Automated Continuous MailChimp Replication to Oracle
Use CData Sync for automated, continuous, customizable MailChimp replication to Oracle.
-
How to connect to Webflow Data with Squirrel SQL client
Connect to Webflow and execute queries in the Squirrel SQL Client.
-
Create Balance Sheet Detail Reports in QuickBooks Online Using a New Stored Procedure
Connect to QuickBooks Online using the CData JDBC driver and run a stored procedure to create balance sheet detail reports.
-
Build an OLAP Cube in SSAS from Suadeo Data
Establish a connection to Suadeo data from SQL Server Analysis Services, and use the Suadeo Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create an RPA flow for Quickbase Data in UiPath Studio
Use the Quickbase ODBC Driver to create workflows that access real-time Quickbase without any coding.
-
LINQ to Neo4J Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Neo4J Data Provider.
-
Connect ScrapingBee Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ScrapingBee using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for Sage 200 in MicroStrategy Web
Connect to Sage 200 in MicroStrategy Web using the CData Software JDBC Driver for Sage 200.
-
Use the CData ODBC Driver for Dotmailer from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dotmailer to connect to Dotmailer from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dotmailer in Excel.
-
Create Datasets from Zoom in Domo Workbench and Build Visualizations of Zoom Data in Domo
Use the CData Software ODBC Driver for Zoom to create datasets from Zoom in Domo Workbench and then build visualizations in the Domo service.
-
Visualize ServiceNow Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ServiceNow.
-
Connect to Oracle Eloqua Reporting Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Eloqua Reporting in DBeaver.
-
Build Slack-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Slack.
-
Integrating Antigravity CLI with AdRoll via CData CLI
Connect AdRoll to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query Live Epicor Kinetic Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Epicor Kinetic directly from the development environment.
-
Rapidly Develop SAP SuccessFactors LMS-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 SAP SuccessFactors LMS.