CData Software - Knowledge Base
Recent Articles
-
Replicate Autopilot Data to Multiple Databases
Replicate Autopilot to disparate databases with a point-and-click configuration.
-
Connect to Contentful Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Contentful using standard SQL.
-
Create Google Search-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Search Results from Klipfolio and build custom visualizations using live Google Search.
-
Using the CData Software ODBC Driver for PagerDuty in PyCharm
Connect to PagerDuty as an ODBC data source in PyCharm using the CData Software ODBC Driver for PagerDuty.
-
How to create Ontraport federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Ontraport in MySQL .
-
Prepare, Blend, and Analyze Sage 200 Data in Alteryx Designer (Connect AI)
Build workflows to access live Sage 200 for self-service data analytics.
-
Automated Continuous Impala Replication to Snowflake
Use CData Sync for automated, continuous, customizable Impala replication to Snowflake.
-
Access SQL Analysis Services 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 SQL Analysis Services.
-
Connect to SurveyMonkey Data in Ruby
Connect to SurveyMonkey in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Working with Klaviyo Data in LINQPad
Execute LINQ queries to Klaviyo in LINQPad.
-
Visualize PagerDuty Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PagerDuty.
-
Object-Relational Mapping (ORM) with AdRoll 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 AdRoll into a Java-based ORM framework, Hibernate.
-
Migrating data from MailChimp to Snowflake using CData SSIS Components.
Easily push MailChimp to Snowflake using the CData SSIS Tasks for MailChimp and Snowflake.
-
How to create an RPA flow for Neo4J Data in UiPath Studio
Use the Neo4J ODBC Driver to create workflows that access real-time Neo4J without any coding.
-
Integrate Bright Data Data in the Pentaho Report Designer
Publish reports based on Bright Data in the Pentaho BI tool.
-
Integrate VWO Data in Pentaho Data Integration
Build ETL pipelines based on VWO in the Pentaho Data Integration tool.
-
Tavily Reporting in OBIEE with the Tavily JDBC Driver
Deploy the Tavily JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import and Visualize Monday.com Data in Power View
Create data visualizations based on Monday.com in Excel.
-
Connect to HelloSign Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HelloSign and the SQL Gateway to access HelloSign from Google Apps Script.
-
Getting Started with the CData SSIS Components for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Adobe Experience Manager.
-
Analyze Highrise Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Highrise CRM and visualize live Highrise CRM in Infragistics Reveal.
-
How to create Visio diagrams from XML Data
Automatically update XML Files with the changes you make to Visio master shapes.
-
Build a PostgreSQL Interface for EnterpriseDB Data using the CData JDBC Driver
Use the Remoting features of the EnterpriseDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To a JDBC Data Source for Exact Online
Create Exact Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Python Connector for Pipeline CRM
Learn to install and license the CData Python Connector
-
Build Greenplum Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Pivotal GreenPlum and build visualizations in Tableau.
-
Integrate Toggl with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Toggl with External Services.
-
Query Nuclia Data in ColdFusion
Write standard ColdFusion data access code to connect to Nuclia.
-
Visualize Zoom Data in Sisense
Create an ElastiCube in Sisense app with access to Zoom.
-
Integrating Antigravity CLI with Simplesat via CData CLI
Connect Simplesat to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to QuickBooks Online Data in CloverDX (formerly CloverETL)
Transfer QuickBooks Online using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Close Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Close. Leverage the pyodbc module for ODBC in Python.
-
How to Visualize ZohoInvoice Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoInvoice in Python.
-
Import Stripe Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Stripe Data and provide access to live Stripe for custom reports in the Power BI Service.
-
How to Create Power BI Visual Reports with Real-Time SurveyMonkey Data
Use CData Power BI Connectors to visualize SurveyMonkey in Power BI.
-
Connecting Pipedream with Oracle Sales Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Oracle Sales data in real time.
-
Getting Started with the CData Tableau Connector for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sage Intacct.
-
Connect to Avalara AvaTax Data in RazorSQL
Connect to Avalara AvaTax from wizards and query Avalara AvaTax from the GUI in the RazorSQL database management tool.
-
Load Oracle Eloqua Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Eloqua to a database.
-
Bridge Trello Connectivity with Apache NiFi
Access and process Trello in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Trello Replication to SQL Server
Use CData Sync for automated, continuous, customizable Trello replication to SQL Server.
-
Connect to Google Cloud Storage Data in DBArtisan
Use wizards in DBArtisan to configure Google Cloud Storage as a data source.
-
Use the CData Software ODBC Driver for Recurly in MicroStrategy Web
Connect to Recurly in MicroStrategy Web using the CData Software ODBC Driver for Recurly.
-
How to use SQLAlchemy ORM to access Freshservice Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Freshservice.
-
Integrate Live Hive Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Hive from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apache Hive.
-
Replicate Smartsheet Data in Heroku for Use in Salesforce Connect
Replicate Smartsheet to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData JDBC Driver for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for EmailOctopus.
-
How to import Teamgate Data into Apache Solr
Use the CData Software JDBC Driver for Teamgate in Data Import Handler and create an automated import of Teamgate to Apache Solr Enterprise Search platform.
-
How to create Visio diagrams from SharePoint Excel Services Data
Automatically update SharePoint Excel Services with the changes you make to Visio master shapes.
-
Model, Search, and Visualize Live Asana Data in ThoughtSpot
Use CData Connect AI to connect to live Asana for modeling, searching, and visualizing.
-
Work with Live Procore Data in Power Query
Use CData Connect AI to connect to Procore and work with live Procore in Microsoft Power Query.
-
How to Easily Query PingOne Data in OpenOffice Base
Connect to PingOne data in OpenOffice Base using the CData ODBC Driver for PingOne and generate reports with live data insights.
-
A PostgreSQL Interface for PolarTeamPro Data (MySQL Remoting via JDBC)
Use the Remoting features of the PolarTeamPro JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Quaderno Replication to Oracle
Use CData Sync for automated, continuous, customizable Quaderno replication to Oracle.
-
Natively Connect to WordPress Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to WordPress. Leverage the native support for ODBC in PHP.
-
Automate DB2 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access IBM DB2 from PowerShell? This article demonstrates how to utilize the DB2 Cmdlets for tasks like connecting to IBM DB2, automating operations, downloading data, and more.
-
Create SAP Ariba Procurement-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Ariba Procurement Data from Klipfolio and build custom visualizations using live SAP Ariba Procurement.
-
Connect Outreach.io Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Outreach.io using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Establish a Live Connection with ZohoSubscriptions Data using Tableau Bridge
The CData ODBC Driver for ZohoSubscriptions enables you to integrate live ZohoSubscriptions into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Semantic Layer Views for Sybase Data in APOS Live Data Gateway
Use the CData Connector for Sybase in APOS Live Data Gateway to build Semantic Layer Views for Sybase.
-
Automated Continuous Typeform Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Typeform replication to PostgreSQL.
-
Back Up Perigon 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 Perigon data.
-
Integrating Codex CLI with Klipfolio 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.
-
Working with SAP SuccessFactors Data in LINQPad
Execute LINQ queries to SAP SuccessFactors in LINQPad.
-
How to Connect to & Open Reckon Data in Microsoft Excel
This article uses the CData ODBC driver for Reckon to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Discord Replication to MySQL
Use CData Sync for automated, continuous, customizable Discord replication to MySQL.
-
Create Google Campaign Manager 360-Connected Applications in Appsmith
Connect to Google Campaign Manager 360 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Campaign Manager 360.
-
Create Power BI Reports on Real-Time Raisers Edge NXT Data
Use the CData ODBC Driver for Raisers Edge NXT to visualize Raisers Edge NXT in Power BI Desktop.
-
Automated Continuous Amazon S3 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon S3 replication to IBM DB2.
-
How to Access Live Samanage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Samanage enables you to integrate Samanage into workflows built using Microsoft Power Automate Desktop.
-
Configure the CData JDBC Driver for SQL Analysis Services in a Connection Pool in Tomcat
Connect to SQL Analysis Services from a connection pool in Tomcat.
-
How to connect to OpenWeatherMap Data from IntelliJ
Integrate connectivity to OpenWeatherMap with wizards in IntelliJ.
-
How to Access Live Blackbaud FE NXT Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Blackbaud FE NXT enables you to integrate Blackbaud FE NXT into workflows built using Microsoft Power Automate Desktop.
-
Connect to Telegram in SpagoBI
Create reports featuring live Telegram in SpagoBI Studio. Host Telegram reports on SpagoBI Server.
-
Visualize ZarMoney Data in Tableau
The CData ODBC driver for ZarMoney enables you integrate ZarMoney into Tableau dashboards.
-
Build Slack-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Slack and build web apps with connectivity to live Slack.
-
Integrate SAP Ariba Procurement Data in the Pentaho Report Designer
Publish reports based on SAP Ariba Procurement in the Pentaho BI tool.
-
How to Visualize Highrise Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Highrise CRM in Python.
-
Build Dashboards with Snapchat Ads Data in Dundas BI
Create dynamic dashboards and perform analytics based on Snapchat Ads in Dundas BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PivotalTracker
Provide connectivity to PivotalTracker through an SAP BusinessObjects universe.
-
Query HBase Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache HBase.
-
Create Informatica Mappings From/To an ODBC Data Source for Supabase
Create an ODBC connection to Supabase in Informatica and browse and transfer Supabase.
-
How to connect to Elasticsearch Data with Squirrel SQL client
Connect to Elasticsearch and execute queries in the Squirrel SQL Client.
-
Establish a Live Connection with SAP Hybris C4C Data using Tableau Bridge
The CData ODBC Driver for SAP Hybris C4C enables you to integrate live SAP Hybris C4C into Tableau Cloud dashboards using the Tableau Bridge.
-
Klaviyo Reporting in OBIEE with the Klaviyo JDBC Driver
Deploy the Klaviyo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Work with CockroachDB Data in AWS Glue Jobs Using JDBC
Connect to CockroachDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Onfleet Data in Tableau
The CData ODBC driver for Onfleet enables you integrate Onfleet into Tableau dashboards.
-
Integrating LangChain with MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MySQL within automated workflows.
-
Automated Continuous Tanda Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Tanda replication to Google BigQuery.
-
Automated Clockify Data Replication to Teradata
Use CData Sync to Customize and automate Clockify replication to Teradata.
-
Create Data Visualizations Based On WooCommerce Data in Mode
Use CData Connect AI to connect to WooCommerce Data from Mode and build visualizations using live
-
Integrate with Live Pipedrive Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Pipedrive from the MuleSoft Anypoint Platform to integrate live Pipedrive into custom reports and dashboards.
-
Visualize Simplesat Data in Tableau
The CData ODBC driver for Simplesat enables you integrate Simplesat into Tableau dashboards.
-
How to Query Live Drift Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Drift data in natural language using Python.
-
Visualize Google Cloud Storage Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Cloud Storage.
-
Migrating data from Guru to Databricks using CData SSIS Components.
Easily push Guru to Databricks using the CData SSIS Tasks for Guru and Databricks.
-
Visualize Short.io 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 Short.io into TIBCO Spotfire.
-
Connect and Query Live Zoho Creator Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoho Creator into Databricks
-
How to Access Live HubSpot Data in Visual Studio Code via Cline
Run CData MCP Server for HubSpot on Windows Subsytem for Linux (WSL) and connect to live HubSpot from the Cline extension in Visual Studio Code.
-
Integrate LibreChat with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Adobe Analytics from within the chat interface.