CData Software - Knowledge Base
Recent Articles
-
How to Create Power BI Visual Reports with Real-Time Excel
Use CData Power BI Connectors to visualize Microsoft Excel in Power BI.
-
Connect to Azure Data Lake Storage in ACL Analytics
Connect to Azure Data Lake Storage via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure Data Lake Storage.
-
Connect to and Query Marketo in QlikView over ODBC
Create data visualizations with Marketo in QlikView.
-
How to Seamlessly Import Oracle Sales Data into IBM SPSS Modeler
Integrate Oracle Sales data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Easily Integrate GraphQL in Lazarus Pascal IDE
Learn how to easily integrate live GraphQL in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Act-On Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Act-On replication to PostgreSQL.
-
Connect to MariaDB from HeidiSQL
Use CData Connect AI to connect to and query live MariaDB from HeidiSQL.
-
Build an OLAP Cube in SSAS from Highrise
Establish a connection to Highrise CRM data from SQL Server Analysis Services, and use the Highrise Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Semantic Layer Views for Act CRM in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Act CRM.
-
Integrate Microsoft Dataverse in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dataverse (CDS) from Informatica Cloud.
-
Access LinkedIn 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 LinkedIn.
-
Automated Continuous Google Ad Manager Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Oracle.
-
Using the CData Software ODBC Driver for SQL Analysis Services in PyCharm
Connect to SQL Analysis Services as an ODBC data source in PyCharm using the CData Software ODBC Driver for SQL Analysis Services.
-
Automated Continuous MySQL Replication to SQLite
Use CData Sync for automated, continuous, customizable MySQL replication to SQLite.
-
Create SSAS Tabular Models from Cosmos DB
How to build a SQL Server Analysis Service Tabular Model from Azure Cosmos DB using CData drivers.
-
Enable the SFTP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SFTP.
-
Build Automated Workflows with Live Lakebase in Workato
Use CData Connect AI to connect to live Lakebase and build automated workflows in Workato.
-
Working with Oracle Eloqua in LINQPad
Execute LINQ queries to Oracle Eloqua in LINQPad.
-
Connect to Trello in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Trello in Airbyte.
-
Process & Analyze Shopify in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Shopify .
-
Natively Connect to Greenhouse in PHP
The CData ODBC driver for Greenhouse enables you to create PHP applications with connectivity to Greenhouse. Leverage the native support for ODBC in PHP.
-
How to Query Presto in MySQL Workbench
Execute MySQL queries against live Presto from MySQL Workbench.
-
How to Connect DBeaver to Google Search via a JDBC Driver
Manage Google Search with visual tools in DBeaver like the query browser.
-
Load Azure DevOps to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure DevOps to a database.
-
Connect to Live QuickBooks Time in MicroStrategy through CData Connect AI
Create a live connection to QuickBooks Time in CData Connect AI and connect to your QuickBooks Time from MicroStrategy.
-
How to connect Amazon QuickSight to MySQL
Create a connection to MySQL in CData Connect AI and insert MySQL into Amazon QuickSight SPICE to build interactive dashboards.
-
Twilio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Twilio facts in real time.
-
Analyze Airtable in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Airtable in Microsoft R Open.
-
Create Dashboards and Visualize Live Odoo in Geckoboard
Use CData Connect AI to connect to live Odoo ERP and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating LangChain with Adobe Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Adobe Analytics within automated workflows.
-
Replicate Sage Cloud Accounting to Multiple Databases via the CData Sync CLI
Replicate Sage Business Cloud Accounting to disparate databases with a single configuration.
-
Getting Started with the CData SSIS Components for Asana
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Asana.
-
How to integrate Metabase with Smartsheet
Use CData Connect AI to connect to live Smartsheet and create an interactive dashboard in Metabase from Smartsheet.
-
Access Live Microsoft Planner in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Planner in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect Flowise AI Agents to Live Oracle Sales via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Build Visualizations of Aha! in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aha! in Birst.
-
Use Microsoft Copilot Studio to talk to your Square via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Square for you.
-
Create SSAS Tabular Models from Amazon S3
How to build a SQL Server Analysis Service Tabular Model from Amazon S3 using CData drivers.
-
Create SingleStore-Connected Applications in Appsmith
Connect to SingleStore via CData Connect AI in Appsmith and create custom business applications with real-time access to SingleStore.
-
Working with Trello in LINQPad
Execute LINQ queries to Trello in LINQPad.
-
How to connect and process Box from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Box.
-
Access Amazon Marketplace from MySQL in PHP
Connect to Amazon Marketplace through the standard MySQL libraries in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAS Data Sets
Provide connectivity to SAS Data Sets through an SAP BusinessObjects universe.
-
Automated Continuous Oracle HCM Cloud Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to AlloyDB.
-
Publish Crystal Reports on Salesforce Pardot
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce Pardot.
-
Consume BigCommerce OData Feeds in PowerBuilder
This article demonstrates how to consume BigCommerce as OData feeds from PowerBuilder using the API Server.
-
Design BIRT Reports on TigerGraph
Provide current TigerGraph to your embedded analytics.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SFTP to Power BI dashboards. Simply drag and drop SFTP into data visuals on the Power BI canvas.
-
How to Seamlessly Import XML Data into IBM SPSS Modeler
Integrate XML data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Xero in Jaspersoft Studio
Execute SQL to remote Xero Accounting in Jaspersoft Studio.
-
Connect to MailChimp in RazorSQL
Connect to MailChimp from wizards and query MailChimp from the GUI in the RazorSQL database management tool.
-
Import Monday.com Using Azure Data Factory
Use CData Connect AI to connect to Monday.com from Azure Data Factory and import live Monday.com.
-
How to Query Azure Table in MySQL Workbench
Execute MySQL queries against live Azure Table Storage from MySQL Workbench.
-
Connect to Tableau CRM Analytics in RapidMiner
Integrate Tableau CRM Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Sheets within intelligent workflows.
-
Build Google Contacts-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Contacts and create custom apps in Bubble.
-
Prepare, Blend, and Analyze SAP Concur in Alteryx Designer (Connect AI)
Build workflows to access live SAP Concur for self-service data analytics.
-
Analyze PostgreSQL in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PostgreSQL in Microsoft R Open.
-
DataBind Charts to Bitbucket
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bitbucket 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.
-
How to Work with Salesforce Marketing in AWS Glue Jobs Using JDBC
Connect to Salesforce Marketing from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize MailChimp in Sisense
Create an ElastiCube in Sisense app with access to MailChimp.
-
Use the CData Software ODBC Driver for MarkLogic in MicroStrategy Web
Connect to MarkLogic in MicroStrategy Web using the CData Software ODBC Driver for MarkLogic.
-
Create Kintone-Connected Business Apps in AppSheet
Connect to Kintone via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Kintone.
-
Integrate LinkedIn with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LinkedIn with External Services.
-
Visualize Greenplum in TIBCO Spotfire through OData
Integrate Pivotal GreenPlum into dashboards in TIBCO Spotfire.
-
How to Build an ETL App for QuickBooks Online in Python with CData
Create ETL applications and real-time data pipelines for QuickBooks Online in Python with petl.
-
How to Import Data from Google Contacts into Google Sheets
Import Google Contacts into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData Power BI Connector for Klipfolio
-