CData Software - Knowledge Base
Recent Articles
-
Automated Continuous WooCommerce Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable WooCommerce replication to Apache Kafka.
-
Connect to Microsoft Teams Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Teams.
-
Analyze Live DB2 Data in SAS Viya
Use CData Connect AI to connect to IBM DB2 from SAS Viya and deploy self-service analytics using live IBM DB2.
-
Access Humanity Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Humanity from your Oracle system.
-
Natively Connect to QuickBooks Online Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to QuickBooks Online. Leverage the native support for ODBC in PHP.
-
Visualize Anaplan 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 Anaplan into TIBCO Spotfire.
-
Connect to Real-Time Greenhouse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Greenhouse and Dataflow to import and use Greenhouse in Power Apps.
-
Import Dynamics 365 Data Using Azure Data Factory
Use CData Connect AI to connect to Dynamics 365 Data from Azure Data Factory and import live Microsoft Dynamics 365.
-
Create Oracle-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle Data from OutSystems and build custom enterprise apps using live Oracle Database.
-
How to Connect the Power BI Service to MYOB AccountRight: Complete Guide
Connect to the CData Software Power BI Connector for MYOB AccountRight from PowerBI.com to provide real-time MYOB AccountRight across the organization.
-
Automated Continuous SingleStore Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SingleStore replication to OneLake in Microsoft Fabric.
-
Build Pipelines with Live Neo4J Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Neo4J from Google Cloud Data Fusion, enabling the integration of live Neo4J into the building and management of effective data pipelines.
-
Connect to Webex Data in RazorSQL
Connect to Webex from wizards and query Webex from the GUI in the RazorSQL database management tool.
-
Integrate Gumroad with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Gumroad with External Services.
-
Integrate Live SAP Fieldglass Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Fieldglass to Blue Prism using the CData ODBC Driver for SAP Fieldglass to create automated workflows for repetitive business tasks.
-
Deploy the ADO.NET Provider for Wave Financial on an SSRS Report Server
Connect to Wave Financial 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.
-
Connect to Templated Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Templated to connect to Templated and execute queries in PowerBuilder.
-
Create Dynamic WordPress Grids Using the Infragistics XamDataGrid
Learn how you can connect WordPress to Infragistics XamDataGrid to build dynamic grids.
-
View Reports on Real-Time GraphQL Data in Power BI Report Server
Use the CData ODBC Driver for GraphQL to visualize GraphQL in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Sage 200 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sage 200 replication to IBM DB2.
-
How to Connect to Live SAP Ariba Procurement 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 SAP Ariba Procurement for you.
-
How to Connect to & Open Hacker News Data in Microsoft Excel
This article uses the CData ODBC driver for Hacker News to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Create Power BI Visual Reports with Real-Time Paylocity Data
Use CData Power BI Connectors to visualize Paylocity in Power BI.
-
Integrate Open WebUI with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live IBM Cloudant from within the chat interface.
-
Add MarkLogic Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MarkLogic with the Informatica Enterprise Data Catalog to classify and organize data.
-
Instagram Reporting in OBIEE with the Instagram JDBC Driver
Deploy the Instagram JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData ODBC Driver for Guru
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Guru.
-
Visualize Spotify Data in Sisense
Create an ElastiCube in Sisense app with access to Spotify.
-
Build AI/ML Models with Live LeadDesk Data using Dataiku
Connect LeadDesk Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Cursor CLI with Reckon 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.
-
Build IBM Cloud Object Storage-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for IBM Cloud Object Storage Data and create custom apps in Bubble.
-
Connect to Cohere Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cohere to connect to Cohere and execute queries in PowerBuilder.
-
Connect to Reply.io Data in Ruby
Connect to Reply.io in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Easily Integrate SAP Ariba Source Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Ariba Source in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Monday.com Data from PowerBuilder via ADO.NET
This article demonstrates how to access Monday.com from Appeon PowerBuilder using the CData ADO.NET Provider for Monday.com.
-
Create Datasets from Zoho Books in Domo Workbench and Build Visualizations of Zoho Books Data in Domo
Use the CData Software ODBC Driver for Zoho Books to create datasets from Zoho Books in Domo Workbench and then build visualizations in the Domo service.
-
Create Dynamic Okta Grids Using the Infragistics XamDataGrid
Learn how you can connect Okta to Infragistics XamDataGrid to build dynamic grids.
-
Create Google Cloud Storage-Connected Applications in Appsmith
Connect to Google Cloud Storage Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Cloud Storage.
-
Prepare, Blend, and Analyze Unbounce Data in Alteryx Designer (ODBC)
Build workflows to access live Unbounce for self-service data analytics.
-
Build Microsoft Entra ID-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Entra ID Data from Choreo and build custom apps using live Microsoft Entra ID.
-
Integrate with MailerLite Data in JReport Designer
Create charts and reports based on MailerLite in JReport Designer.
-
Automated Continuous Klaviyo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Klaviyo replication to SQL Server.
-
Manage Close Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Close.
-
Integrate Cursor with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon S3 from within the editor.
-
Connect to Azure Analysis Services Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Azure Analysis Services and the SQL Gateway to access Azure Analysis Services from Google Apps Script.
-
Analyze Paymo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Paymo from Power Pivot. You will use the Table Import Wizard to load Paymo. You can visually build the import query or use any SQL supported by the driver.
-
Connect to EmailOctopus Data from PowerBuilder via ADO.NET
This article demonstrates how to access EmailOctopus from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Apps with Live Elasticsearch in Adalo using CData Connect AI
Use CData Connect AI to integrate live Elasticsearch into the Adalo platform and build custom mobile and web applications with real-time Elasticsearch.
-
Building Dynamic Web Pages with Sage 200 Data Using AngularJS
Create single-page applications with live connectivity to Sage 200 using the CData API Server.
-
Migrating data from Azure Synapse to Snowflake using CData SSIS Components.
Easily push Azure Synapse to Snowflake using the CData SSIS Tasks for Azure Synapse and Snowflake.
-
Access Live Snapchat Ads Data in TIBCO Data Virtualization
Use the Snapchat Ads Tibco DV Adapter to create a Snapchat Ads data source in TIBCO Data Virtualization Studio and gain access to live Snapchat Ads from your TDV Server.
-
Connect to Discord Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Discord and work with Discord in your FileMaker application.
-
Automate Freshdesk Data Replication to SAP HANA
Use CData Sync to customize and automate Freshdesk replication to SAP HANA.
-
Integrating Kiro CLI with Databricks 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.
-
Build Typeform-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Typeform.
-
Analyze Microsoft Exchange Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Exchange from Power Pivot. You will use the Table Import Wizard to load Microsoft Exchange. You can visually build the import query or use any SQL supported by the driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Power BI XMLA
Create an ODBC connection to Power BI XMLA in Informatica and browse and transfer Power BI XMLA.
-
Automate QuickBooks Time Data Replication to Azure Synapse
Use CData Sync to customize and automate QuickBooks Time replication to Azure Synapse.
-
Build Charts with Microsoft Exchange Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Exchange in Clear Analytics.
-
Use the CData Software ODBC Driver for Workable in MicroStrategy Web
Connect to Workable in MicroStrategy Web using the CData Software ODBC Driver for Workable.
-
How to connect to Cassandra Data from IntelliJ
Integrate connectivity to Apache Cassandra with wizards in IntelliJ.
-
Import Odoo Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Odoo ERP. In this article, you will use the OData format to import Odoo ERP into Microsoft Power Query.
-
How to integrate Metabase with SQL Analysis Services Data
Use CData Connect AI to connect to live SQL Analysis Services and create an interactive dashboard in Metabase from SQL Analysis Services.
-
Automated Continuous Zoho Projects Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Azure SQL Database.
-
Model, Search, and Visualize Live Xero Data in ThoughtSpot
Use CData Connect AI to connect to live Xero Accounting for modeling, searching, and visualizing.
-
Visualize Presto Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Presto.
-
Connect to Pipeliner CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pipeliner CRM as an External Source in Dremio.
-
Prepare, Blend, and Analyze Google Search Results in Alteryx Designer (Connect AI)
Build workflows to access live Google Search for self-service data analytics.
-
Access Live Bitly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bitly in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build AI/ML Models with Live SAP Ariba Source Data using Dataiku
Connect SAP Ariba Source Data with Dataiku using the CData JDBC Driver for SAP Ariba Source.
-
Integrate Couchbase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Couchbase from Informatica Cloud.
-
Create Reports with Airtable Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Airtable.
-
Use the CData Software ODBC Driver for Oracle Eloqua Reporting in MicroStrategy Desktop
Connect to Oracle Eloqua Reporting in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle Eloqua Reporting.
-
Build Semantic Layer Views for IBM Informix Data in APOS Live Data Gateway
Use the CData Connector for IBM Informix in APOS Live Data Gateway to build Semantic Layer Views for IBM Informix.
-
How to connect and process Mode from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mode.
-
Connect to Google Directory Data in ACL Analytics
Connect to Google Directory via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Directory.
-
Add FormSite Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for FormSite with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Excel Add-In for Stripe
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Stripe.
-
Integrate Certinia Data in the Pentaho Report Designer
Publish reports based on Certinia in the Pentaho BI tool.
-
Design BIRT Reports on ChartMogul Data
Provide current ChartMogul to your embedded analytics.
-
Connect to Azure Synapse Data in CloverDX (formerly CloverETL)
Transfer Azure Synapse using the visual workflow in the CloverDX data integration tool.
-
How to connect to Jodoo Data in DBVisualizer
Integrate Jodoo with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Cassandra Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Cassandra from PowerShell? This article demonstrates how to utilize the Cassandra Cmdlets for tasks like connecting to Apache Cassandra, automating operations, downloading data, and more.
-
Connect to Dynamics 365 Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Dynamics 365 in DBeaver.
-
Build an OLAP Cube in SSAS from Teamwork Data
Establish a connection to Teamwork data from SQL Server Analysis Services, and use the Teamwork Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Facebook Data in Claris FileMaker Pro
Use the CData ODBC Driver for Facebook in FileMaker Pro to connect to Facebook and work with Facebook in your FileMaker applications.
-
Building Dynamic Web Pages with QuickBooks Online Data Using AngularJS
Create single-page applications with live connectivity to QuickBooks Online using the CData API Server.
-
Import MongoDB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access MongoDB. In this article, you will use the OData format to import MongoDB into Microsoft Power Query.
-
Integrating GitHub Copilot CLI with CapsuleCRM 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.
-
Using the CData Software ODBC Driver for Facebook in PyCharm
Connect to Facebook as an ODBC data source in PyCharm using the CData Software ODBC Driver for Facebook.
-
Automate Databricks Data Replication to SAP HANA
Use CData Sync to customize and automate Databricks replication to SAP HANA.
-
Access LionDesk Data from MySQL in Amazon QuickSight
Connect to LionDesk and build visualizations of LionDesk using a MySQL Connection in Amazon QuickSight.
-
How to connect to SAP Ariba Source Data with Squirrel SQL client
Connect to SAP Ariba Source and execute queries in the Squirrel SQL Client.
-
Build Dashboards with IBM Informix Data in Dundas BI
Create dynamic dashboards and perform analytics based on IBM Informix in Dundas BI.
-
Integrating Copper Data in Talend Cloud Data Management Platform
Connect Copper Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Work with Clockify Data in AWS Glue Jobs Using JDBC
Connect to Clockify from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to load Workday data into Elasticsearch via Logstash
Introducing a simple method to load Workday data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate Excel Online Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Excel Online to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData ADO.NET Provider for BigQuery
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for BigQuery.
-
Connect to Live Google Drive Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Drive in CData Connect AI and connect to your Google Drive from PostgreSQL.