CData Software - Knowledge Base
Recent Articles
-
Connect to Pipeliner CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Pipeliner CRM data from PowerBuilder using the Pipeliner CRM JDBC Driver.
-
Automated Continuous Zoho Books Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Books replication to IBM DB2.
-
Integrate YouTube Analytics Data into Power Automate Desktop using CData Connect
CData Connect for YouTube Analytics Data enables you to integrate YouTube Analytics data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Phoenix Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Phoenix data in Microsoft R Open.
-
Automated Continuous Recurly Replication to SQLite
Use CData Sync for automated, continuous, customizable Recurly replication to SQLite.
-
Work with Live CockroachDB Data in Power Query
Use CData Connect AI to connect to CockroachDB data and work with live CockroachDB data in Microsoft Power Query.
-
Access Airtable Data from MySQL in PHP
Connect to Airtable through the standard MySQL libraries in PHP.
-
Automate Outreach.io Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Outreach.io data from PowerShell? This article demonstrates how to utilize the Outreach.io Cmdlets for tasks like connecting to Outreach.io data, automating operations, downloading data, and more.
-
How to Connect to Live Cassandra Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Cassandra data securely in real time.
-
DataBind Zoho Books Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zoho Books with the DevExpress Windows Forms and Web controls to provide Zoho Books data to a chart.
-
Deploy the ADO.NET Provider for Close on an SSRS Report Server
Connect to Close data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Work with Live Omnisend Data in Power Query
Use CData Connect AI to connect to Omnisend data and work with live Omnisend data in Microsoft Power Query.
-
How to connect to Instantly Data in DBVisualizer
Integrate Instantly data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build a Singer.io Tap for Parquet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Parquet data using the CData Python Connector.
-
Build an OLAP Cube in SSAS from Elasticsearch Data
Establish a connection to Elasticsearch data data from SQL Server Analysis Services, and use the Elasticsearch Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate AdRoll Integration Tasks from PowerShell
Are you in search of a quick and easy way to access AdRoll data from PowerShell? This article demonstrates how to utilize the AdRoll Cmdlets for tasks like connecting to AdRoll data, automating operations, downloading data, and more.
-
Create Reports with Factorial Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Factorial data.
-
How to update Google Drive from Excel
This article explains how to transfer data from Excel to Google Drive using the Excel Add-In for Google Drive.
-
Automated Continuous Vertica Replication to Databricks
Use CData Sync for automated, continuous, customizable Vertica replication to Databricks.
-
Automated Continuous Customer.io Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Customer.io replication to Google Cloud SQL.
-
Connect to NASA Data in RazorSQL
Connect to NASA from wizards and query NASA data from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Amazon Marketplace in MicroStrategy Web
Connect to Amazon Marketplace data in MicroStrategy Web using the CData Software ODBC Driver for Amazon Marketplace.
-
Build Automated Workflows with Live Act CRM Data in Workato
Use CData Connect AI to connect to live Act CRM data and build automated workflows in Workato.
-
Integrate with LaunchDarkly Data in JReport Designer
Create charts and reports based on LaunchDarkly data in JReport Designer.
-
Use Biml to Build SSIS Tasks to Replicate CSV Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CSV data to SQL Server.
-
Integrate OpenCode with Live OneNote Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live OneNote data from within your AI coding agent.
-
Visualize DB2 Data in TIBCO Spotfire through OData
Integrate DB2 data into dashboards in TIBCO Spotfire.
-
Import Figshare Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Figshare Data and provide access to live Figshare data for custom reports in the Power BI Service.
-
Import and Visualize Greenhouse Data in Power View
Create data visualizations based on Greenhouse data in Excel.
-
Connect to Facebook Data in HULFT Integrate
Connect to Facebook as a JDBC data source in HULFT Integrate
-
Replicate FHIR Data from PowerShell
Write a quick PowerShell script to query FHIR data. Use connectivity to the live data to replicate FHIR data to SQL Server.
-
Connect to Anaplan Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Anaplan Data and connect to Anaplan data in Akorbi Digital RunMyProcess.
-
Integrate Google's Vertex AI Agent with Live Wistia 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 Wistia data within intelligent workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Zendesk
Create an ODBC connection to Zendesk in Informatica and browse and transfer Zendesk data.
-
How to connect Amazon QuickSight to Figshare Data
Create a connection to Figshare data in CData Connect AI and insert Figshare data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Coda Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Coda to connect to Coda data and execute queries in PowerBuilder.
-
Integrate Goose with Live AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live AgileCRM data from within the local AI agent.
-
How to Connect to Live Kintone Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Kintone data securely in real time.
-
Build Cassandra-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cassandra Data and create custom apps in Mendix.
-
Create Amazon Athena-Connected Applications in Appsmith
Connect to Amazon Athena Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon Athena data.
-
Build MYOB AccountRight-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MYOB AccountRight Data and create custom apps in Bubble.
-
Connect to Neo4J Data in Google Apps Script via Connect AI
Use CData Connect AI to access Neo4J data in Google Apps Script.
-
Query Avaza Data as a MySQL Database in Node.js
Execute MySQL queries against Avaza data from Node.js.
-
Visualize Shippo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Shippo data.
-
Bidirectional Access to Xero Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Xero data in Filemaker Pro for Mac or Windows.
-
Connecting Pipedream with Phoenix 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 Phoenix data in real time.
-
Build Outreach.io-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 Outreach.io data without replication.
-
Use the CData Software JDBC Driver for CockroachDB in MicroStrategy Web
Connect to CockroachDB data in MicroStrategy Web using the CData Software JDBC Driver for CockroachDB.
-
How to connect to Amazon DynamoDB Data with Squirrel SQL client
Connect to Amazon DynamoDB data and execute queries in the Squirrel SQL Client.
-
Connect to Azure DevOps Data in DBArtisan
Use wizards in DBArtisan to configure Azure DevOps data as a data source.
-
How to Build an ETL App for Vercel Data in Python with CData
Create ETL applications and real-time data pipelines for Vercel data in Python with petl.
-
ETL OnePageCrm in Oracle Data Integrator
This article shows how to transfer OnePageCrm data into a data warehouse using Oracle Data Integrator.
-
How to publish and share Acumatica Data dashboards with Tableau Server
The CData ODBC driver for Acumatica enables you integrate Acumatica data into Tableau dashboards.
-
Replicate Dynamics 365 Data in Heroku for Use in Salesforce Connect
Replicate Dynamics 365 data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
ETL HCL Domino in Oracle Data Integrator
This article shows how to transfer HCL Domino data into a data warehouse using Oracle Data Integrator.
-
Build an OLAP Cube in SSAS from Testmonitor Data
Establish a connection to Testmonitor data data from SQL Server Analysis Services, and use the Testmonitor Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live SAP ByDesign Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP ByDesign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP ByDesign data.
-
Analyze Tally Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Tally data and visualize Tally data in SAP Analytics Cloud.
-
Trigger Outreach.io IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Outreach.io with standard wizards in Logic Apps.
-
Getting Started with the CData ADO.NET Provider for Pushbullet
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Object-Relational Mapping (ORM) with Avaza 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 Avaza data into a Java-based ORM framework, Hibernate.
-
Connect to Shortcut Data in Google Apps Script via Connect AI
Use CData Connect AI to access Shortcut data in Google Apps Script.
-
How to Query Avro Data in MySQL Workbench
Execute MySQL queries against live Avro data from MySQL Workbench.
-
Automated Continuous Couchbase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Couchbase replication to Amazon S3.
-
Use the CData Software ODBC Driver for ClickUp in SAS for Real-Time Reporting and Analytics
Connect to real-time ClickUp data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ClickUp.
-
Automate Azure Synapse Data Replication to SAP HANA
Use CData Sync to customize and automate Azure Synapse data replication to SAP HANA.
-
How to Use a Microsoft Access Database to Update Splunk Data in Real Time
Update Splunk data by creating a linked table in Microsoft Access with the CData Splunk ODBC Driver.
-
Use Grok to Talk to Your Attio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Attio data for you.
-
Create Freshservice-Connected Applications in Appsmith
Connect to Freshservice Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshservice data.
-
Visualize Oracle HCM Cloud Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle HCM Cloud data.
-
Automated Continuous BigCommerce Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable BigCommerce data replication to OneLake in Microsoft Fabric.
-
Connect to FTP from a Connection Pool in WebLogic
Use the CData JDBC Driver for FTP to connect to FTP data from Web applications running on WebLogic.
-
How to Connect DBeaver to ZohoInvoice via a JDBC Driver
Manage ZohoInvoice data with visual tools in DBeaver like the query browser.
-
Working with SAP Business One Data in LINQPad
Execute LINQ queries to SAP Business One data in LINQPad.
-
Automated Continuous Amazon Athena Replication to SQL Server
Use CData Sync for automated, continuous, customizable Amazon Athena replication to SQL Server.
-
Establish a Live Connection with Hugging Face Data using Tableau Bridge
The CData ODBC Driver for Hugging Face enables you to integrate live Hugging Face data into Tableau Cloud dashboards using the Tableau Bridge.
-
Query GitLab Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GitLab data from Node.js.
-
Use the CData ODBC Driver for Shortcut in Microsoft Power Query
You can use the CData Shortcut ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Shortcut data into Microsoft Power Query.
-
Access Live CapsuleCRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CapsuleCRM data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Replicate Multiple MailerLite Accounts via the CData Sync CLI
Replicate multiple MailerLite accounts to one or many databases.
-
Automate Klaviyo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Klaviyo data replication to Azure Data Lake.
-
Connect to Bitly Data from a Connection Pool in JBoss
Integrate Bitly data into Java servlets: Use the Management Console in JBoss to install the Bitly JDBC Driver.
-
Integrate Reckon Accounts Hosted Data into Power Automate Desktop using CData Connect
CData Connect for Reckon Accounts Hosted Data enables you to integrate Reckon Accounts Hosted data into workflows built using Microsoft Power Automate Desktop.
-
Design BIRT Reports on Adobe Commerce Data
Provide current Adobe Commerce data to your embedded analytics.
-
Import Real-Time Facebook Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Facebook data in ColdFusion.
-
Excel Spreadsheet Automation on Raisers Edge NXT Data with the QUERY Formula
Pull data from Raisers Edge NXT, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Parallel Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Parallel replication to PostgreSQL.
-
Connect to Klipfolio Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Klipfolio data.
-
Design BIRT Reports on Freshservice Data
Provide current Freshservice data to your embedded analytics.
-
Query Oracle Financials Cloud Data in DataGrip
Create a Data Source for Oracle Financials Cloud in DataGrip and use SQL to query live Oracle Financials Cloud data.
-
Feed Telegram Data into FineReport
How to set Telegram data as a JDBC data source in FineReport.
-
Automated Continuous SharePoint Excel Services Replication to Databricks
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Databricks.
-
Build an OLAP Cube in SSAS from SAP Business One Data
Establish a connection to SAP Business One data data from SQL Server Analysis Services, and use the SAP Business One Data Provider to build OLAP cubes for use in analytics and reporting.
-
Model, Search, and Visualize Live WooCommerce Data in ThoughtSpot
Use CData Connect AI to connect to live WooCommerce data for modeling, searching, and visualizing.
-
Replicate Multiple Hive Accounts via the CData Sync CLI
Replicate multiple Hive accounts to one or many databases.
-
Link ShipEngine with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ShipEngine data in Filemaker Pro for Mac or Windows.
-
Visualize Superchat Data in Tableau
The CData ODBC driver for Superchat enables you integrate Superchat data into Tableau dashboards.
-
Automated Continuous Instantly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Instantly replication to Amazon S3.
-
Automated Continuous Sage Intacct Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Apache Kafka.
-
Model, Search, and Visualize Live Gmail Data in ThoughtSpot
Use CData Connect AI to connect to live Gmail data for modeling, searching, and visualizing.