CData Software - Knowledge Base
Recent Articles
-
Access Live Dynamics 365 Data in Excel 365 Online (Excel for the web)
Connect to Dynamics 365 data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData JDBC Driver for ConstantContact
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ConstantContact.
-
DataBind Controls to Keap Data in Delphi
DataBind to Keap data in Delphi with standard data access components and controls.
-
Connect to Customer.io Data from PowerBuilder via ADO.NET
This article demonstrates how to access Customer.io data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Informatica Mappings From/To a JDBC Data Source for Reckon Accounts Hosted
Create Reckon Accounts Hosted data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Cvent Data in NetBeans
Connect to Cvent data in NetBeans with the data source configuration wizard.
-
Connect to Cohere from Asprova with CData Software ODBC Driver for Cohere
This article shows how to connect faster to Cohere data from Asprova.
-
Back Up Landbot data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Landbot data data.
-
Build a Singer.io Tap for Eventbrite With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Eventbrite data using the CData Python Connector.
-
Publish Reports with Google Spanner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Spanner data.
-
Build MVC Applications with Connectivity to Box Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Box from an ASP.NET MVC application.
-
Model Salesforce Data 360 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce Data 360, enabling the direct import of real-time Salesforce Data 360 data.
-
How to Connect the Power BI Service to Bitly: Complete Guide
Connect to the CData Software Power BI Connector for Bitly from PowerBI.com to provide real-time Bitly data across the organization.
-
Connect ServiceNow to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ServiceNow with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Omnisend Data from Crystal Reports
Use CData Connect AI to connect to and report on live Omnisend data from Crystal Reports.
-
Build Semantic Layer Views for Oracle Sales Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle Sales data.
-
Automated Continuous ServiceDesk Plus Replication to MySQL
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to MySQL.
-
Query MessageBird Data as a MySQL Database in Node.js
Execute MySQL queries against MessageBird data from Node.js.
-
How to connect to Act CRM Data with Squirrel SQL client
Connect to Act CRM data and execute queries in the Squirrel SQL Client.
-
Integrate ConvertAPI Data in Pentaho Data Integration
Build ETL pipelines based on ConvertAPI data in the Pentaho Data Integration tool.
-
Use Dash to Build Web Apps on HDFS Data via CData Connect AI
Build interactive Dash web apps on live HDFS data using pandas and the CData Connect AI Python SDK.
-
Process & Analyze CircleCI Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CircleCI Data.
-
Analyze Exa Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Exa data in Microsoft R Open.
-
Connect to Wrike Data from a Connection Pool in JBoss
Integrate Wrike data into Java servlets: Use the Management Console in JBoss to install the Wrike JDBC Driver.
-
Connect to VWO Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to VWO and work with VWO data in your FileMaker applications.
-
Access Live ZohoMarketingHub Data in Excel 365 Online (Excel for the web)
Connect to ZohoMarketingHub data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous WooCommerce Replication to MongoDB
Use CData Sync for automated, continuous, customizable WooCommerce replication to MongoDB.
-
Analyze Google Drive Data in Looker
Use CData Connect AI to connect to Google Drive Data from Looker and build custom apps using live Google Drive data.
-
Access GitLab Data from MySQL in Amazon QuickSight
Connect to GitLab and build visualizations of GitLab data using a MySQL Connection in Amazon QuickSight.
-
Integrate Reply.io Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Reply.io data from Informatica Cloud.
-
How to Connect to Live Phoenix 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 Phoenix data for you.
-
Create Datasets from Productboard in Domo Workbench and Build Visualizations of Productboard Data in Domo
Use the CData Software ODBC Driver for Productboard to create datasets from Productboard data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with QuickBooks Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy QuickBooks data to a JSON file on disk.
-
Microsoft Planner Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Planner data through CData Connect AI using different applications and tools.
-
How to Work with Datadog Data in AWS Glue Jobs Using JDBC
Connect to Datadog from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate JotForm with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate JotForm with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to JotForm data.
-
Build PostgreSQL-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for PostgreSQL Data and create custom apps in Mendix.
-
How to load Kafka data into Elasticsearch via Logstash
Introducing a simple method to load Kafka data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to QuickBooks Online Data in Google Apps Script via Connect AI
Use CData Connect AI to access QuickBooks Online data in Google Apps Script.
-
Access Live QuickBooks Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks data from your Google Sheets.
-
Build Dashboards with FreshBooks Data in Dundas BI
Create dynamic dashboards and perform analytics based on FreshBooks data in Dundas BI.
-
Integrate SurveyMonkey Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SurveyMonkey data from Informatica Cloud.
-
Create Amazon S3-Connected Nintex Workflows
Use CData Connect AI to connect to Amazon S3 Data from Nintex Workflow Cloud and build custom workflows using live Amazon S3 data.
-
Create a Data Access Object for Qualaroo Data using JDBI
A brief overview of creating a SQL Object API for Qualaroo data in JDBI.
-
Connect to DB2 from a Connection Pool in WebLogic
Use the CData JDBC Driver for DB2 to connect to DB2 data from Web applications running on WebLogic.
-
How to Connect to AlloyDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to AlloyDB data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Sage 200 Data in DBeaver
Use the CData ODBC Driver to connect to Sage 200 data in DBeaver.
-
Use Claude to Talk to Your BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your BenchmarkEmail data for you.
-
Build an OLAP Cube in SSAS from Telegram Data
Establish a connection to Telegram data data from SQL Server Analysis Services, and use the Telegram Data Provider to build OLAP cubes for use in analytics and reporting.
-
Object-Relational Mapping (ORM) with SFTP Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SFTP data into a Java-based ORM framework, Hibernate.
-
Analyze ServiceNow Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ServiceNow data in Microsoft R Open.
-
Prepare, Blend, and Analyze Optimizely Data in Alteryx Designer (Connect AI)
Build workflows to access live Optimizely data for self-service data analytics.
-
Connect to Postmark Data from a Connection Pool in Jetty
The Postmark JDBC Driver supports connection pooling: This article shows how to connect faster to Postmark data from Web apps in Jetty.
-
Integrate with Microsoft Ads Data in JReport Designer
Create charts and reports based on Microsoft Ads data in JReport Designer.
-
Visualize RSS Feeds from Tableau
Use the Tableau Desktop business intelligence tool to connect to RSS feeds.
-
Use the CData Software ODBC Driver for SAS Data Sets in MicroStrategy Web
Connect to SAS Data Sets data in MicroStrategy Web using the CData Software ODBC Driver for SAS Data Sets.
-
Connect to Pingdom Data in Aqua Data Studio
Access Pingdom data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Theia IDE with Live Amazon S3 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 Amazon S3 data from within the development environment.
-
Connect to Missive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Missive and the SQL Gateway to access Missive data from Google Apps Script.
-
Connect to Parallel Data in RapidMiner
Integrate Parallel data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting GenSpark with AfterShip Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to AfterShip data without any replication or custom integration required.
-
Extract, Transform, and Load Discord Data in Informatica PowerCenter
Create a simple Workflow for Discord data in Informatica PowerCenter.
-
Connect to Basecamp Data in HULFT Integrate
Connect to Basecamp as a JDBC data source in HULFT Integrate
-
Build Apps with Live Brex Data Using the Low-Code Development Platform of Mendix
Connect Brex data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to OpenWeatherMap Data in DBeaver
Use the CData ODBC Driver to connect to OpenWeatherMap data in DBeaver.
-
Migrating data from Microsoft Teams to Google BigQuery using CData SSIS Components.
Easily push Microsoft Teams data to Google BigQuery using the CData SSIS Tasks for Microsoft Teams and Google BigQuery.
-
Query ClickTime Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ClickTime data from Node.js.
-
Automated Continuous Azure Data Catalog Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to MySQL.
-
Connect to PDFMonkey Data in JRuby
Create a simple JRuby app with access to live PDFMonkey data.
-
Creating FreshBooks-Connected Applications in Unqork
You can use CData Connect AI to feed FreshBooks data to Unqork and build custom business apps.
-
Connect to Live Tavily Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Tavily in CData Connect AI and connect to your Tavily data from PostgreSQL.
-
Automated Continuous Aweber Replication to MongoDB
Use CData Sync for automated, continuous, customizable Aweber replication to MongoDB.
-
Visualize SAP ByDesign 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 SAP ByDesign data into TIBCO Spotfire.
-
Visualize SendGrid Data in TIBCO Spotfire through OData
Integrate SendGrid data into dashboards in TIBCO Spotfire.
-
Automated Continuous Phoenix Replication to SQLite
Use CData Sync for automated, continuous, customizable Phoenix replication to SQLite.
-
Use Azure AI Foundry to Talk to Your GraphQL 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 GraphQL data for you.
-
Replicate Phoenix Data to Multiple Databases via the CData Sync CLI
Replicate Phoenix data to disparate databases with a single configuration.
-
Integrating Gumloop with SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Business Warehouse data within automated workflows.
-
Access Live Certinia Data in AWS Lambda
Connect to live Certinia data in AWS Lambda using the CData JDBC Driver.
-
Connecting Moonlit Workflow with ZohoInvoice 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 ZohoInvoice data in real time.
-
Create Data Visualizations in Cognos BI with Google Spanner Data
Access Google Spanner data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Cohere Data from PowerBuilder via ADO.NET
This article demonstrates how to access Cohere data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to MongoDB Data in NetBeans
Connect to MongoDB data in NetBeans with the data source configuration wizard.
-
Connect Dynamics 365 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dynamics 365 with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData ADO.NET Provider for Workday
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Workday.
-
DataBind Charts to JotForm Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to JotForm data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated GitLab Data Replication to Teradata
Use CData Sync to Customize and automate GitLab data replication to Teradata.
-
QuickBooks Time Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on QuickBooks Time facts in real time.
-
Link ConstantContact with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ConstantContact data in Filemaker Pro for Mac or Windows.
-
Connect to Dynamics NAV Data in Jaspersoft Studio
Execute SQL to remote Dynamics NAV data in Jaspersoft Studio.
-
Bind Live QuickBooks Time Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Time data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build AI/ML Models with Live Jira Assets Data using Dataiku
Connect Jira Assets Data with Dataiku using the CData JDBC Driver for Jira Assets.
-
Use the CData Software JDBC Driver for Mailgun in MicroStrategy Web
Connect to Mailgun data in MicroStrategy Web using the CData Software JDBC Driver for Mailgun.
-
Automate Oracle Service Cloud Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Service Cloud data replication to Couchbase.
-
Automate Sage 200 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage 200 data from PowerShell? This article demonstrates how to utilize the Sage 200 Cmdlets for tasks like connecting to Sage 200 data, automating operations, downloading data, and more.
-
Work with Live Google Contacts Data in Power Query
Use CData Connect AI to connect to Google Contacts data and work with live Google Contacts data in Microsoft Power Query.
-
Connect to Omnisend Data in Ruby
Connect to Omnisend data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Real-Time SAS xpt Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAS xpt and Dataflow to import and use SAS xpt data in Power Apps.
-
Integrate Cline with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Highrise data from within your IDE.
-
Integrate Trae with Live Freshservice Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Freshservice data from within the AI-powered IDE.