CData Software - Knowledge Base
Recent Articles
-
Connect to Facebook Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Facebook as an External Source in Dremio.
-
Visualize Live Acumatica Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Acumatica data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to FreshBooks Data from a Connection Pool in JBoss
Integrate FreshBooks data into Java servlets: Use the Management Console in JBoss to install the FreshBooks JDBC Driver.
-
How to publish and share Anaplan Data dashboards with Tableau Server
The CData ODBC driver for Anaplan enables you integrate Anaplan data into Tableau dashboards.
-
Extract, Transform, and Load CockroachDB Data in Informatica PowerCenter
Create a simple Workflow for CockroachDB data in Informatica PowerCenter.
-
Create Informatica Mappings From/To an ODBC Data Source for FreeAgent
Create an ODBC connection to FreeAgent in Informatica and browse and transfer FreeAgent data.
-
How to Easily Query Microsoft Exchange Data in OpenOffice Base
Connect to Microsoft Exchange data in OpenOffice Base using the CData ODBC Driver for Microsoft Exchange and generate reports with live data insights.
-
Build Apps with Live Neo4J data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Neo4J data into the Adalo platform and build custom mobile and web applications with real-time Neo4J data.
-
Integrate Cursor with Live Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Typeform data from within the editor.
-
Connect to Twitter Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Twitter Ads data.
-
Integrate with Asana Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Asana data in SnapLogic.
-
How to connect Amazon QuickSight to Jira Data
Create a connection to Jira data in CData Connect AI and insert Jira data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for eBay Analytics
Provide connectivity to eBay Analytics data through an SAP BusinessObjects universe.
-
Design BIRT Reports on Amazon Marketplace Data
Provide current Amazon Marketplace data to your embedded analytics.
-
Build Automated Workflows with Live Printify Data in Workato
Use CData Connect AI to connect to live Printify data and build automated workflows in Workato.
-
Integrating OpenCode with BambooHR 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Retently
Create Retently data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Using the CData Software ODBC Driver for ClickTime in PyCharm
Connect to ClickTime as an ODBC data source in PyCharm using the CData Software ODBC Driver for ClickTime.
-
Integrate Google's Vertex AI Agent with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Vertica data within intelligent workflows.
-
Integrate Theia IDE with Live Raisers Edge NXT 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 Raisers Edge NXT data from within the development environment.
-
Use Azure AI Foundry to Talk to Your Klipfolio 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 Klipfolio data for you.
-
Use Biml to Build SSIS Tasks to Replicate Azure Synapse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Synapse data to SQL Server.
-
Load Harvest Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Harvest data to a database.
-
Natively Connect to DB2 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to DB2 data. Leverage the native support for ODBC in PHP.
-
Integrating Cursor with Klaviyo 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.
-
Connecting Moonlit Workflow with SingleStore 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 SingleStore data in real time.
-
Getting Started with the CData JDBC Driver for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for QuickBooks Time.
-
How to Connect to & Open Amazon DynamoDB Data in Microsoft Excel
This article uses the CData ODBC driver for Amazon DynamoDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Rapidly Develop Procore-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 Procore.
-
Integrate with live Salesforce Marketing Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce Marketing data in Jitterbit.
-
Import Real-Time QuickBooks Online Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use QuickBooks Online data in ColdFusion.
-
Automated Continuous Insightly Replication to Databricks
Use CData Sync for automated, continuous, customizable Insightly replication to Databricks.
-
Connect to Bitbucket Data from Crystal Reports
Use CData Connect AI to connect to and report on live Bitbucket data from Crystal Reports.
-
How to connect PolyBase to Apify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apify data.
-
Visualize Live GitHub Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live GitHub data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Unbounce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Unbounce data in the Denodo Virtual DataPort Administrator.
-
Build Reply.io-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Reply.io data.
-
Work with Scrapfly Data in FoxPro
Load Scrapfly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Hacker News Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Hacker News.
-
Automated Continuous SurveyMonkey Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to delimited files (CSV/TSV).
-
Seamlessly Bring Gong Data into Retool Using CData Connect AI
Integrate Gong data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Paylocity Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Paylocity data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Phoenix Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Phoenix replication to IBM DB2.
-
Automated Continuous Oracle Financials Cloud Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Databricks.
-
Link Greenhouse with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Greenhouse data in Filemaker Pro for Mac or Windows.
-
Use Dash to Build to Web Apps on Eventbrite Data
Create Python applications that use pandas and Dash to build Eventbrite-connected web apps.
-
Query Couchbase Data in ColdFusion
Write standard ColdFusion data access code to connect to Couchbase data.
-
How to Visualize Instantly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Instantly data in Python.
-
Connect to Google Directory Data in HULFT Integrate
Connect to Google Directory as a JDBC data source in HULFT Integrate
-
Build Dashboards with Auth0 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Auth0 data in Dundas BI.
-
Connect to Float Data in HULFT Integrate
Connect to Float as a JDBC data source in HULFT Integrate
-
Use the CData Software JDBC Driver for Hubstaff in MicroStrategy Web
Connect to Hubstaff data in MicroStrategy Web using the CData Software JDBC Driver for Hubstaff.
-
Integrating GitHub Copilot with Webex 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.
-
Integrate Devin with Live Microsoft OneDrive 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 Microsoft OneDrive data.
-
Connect to PostgreSQL Data in DBArtisan
Use wizards in DBArtisan to configure PostgreSQL data as a data source.
-
Access LightSpeedRetail Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LightSpeedRetail data from HeidiSQL.
-
Create Reports with ServiceDesk Plus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ServiceDesk Plus data.
-
Provide OData Services of Mistral AI Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Mistral AI data by developing a WCF Service Application.
-
Query Live SAP Concur 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 SAP Concur data directly from the development environment.
-
Build IBM Informix-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live IBM Informix data without replication.
-
Visualize Live Microsoft Exchange Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Exchange data.
-
Access Live Sage 300 Data in AWS Lambda
Connect to live Sage 300 data in AWS Lambda using the CData JDBC Driver.
-
Automate Klipfolio Data Replication to Couchbase
Use CData Sync to Customize and automate Klipfolio data replication to Couchbase.
-
Create Google Calendar-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Calendar Data from OutSystems and build custom enterprise apps using live Google Calendar data.
-
How to connect to JobNimbus Data from Spring Boot
Connect to JobNimbus in a Spring Boot Application using the CData API Driver for JDBC
-
Work with Live ShipStation Data in Power Query
Use CData Connect AI to connect to ShipStation data and work with live ShipStation data in Microsoft Power Query.
-
Integrating Boomi Agentstudio with Highrise Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Highrise data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Data Flows from Oracle SCM to SQL Server using SSIS
Easily back up Oracle SCM data to SQL Server using the SSIS components for Oracle SCM.
-
Query Google Ads Data in DataGrip
Create a Data Source for Google Ads in DataGrip and use SQL to query live Google Ads data.
-
Connect to Insightly Data in HULFT Integrate
Connect to Insightly as a JDBC data source in HULFT Integrate
-
LINQ to Onfleet 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 Onfleet Data Provider.
-
Query Live Google Directory 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 Google Directory data directly from the development environment.
-
Integrating GitHub Copilot with Campaigner 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 Work with Accelo Data in ETL Validator JDBC
Connect to Accelo from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a Singer.io Tap for Dotmailer With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dotmailer data using the CData Python Connector.
-
Connect to GetResponse Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GetResponse data from Filemaker Pro on Mac.
-
Create Data Visualizations in Cognos BI with Front Data
Access Front data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Postmark Data in ColdFusion
Write standard ColdFusion data access code to connect to Postmark data.
-
How to import Beeminder Data into Apache Solr
Use the CData Software JDBC Driver for Beeminder in Data Import Handler and create an automated import of Beeminder data to Apache Solr Enterprise Search platform.
-
Build Pipelines with Live SQL Analysis Services Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SQL Analysis Services from Google Cloud Data Fusion, enabling the integration of live SQL Analysis Services data into the building and management of effective data pipelines.
-
Access Live BambooHR Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BambooHR data from your Google Sheets.
-
Automate CloudConvert Data Replication to Couchbase
Use CData Sync to Customize and automate CloudConvert data replication to Couchbase.
-
Manage Okta Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Okta.
-
Automated Continuous Telegram Replication to Databricks
Use CData Sync for automated, continuous, customizable Telegram replication to Databricks.
-
Build Agents in Relevance AI with Access to Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Reckon Accounts Hosted data within intelligent agent workflows.
-
How to integrate Asana with Apache Airflow
Access and process Asana data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Neo4J Replication to MySQL
Use CData Sync for automated, continuous, customizable Neo4J replication to MySQL.
-
Connect to Dotmailer Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Dotmailer and work with Dotmailer data in your FileMaker applications.
-
Create Informatica Mappings From/To an ODBC Data Source for Apollo
Create an ODBC connection to Apollo in Informatica and browse and transfer Apollo data.
-
Analyze Couchbase Data in Cognos Analytics
Use CData Connect AI to connect to Couchbase Data from Cognos Analytics and analyze live Couchbase data.
-
Visualize Google Calendar Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Calendar data.
-
Natively Connect to Mocean Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mocean data. Leverage the native support for ODBC in PHP.
-
Connect to VWO Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for VWO data in Airbyte.
-
How to import Reckon Data into Apache Solr
Use the CData Software JDBC Driver for Reckon in Data Import Handler and create an automated import of Reckon data to Apache Solr Enterprise Search platform.
-
Connect to Monday.com Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Monday.com data from Filemaker Pro on Mac.
-
Getting Started with the CData Excel Add-In for Printify
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Printify.
-
Create Informatica Mappings From/To a JDBC Data Source for PolarTeamPro
Create PolarTeamPro data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Work with Live CouchDB Data in Power Query
Use CData Connect AI to connect to CouchDB data and work with live CouchDB data in Microsoft Power Query.
-
Publish Reports with Jumpseller Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jumpseller data.
-
Use JayDeBeApi to access Twilio Data in Python
Use standard Python scripting and the development environment of your choice to access live Twilio data.