CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code CLI with Clio 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.
-
How to publish and share SAP Concur Data dashboards with Tableau Server
The CData ODBC driver for SAP Concur enables you integrate SAP Concur data into Tableau dashboards.
-
Natively Connect to Bitbucket Data in PHP
The CData ODBC driver for Bitbucket enables you to create PHP applications with connectivity to Bitbucket data. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for Amazon DynamoDB in Microsoft Power Query
You can use the CData Amazon DynamoDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon DynamoDB data into Microsoft Power Query.
-
Build ZohoDesk Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ZohoDesk data and build visualizations in Tableau.
-
Automate Scrapfly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Scrapfly data from PowerShell? This article demonstrates how to utilize the Scrapfly Cmdlets for tasks like connecting to Scrapfly data, automating operations, downloading data, and more.
-
Replicate CouchDB Data in Heroku for Use in Salesforce Connect
Replicate CouchDB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData SSIS Components to Insert New or Update Existing Active Directory Records from SQL Server
Easily push SQL Server data to Active Directory using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Active Directory or update existing records with data from a SQL Server database.
-
Working with Placid Data in LINQPad
Execute LINQ queries to Placid data in LINQPad.
-
Connect to Amazon Athena Data from a Connection Pool in JBoss
Integrate Amazon Athena data into Java servlets: Use the Management Console in JBoss to install the Amazon Athena JDBC Driver.
-
Replicate Multiple Omnisend Accounts
Replicate multiple Omnisend accounts to one or many databases.
-
Configure the CData JDBC Driver for Auth0 in a Connection Pool in Tomcat
Connect to Auth0 data from a connection pool in Tomcat.
-
Connect to ZohoMarketingHub Data from HeidiSQL
Use CData Connect AI to connect to and query live ZohoMarketingHub data from HeidiSQL.
-
How to work with Opsgenie Data in Apache Spark using SQL
Access and process Opsgenie Data in Apache Spark using the CData Software JDBC Driver.
-
Build Adobe Commerce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Commerce data.
-
How to Connect DBeaver to SAP Business One via a JDBC Driver
Manage SAP Business One data with visual tools in DBeaver like the query browser.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle HCM Cloud
Provide connectivity to Oracle HCM Cloud data through an SAP BusinessObjects universe.
-
Getting Started with the CData Connect AI Python SDK for Oracle Financials Cloud
Install the CData Connect AI Python SDK to read live Oracle Financials Cloud data with standard DB-API 2.0 Python code.
-
Build Data Flows from Cloudflare to SQL Server using SSIS
Easily back up Cloudflare data to SQL Server using the SSIS components for Cloudflare.
-
How to Visualize Google Directory Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Directory data in Python.
-
Automated Continuous Clockify Replication to SQLite
Use CData Sync for automated, continuous, customizable Clockify replication to SQLite.
-
Integrate Devin with Live SendGrid Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SendGrid data.
-
Create a Data Access Object for ZarMoney Data using JDBI
A brief overview of creating a SQL Object API for ZarMoney data in JDBI.
-
Use JayDeBeApi to access Marketo Data in Python
Use standard Python scripting and the development environment of your choice to access live Marketo data.
-
Connecting Agentforce with Outreach.io Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Outreach.io data for you.
-
Access Live Neo4J Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Neo4J data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Typeform Data to Multiple Databases via the CData Sync CLI
Replicate Typeform data to disparate databases with a single configuration.
-
How to create an RPA flow for Exact Online Data in UiPath Studio
Use the Exact Online ODBC Driver to create workflows that access real-time Exact Online data without any coding.
-
Integrate Theia IDE with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Microsoft Ads data from within the development environment.
-
Connect to Datadog Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Datadog and the SQL Gateway to access Datadog data from Google Apps Script.
-
Create Informatica Mappings From/To a JDBC Data Source for HelloSign
Create HelloSign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Vercel Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Vercel data into TIBCO Spotfire.
-
Connect to PhantomBuster Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PhantomBuster data using standard SQL.
-
Visualize Live Instagram Data in the Power BI Service
Use CData Connect AI to connect to live Instagram data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to BigCommerce Data from Spring Boot
Connect to BigCommerce in a Spring Boot Application using the CData JDBC Driver for BigCommerce
-
Connect to Google Sheets Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Sheets and the Script function in FileMaker Pro to connect to Google Sheets and work with Google Sheets data in your FileMaker application.
-
Natively Connect to ElevenLabs Data in PHP
The CData ODBC driver for ElevenLabs enables you to create PHP applications with connectivity to ElevenLabs data. Leverage the native support for ODBC in PHP.
-
Working with Hubstaff Data in LINQPad
Execute LINQ queries to Hubstaff data in LINQPad.
-
Connect to CircleCI in SpagoBI
Create reports featuring live CircleCI data in SpagoBI Studio. Host CircleCI reports on SpagoBI Server.
-
LINQ to Google Contacts 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 Google Contacts Data Provider.
-
Connect to Sendwithus Data in CloverDX (formerly CloverETL)
Transfer Sendwithus data using the visual workflow in the CloverDX data integration tool.
-
Create a Data Access Object for PabblySubscriptions Data using JDBI
A brief overview of creating a SQL Object API for PabblySubscriptions data in JDBI.
-
Configure the CData JDBC Driver for Eventbrite in a Connection Pool in Tomcat
Connect to Eventbrite data from a connection pool in Tomcat.
-
View Reports on Real-Time NetSuite Data in Power BI Report Server
Use the CData ODBC Driver for NetSuite to visualize NetSuite data in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze Redshift Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Redshift data with the CData JDBC Driver for Redshift.
-
Getting Started with the CData Tableau Connector for HCL Domino
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for HCL Domino.
-
Integrating LangChain with XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on XML data within automated workflows.
-
Build AI Agents with Couchbase 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 Couchbase data through CData Connect AI.
-
Connect to Zoho Projects Data in RazorSQL
Connect to Zoho Projects from wizards and query Zoho Projects data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Teamgate Replication to SQLite
Use CData Sync for automated, continuous, customizable Teamgate replication to SQLite.
-
Connect to Telegram from a Connection Pool in WebLogic
Use the CData JDBC Driver for Telegram to connect to Telegram data from Web applications running on WebLogic.
-
Integrate with Live Microsoft OneDrive Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft OneDrive from the MuleSoft Anypoint Platform to integrate live Microsoft OneDrive data into custom reports and dashboards.
-
Use the CData Software JDBC Driver for Timely in MicroStrategy Web
Connect to Timely data in MicroStrategy Web using the CData Software JDBC Driver for Timely.
-
Publish Crystal Reports on Insightly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Insightly data.
-
Integrating LangGraph with Adobe Target Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Adobe Target data within automated workflows.
-
Manage Pinecone Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Pinecone.
-
Load Wrike Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Wrike data to a database.
-
Connect to Xero Data in DBArtisan
Use wizards in DBArtisan to configure Xero data as a data source.
-
Access Live Confluence Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Confluence data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Extract, Transform, and Load Typeform Data in Informatica PowerCenter
Create a simple Workflow for Typeform data in Informatica PowerCenter.
-
Easily Integrate Phoenix Data in Lazarus Pascal IDE
Learn how to easily integrate live Phoenix data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to ZohoSubscriptions Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoSubscriptions data from PowerBuilder using the ZohoSubscriptions JDBC Driver.
-
Connect to Attio Data in Aqua Data Studio
Access Attio data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Bitbucket Data in Google Apps Script via Connect AI
Use CData Connect AI to access Bitbucket data in Google Apps Script.
-
Create ConstantContact Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ConstantContact data access from reports, embedded analytics, and more.
-
Create Data Visualizations in Cognos BI with Excel Data
Access Excel data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Creating Typeform-Connected Applications in Unqork
You can use CData Connect AI to feed Typeform data to Unqork and build custom business apps.
-
Access Cosmos DB Data from MySQL in PHP
Connect to Cosmos DB through the standard MySQL libraries in PHP.
-
Manage Mode Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mode.
-
Access Live Confluence Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Confluence data into the statistical analysis tools available in SAS JMP. This article shows how to use Confluence data in the Graph Builder and Query Builder.
-
Integrating GitHub Copilot with Acumatica 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.
-
How to Query Act CRM Data in MySQL Workbench
Execute MySQL queries against live Act CRM data from MySQL Workbench.
-
Integrate with Certinia Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Certinia data in SnapLogic.
-
Replicate Lakebase Data from PowerShell
Write a quick PowerShell script to query Lakebase data. Use connectivity to the live data to replicate Lakebase data to SQL Server.
-
How to Connect to Live Amazon Athena Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Amazon Athena data without replication.
-
Getting Started with the CData ODBC Driver for Outreach.io
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Outreach.io.
-
Integrate Live ServiceDesk Plus Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ServiceDesk Plus data and integrate live ServiceDesk Plus data into apps built in Microsoft Power Apps.
-
Create Apps from iContact Data in Qlik Sense Cloud
Use CData Connect AI to connect to iContact Data and build apps from live iContact data in Qlik Sense Cloud.
-
How to Connect to Live Presto Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Presto data for you.
-
Connect to Splunk Data in DBArtisan
Use wizards in DBArtisan to configure Splunk data as a data source.
-
How to Connect to Live Marketo Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Marketo data for you.
-
Integrate PhantomBuster Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PhantomBuster data from Informatica Cloud.
-
How to import HubDB Data into Apache Solr
Use the CData Software JDBC Driver for HubDB in Data Import Handler and create an automated import of HubDB data to Apache Solr Enterprise Search platform.
-
How to Build an ETL App for ConvertAPI Data in Python with CData
Create ETL applications and real-time data pipelines for ConvertAPI data in Python with petl.
-
Automate OnePageCrm Data Replication to SAP HANA
Use CData Sync to customize and automate OnePageCrm data replication to SAP HANA.
-
Build Automated Gong-Connected Workflows in Zapier
Use CData Connect AI to connect to live Gong data and build automated workflows in Zapier.
-
Migrating data from FHIR to Snowflake using CData SSIS Components.
Easily push FHIR data to Snowflake using the CData SSIS Tasks for FHIR and Snowflake.
-
Natively Connect to Accelo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Accelo data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Power BI Connector for Jodoo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Query, Visualize, and Share live Timely Data in Redash
Use CData Connect AI to connect to live Timely data in Redash for querying, visualizing, and sharing.
-
Publish Retently-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Retently data.
-
Integrate BigCommerce Data in Pentaho Data Integration
Build ETL pipelines based on BigCommerce data in the Pentaho Data Integration tool.
-
How to integrate Metabase with Salesforce Data 360 Data
Use CData Connect AI to connect to live Salesforce Data 360 data and create an interactive dashboard in Metabase from Salesforce Data 360 data.
-
Prepare, Blend, and Analyze PhantomBuster Data in Alteryx Designer (ODBC)
Build workflows to access live PhantomBuster data for self-service data analytics.
-
How to create an RPA flow for Teradata Data in UiPath Studio
Use the Teradata ODBC Driver to create workflows that access real-time Teradata data without any coding.
-
How to connect to Hacker News Data from Spring Boot
Connect to Hacker News in a Spring Boot Application using the CData API Driver for JDBC
-
Build Apps with Live Toggl data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Toggl data into the Adalo platform and build custom mobile and web applications with real-time Toggl data.
-
Automate Microsoft OneDrive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft OneDrive data from PowerShell? This article demonstrates how to utilize the Microsoft OneDrive Cmdlets for tasks like connecting to Microsoft OneDrive data, automating operations, downloading data, and more.
-
Automated Continuous JSON Replication to SingleStore
Use CData Sync for automated, continuous, customizable JSON replication to SingleStore.
-
Integrate Dify with Live SAP SuccessFactors Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SAP SuccessFactors data.