CData Software - Knowledge Base
Recent Articles
-
Import GraphQL Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to GraphQL Data and provide access to live GraphQL for custom reports in the Power BI Service.
-
How to Query Live Freshdesk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshdesk data in natural language using Python.
-
How to Connect to Live Zendesk Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Zendesk for you.
-
Perform Batch Operations with Active Directory Data in Apache NiFi
Connect to Active Directory and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Anaplan Data in JRuby
Create a simple JRuby app with access to live Anaplan.
-
How to Connect to & Open Vault CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Vault CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData ODBC Driver for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LightSpeedRetail.
-
Query, Visualize, and Share live Twitter Ads Data in Redash
Use CData Connect AI to connect to live Twitter Ads in Redash for querying, visualizing, and sharing.
-
Bridge SAP Business One Connectivity with Apache NiFi
Access and process SAP Business One in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Cloudflare Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cloudflare replication to SingleStore.
-
How to connect to Contentful Data from IntelliJ
Integrate connectivity to Contentful with wizards in IntelliJ.
-
Use the CData Software JDBC Driver for Okta in MicroStrategy Web
Connect to Okta in MicroStrategy Web using the CData Software JDBC Driver for Okta.
-
Automated Continuous Trello Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Trello replication to PostgreSQL.
-
LINQ to Discourse Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Discourse Data Provider.
-
Automated Continuous Salesforce Pardot Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Vertica.
-
Automate Clio Data Replication to SAP HANA
Use CData Sync to customize and automate Clio replication to SAP HANA.
-
How to Connect to Live SAS xpt Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAS XPORT for you.
-
Connecting Moonlit Workflow with Trello 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 Trello in real time.
-
How to connect and process Todoist from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Todoist.
-
Automated Continuous Accelo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Accelo replication to MongoDB.
-
Work with EmailOctopus Data in FoxPro
Load EmailOctopus into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Rebilly Data in JReport Designer
Create charts and reports based on Rebilly in JReport Designer.
-
Build DocuSign Visualizations in Tableau Desktop
Use CData Connect AI to connect to live DocuSign and build visualizations in Tableau.
-
How to Seamlessly Import Superchat Data into IBM SPSS Modeler
Integrate Superchat data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Amazon Marketplace Data in Coginiti Pro
Connect to and query live Amazon Marketplace from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Query LDAP Objects in MySQL Workbench
Execute MySQL queries against live LDAP from MySQL Workbench.
-
Creating LinkedIn Ads-Connected Applications in Unqork
You can use CData Connect AI to feed LinkedIn Ads to Unqork and build custom business apps.
-
Build MVC Applications with Connectivity to Dropbox Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dropbox from an ASP.NET MVC application.
-
How to Connect DBeaver to Google Ad Manager via a JDBC Driver
Manage Google Ad Manager with visual tools in DBeaver like the query browser.
-
Provide OData Services of Klipfolio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Klipfolio by developing a WCF Service Application.
-
How to connect Amazon QuickSight to Shopify Data
Create a connection to Shopify in CData Connect AI and insert Shopify into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Goose with Live QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live QuickBooks Online from within the local AI agent.
-
Create Data Visualizations in Cognos BI with Sugar CRM Data
Access Sugar CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Choosing the Best Method to Connect SAP BusinessObjects BI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP BusinessObjects BI from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Impala with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Impala with External Services.
-
Create Power BI Reports on Real-Time BigCommerce Data
Use the CData ODBC Driver for BigCommerce to visualize BigCommerce in Power BI Desktop.
-
Integrate Theia IDE with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Design BIRT Reports on Google Translate Data
Provide current Google Translate to your embedded analytics.
-
Use the CData Software ODBC Driver for SAP in MicroStrategy Desktop
Connect to SAP ERP/NetWeaver in MicroStrategy Desktop using the CData Software ODBC Driver for SAP.
-
Migrating data from Gorgias to Snowflake using CData SSIS Components.
Easily push Gorgias to Snowflake using the CData SSIS Tasks for Gorgias and Snowflake.
-
Create Data Visualizations in Cognos BI with Recurly Data
Access Recurly as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind QuickBooks Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for QuickBooks with the DevExpress Windows Forms and Web controls to provide QuickBooks Desktop to a chart.
-
Access Live Box Data in Excel 365 Online (Excel for the web)
Connect to Box from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connecting Pipedream with Microsoft Entra ID 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 Microsoft Entra ID data in real time.
-
Grafana Reporting in OBIEE with the Grafana JDBC Driver
Deploy the Grafana JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Manage Zoho Books Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Books.
-
Access Live SQL Analysis Services Data in TIBCO Data Virtualization
Use the SQL Analysis Services Tibco DV Adapter to create a SQL Analysis Services data source in TIBCO Data Virtualization Studio and gain access to live SQL Analysis Services from your TDV Server.
-
Analyze Teamwork Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Teamwork from Power Pivot. You will use the Table Import Wizard to load Teamwork. You can visually build the import query or use any SQL supported by the driver.
-
Use Dash to Build Web Apps on Avalara AvaTax Data via CData Connect AI
Build interactive Dash web apps on live Avalara AvaTax using pandas and the CData Connect AI Python SDK.
-
Use Agno to Talk to Your Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Vertica for you.
-
Moving Data from DB2 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live DB2 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query LinkedIn Data as a MySQL Database in Node.js
Execute MySQL queries against LinkedIn from Node.js.
-
Connect to Vault CRM Data from AWS Glue
Use CData Connect AI to gain access to live Veeva Vault & Vault CRM from your AWS Glue jobs.
-
How to Build an ETL App for SAP Ariba Source Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Ariba Source in Python with petl and the CData Connect AI Python SDK.
-
Connect to SAP Concur Data in JRuby
Create a simple JRuby app with access to live SAP Concur.
-
Connect to Zendesk 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 Zendesk.
-
Query Act CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Act CRM.
-
Deploy the ADO.NET Provider for Optimizely on an SSRS Report Server
Connect to Optimizely 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.
-
Automate SharePoint Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft SharePoint replication to Couchbase.
-
How to use SQLAlchemy ORM to access iContact Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of iContact.
-
Build PostgreSQL-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live PostgreSQL.
-
Connect to AlloyDB Data from a Connection Pool in Jetty
The AlloyDB JDBC Driver supports connection pooling: This article shows how to connect faster to Google AlloyDB from Web apps in Jetty.
-
Configure the CData JDBC Driver for Dotmailer in a Connection Pool in Tomcat
Connect to Dotmailer from a connection pool in Tomcat.
-
How to Connect DBeaver to MySQL via a JDBC Driver
Manage MySQL with visual tools in DBeaver like the query browser.
-
Connect to Authorize.Net Data in HULFT Integrate
Connect to Authorize.Net as a JDBC data source in HULFT Integrate
-
Visualize Live LinkedIn Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LinkedIn.
-
Connect to SendPulse Data in Ruby
Connect to SendPulse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData ODBC Driver for Tavily in Microsoft Power Query
You can use the CData Tavily ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Tavily into Microsoft Power Query.
-
Integrate Lakebase Data in Pentaho Data Integration
Build ETL pipelines based on Lakebase in the Pentaho Data Integration tool.
-
Feed Adobe Analytics Data into FineReport
How to set Adobe Analytics as a JDBC data source in FineReport.
-
Import and Visualize Xero Data in Power View
Create data visualizations based on Xero Accounting in Excel.
-
Access Live Microsoft Ads Data in Coginiti Pro
Connect to and query live Microsoft Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use CData Connect AI to Access Google Campaign Manager 360 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Campaign Manager 360 in the Power Pivot business intelligence tool.
-
Connect to Google Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Analytics.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage Intacct
Create Sage Intacct data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Google Contacts-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Contacts and build Google Contacts-connected web apps with Axios.
-
Connect to Live Adobe Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to Adobe Analytics Data in CData Connect AI and connect to your Adobe Analytics from MicroStrategy.
-
Access Teamwork Data from MySQL in PHP
Connect to Teamwork through the standard MySQL libraries in PHP.
-
How to Connect to & Open Calendly Data in Microsoft Excel
This article uses the CData ODBC driver for Calendly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Raisers Edge NXT Data to Multiple Databases
Replicate Raisers Edge NXT to disparate databases with a point-and-click configuration.
-
Connect to Datadog from a Connection Pool in WebLogic
Use the CData JDBC Driver for Datadog to connect to Datadog from Web applications running on WebLogic.
-
Migrating data from Invoiced to Databricks using CData SSIS Components.
Easily push Invoiced to Databricks using the CData SSIS Tasks for Invoiced and Databricks.
-
Viewing Access Data in RAD Studio Data Explorer
How to view Microsoft Access in RAD Studio Data Explorer using the CData ODBC Driver for Access.
-
How to Query Salesforce Data 360 Data in MySQL Workbench
Execute MySQL queries against live Salesforce Data 360 from MySQL Workbench.
-
How to integrate Metabase with Twilio Data
Use CData Connect AI to connect to live Twilio and create an interactive dashboard in Metabase from Twilio.
-
Connect to Zoho Inventory Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho Inventory Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Edit and Search QuickBooks External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of QuickBooks Desktop to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create QuickBooks objects that you can access from apps and the dashboard.
-
Visualize Google Spanner Data in TIBCO Spotfire through ADO.NET
Integrate Google Spanner into dashboards in TIBCO Spotfire.
-
Extract, Transform, and Load Elasticsearch Data in Informatica PowerCenter
Create a simple Workflow for Elasticsearch in Informatica PowerCenter.
-
Connecting Mastra with AlloyDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google AlloyDB, no replication required.
-
Integrating Antigravity CLI with Qualaroo via CData CLI
Connect Qualaroo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
ETL Placid in Oracle Data Integrator
This article shows how to transfer Placid into a data warehouse using Oracle Data Integrator.
-
Create Power BI Reports on Real-Time AlloyDB Data
Use the CData ODBC Driver for AlloyDB to visualize Google AlloyDB in Power BI Desktop.
-
DataBind Controls to Authorize.Net Data in Delphi
DataBind to Authorize.Net in Delphi with standard data access components and controls.
-
Automate Amazon Athena Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Amazon Athena and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Query Google Spanner Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Spanner and perform CRUD operations on Google Spanner from Node.js.
-
Create Datasets from Omnisend in Domo Workbench and Build Visualizations of Omnisend Data in Domo
Use the CData Software ODBC Driver for Omnisend to create datasets from Omnisend in Domo Workbench and then build visualizations in the Domo service.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Marketo actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Create Dynamic Drift Grids Using the Infragistics XamDataGrid
Learn how you can connect Drift to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to Google Translate Data from IntelliJ
Integrate connectivity to Google Translate with wizards in IntelliJ.