CData Software - Knowledge Base
Recent Articles
-
Build GraphQL-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to GraphQL and build web apps with connectivity to live GraphQL.
-
DataBind Charts to Testmonitor Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Testmonitor 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.
-
Access Accelo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Accelo from your Oracle system.
-
How to Work with Zoho Books Data in AWS Glue Jobs Using JDBC
Connect to Zoho Books from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Crystal Reports on MessageBird Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MessageBird.
-
Manage Sendwithus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sendwithus.
-
Integrate Live ActiveCampaign Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ActiveCampaign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ActiveCampaign.
-
Connect to Zoho Inventory Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho Inventory.
-
Replicate Couchbase Data from PowerShell
Write a quick PowerShell script to query Couchbase. Use connectivity to the live data to replicate Couchbase to SQL Server.
-
Replicate BenchmarkEmail Data to Multiple Databases via the CData Sync CLI
Replicate BenchmarkEmail to disparate databases with a single configuration.
-
Using the CData Software ODBC Driver for MessageBird in PyCharm
Connect to MessageBird as an ODBC data source in PyCharm using the CData Software ODBC Driver for MessageBird.
-
Analyze Excel Online Data in Looker
Use CData Connect AI to connect to Excel Online Data from Looker and build custom apps using live Microsoft Excel Online.
-
Feed Authorize.Net Data into FineReport
How to set Authorize.Net as a JDBC data source in FineReport.
-
Connect to Front from Asprova with CData Software ODBC Driver for Front
This article shows how to connect faster to Front data from Asprova.
-
Integrate Clockify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Clockify with External Services.
-
Use the CData Software ODBC Driver for Trello in MicroStrategy Desktop
Connect to Trello in MicroStrategy Desktop using the CData Software ODBC Driver for Trello.
-
How to Build an ETL App for Certinia Data in Python with CData
Create ETL applications and real-time data pipelines for Certinia in Python with petl.
-
Connect Discourse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Discourse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Building Dynamic Web Pages with Quaderno Data Using AngularJS
Create single-page applications with live connectivity to Quaderno using the CData API Server.
-
Build Visualizations of ClickTime Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ClickTime in Birst.
-
Establish a Live Connection with CircleCI Data using Tableau Bridge
The CData ODBC Driver for CircleCI enables you to integrate live CircleCI into Tableau Cloud dashboards using the Tableau Bridge.
-
Design BIRT Reports on ClickUp Data
Provide current ClickUp to your embedded analytics.
-
Prepare, Blend, and Analyze Zoom Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoom for self-service data analytics.
-
Write a Simple Go Application to work with Deel Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Deel.
-
Connect HubSpot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HubSpot with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Power BI Connector for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData ADO.NET Provider for Zuora
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zuora.
-
Create Informatica Mappings From/To an ODBC Data Source for Highrise
Create an ODBC connection to Highrise in Informatica and browse and transfer Highrise CRM.
-
Use Dash to Build to Web Apps on WordPress Data
Create Python applications that use pandas and Dash to build WordPress-connected web apps.
-
How to Connect the Power BI Service to SpaceX: Complete Guide
Connect to the CData Software Power BI Connector for SpaceX from PowerBI.com to provide real-time SpaceX across the organization.
-
Automate Airtable Data Replication to SAP HANA
Use CData Sync to customize and automate Airtable replication to SAP HANA.
-
Access Live Google Ads Data in Coginiti Pro
Connect to and query live Google Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Oracle HCM Cloud Data in TIBCO Spotfire through ADO.NET
Integrate Oracle HCM Cloud into dashboards in TIBCO Spotfire.
-
Automated Continuous Quickbase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Quickbase replication to Azure SQL Database.
-
Build Freshdesk-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Freshdesk Data and create custom apps in Bubble.
-
Connecting Agentforce with Freshservice Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Freshservice for you.
-
Integrating Kiro CLI with Close 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.
-
Shippo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Shippo facts in real time.
-
Visualize Live Zoho CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho CRM.
-
Build a PostgreSQL Interface for Quickbase Data using the CData JDBC Driver
Use the Remoting features of the Quickbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze SAP ByDesign Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Business ByDesign and visualize live SAP Business ByDesign in Infragistics Reveal.
-
How to create Onfleet federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Onfleet in MySQL .
-
Import Google Calendar Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Calendar. In this article, you will use the OData format to import Google Calendar into Microsoft Power Query.
-
How to Build an ETL App for Adobe Target Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Target in Python with petl.
-
Manage CockroachDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CockroachDB.
-
Replicate Google Forms Data to Multiple Databases via the CData Sync CLI
Replicate Google Forms to disparate databases with a single configuration.
-
Getting Started with the CData ADO.NET Provider for Tally
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Tally.
-
Import and Visualize HDFS Data in Power View
Create data visualizations based on Apache HDFS in Excel.
-
Query Facebook Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to Facebook Ads.
-
Build Data Flows from SAP Business Warehouse to SQL Server using SSIS
Easily back up SAP Business Warehouse to SQL Server using the SSIS components for SAP Business Warehouse.
-
Getting Started with the CData Python Connector for Figshare
Learn to install and license the CData Python Connector
-
Connect to HCL Domino Data in ACL Analytics
Connect to HCL Domino via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to HCL Domino.
-
Seamlessly Bring Exact Online Data into Retool Using CData Connect AI
Integrate Exact Online data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect to Freshdesk Data with Squirrel SQL client
Connect to Freshdesk and execute queries in the Squirrel SQL Client.
-
Connect to Insightly in SpagoBI
Create reports featuring live Insightly in SpagoBI Studio. Host Insightly reports on SpagoBI Server.
-
Connect to Optimizely from a Connection Pool in WebLogic
Use the CData JDBC Driver for Optimizely to connect to Optimizely from Web applications running on WebLogic.
-
Connect to Amplitude Data in DBeaver
Use the CData ODBC Driver to connect to Amplitude in DBeaver.
-
Query Mocean Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mocean from Node.js.
-
Automated Continuous Reckon Accounts Hosted Replication to MongoDB
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to MongoDB.
-
Connect to Amazon Marketplace 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 Amazon Marketplace.
-
Integrate with live Bullhorn CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Bullhorn CRM in Jitterbit.
-
Access Live SAP HANA Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP HANA into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA in the Graph Builder and Query Builder.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed FormSite to Power BI dashboards. Simply drag and drop FormSite into data visuals on the Power BI canvas.
-
Migrating data from Grafana to Google BigQuery using CData SSIS Components.
Easily push Grafana to Google BigQuery using the CData SSIS Tasks for Grafana and Google BigQuery.
-
Query Splunk Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Splunk and perform CRUD operations on Splunk from Node.js.
-
Migrating data from Perigon to Google BigQuery using CData SSIS Components.
Easily push Perigon to Google BigQuery using the CData SSIS Tasks for Perigon and Google BigQuery.
-
Connect to Azure Data Lake Storage Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Data Lake Storage Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Trello Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Trello from HeidiSQL.
-
How to Connect to Live Stripe Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Stripe securely in real time.
-
Query LDAP Objects from Node.js
Use the OData endpoint of the CData API Server to connect to your LDAP and perform CRUD operations on LDAP from Node.js.
-
Integrate Live Databricks Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Databricks from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Databricks.
-
Create Informatica Mappings From/To a JDBC Data Source for Scrapfly
Create Scrapfly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous SAP BusinessObjects BI Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to SQLite.
-
Create Printify Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Printify data access from reports, embedded analytics, and more.
-
Access Live Miro Data in AWS Lambda
Connect to live Miro in AWS Lambda using the CData JDBC Driver.
-
DataBind Charts to CouchDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache CouchDB 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.
-
Getting Started with the CData Excel Add-In for Zuora
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zuora.
-
Query Wistia Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Wistia from Node.js.
-
Connect to Wave Financial Data from PowerBuilder via JDBC
This article demonstrates how to access Wave Financial from PowerBuilder using the Wave Financial JDBC Driver.
-
Build MVC Applications with Connectivity to Microsoft Teams Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Teams from an ASP.NET MVC application.
-
How to connect to Supabase Data from IntelliJ
Integrate connectivity to Supabase with wizards in IntelliJ.
-
Connect to eBay Data from a Connection Pool in JBoss
Integrate eBay into Java servlets: Use the Management Console in JBoss to install the eBay JDBC Driver.
-
Create Google Campaign Manager 360 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Campaign Manager 360 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Authorize.Net Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Authorize.Net from Node.js.
-
Visualize Oracle Data in TIBCO Spotfire through ADO.NET
Integrate Oracle Database into dashboards in TIBCO Spotfire.
-
Access Live Oracle Eloqua Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Eloqua data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use Biml to Build SSIS Tasks to Replicate Humanity Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Humanity to SQL Server.
-
How to integrate Metabase with Oracle Eloqua Data
Use CData Connect AI to connect to live Oracle Eloqua and create an interactive dashboard in Metabase from Oracle Eloqua.
-
Natively Connect to Asana Data in PHP
The CData ODBC driver for Asana enables you to create PHP applications with connectivity to Asana. Leverage the native support for ODBC in PHP.
-
Use Grok to Talk to Your Amazon Athena 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 Amazon Athena for you.
-
Build an OLAP Cube in SSAS from Workable Data
Establish a connection to Workable data from SQL Server Analysis Services, and use the Workable Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate SharePoint Data from PowerShell
Write a quick PowerShell script to query Microsoft SharePoint. Use connectivity to the live data to replicate Microsoft SharePoint to SQL Server.
-
Create Quickbase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Quickbase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Freshservice Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshservice using standard SQL.
-
Query Oracle Service Cloud Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Service Cloud entities in PHP by modeling them as objects.
-
Analyze Discourse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Discourse from Power Pivot. You will use the Table Import Wizard to load Discourse. You can visually build the import query or use any SQL supported by the driver.
-
View Reports on Real-Time AdRoll Data in Power BI Report Server
Use the CData ODBC Driver for AdRoll to visualize AdRoll in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Pinterest Data Replication to Teradata
Use CData Sync to Customize and automate Pinterest replication to Teradata.
-
Connect to Blackbaud FE NXT Data in Jaspersoft Studio
Execute SQL to remote Blackbaud FE NXT in Jaspersoft Studio.
-
Import and Visualize Postmark Data in Power View
Create data visualizations based on Postmark in Excel.