CData Software - Knowledge Base
Recent Articles
-
Operational Reporting on Microsoft Teams from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Teams.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Slack
Provide connectivity to Slack through an SAP BusinessObjects universe.
-
How to Work with RSS Feeds in ETL Validator JDBC
Connect to RSS from ETL Validator jobs using the CData Software JDBC Driver.
-
Stream REST into Apache Kafka Topics
Access and stream REST in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automate Excel Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Excel replication to Azure Data Lake.
-
DataBind Charts to SAP BusinessObjects BI
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP BusinessObjects BI 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 create Visio diagrams from EnterpriseDB
Automatically update EnterpriseDB with the changes you make to Visio master shapes.
-
Analyze Zoho Inventory in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zoho Inventory and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
How to connect to Teradata from Spring Boot
Connect to Teradata in a Spring Boot Application using CData JDBC Teradata Driver
-
Migrating data from Oracle HCM Cloud to Snowflake using CData SSIS Components.
Easily push Oracle HCM Cloud to Snowflake using the CData SSIS Tasks for Oracle HCM Cloud and Snowflake.
-
How to Import Data from CSV into Google Sheets
Import CSV/TSV Files into a Google spreadsheet that is automatically refreshed.
-
Data Privacy And Security
We understand our drivers are used in applications and provide connectivity to sources that have private and sensitive information. We take security and privacy very seriously. Here we outline some of our relevant policies.
-
Access Live Asana in AWS Lambda (with IntelliJ IDEA)
Connect to live Asana in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to use SQLAlchemy ORM to access Kintone in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Kintone.
-
Create Dynamic Hive Grids Using the Infragistics XamDataGrid
Learn how you can connect Hive to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for Vault CRM in MicroStrategy Web
Connect to Veeva Vault & Vault CRM in MicroStrategy Web using the CData Software ODBC Driver for Vault CRM.
-
How to Connect to Live SingleStore in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SingleStore without replication.
-
Automated Continuous HubSpot Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HubSpot replication to Apache Kafka.
-
Automate SAP BusinessObjects BI Replication to SAP HANA
Use CData Sync to customize and automate SAP BusinessObjects BI replication to SAP HANA.
-
Model Oracle Sales Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle Sales, enabling the direct import of real-time Oracle Sales.
-
Create Datasets from Wave Financial in Domo Workbench and Build Visualizations of Wave Financial in Domo
Use the CData Software ODBC Driver for Wave Financial to create datasets from Wave Financial in Domo Workbench and then build visualizations in the Domo service.
-
Write a Simple Go Application to work with GraphQL on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GraphQL.
-
Excel Spreadsheet Automation on Odoo with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Twitter Ads in HULFT Integrate
Connect to Twitter Ads as a JDBC data source in HULFT Integrate
-
Integrate Smartsheet into Automated Tasks with Power Automate
Use CData Connect AI to connect to Smartsheet and integrate live Smartsheet into your Power Automate tasks.
-
Automated Continuous Azure Synapse Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Synapse replication to OneLake in Microsoft Fabric.
-
Automated Continuous Harvest Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Harvest replication to Microsoft Access.
-
Use CData Connect AI to Access MYOB AccountRight in Microsoft Power Pivot
Use CData Connect AI to connect to live MYOB AccountRight in the Power Pivot business intelligence tool.
-
How to connect SharePoint with Twilio through external lists
Provide Twilio to SharePoint users as an external list.
-
Integrate with Live Facebook in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Facebook from the MuleSoft Anypoint Platform to integrate live Facebook into custom reports and dashboards.
-
Feed Adobe Target into FineReport
How to set Adobe Target as a JDBC data source in FineReport.
-
Integrate with Kintone in SnapLogic
Use CData Connect AI to connect to and integrate with live Kintone in SnapLogic.
-
Easily Integrate Todoist in Lazarus Pascal IDE
Learn how to easily integrate live Todoist in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Cursor with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ServiceNow from within the editor.
-
Build Apps with Live ServiceNow in Adalo using CData Connect AI
Use CData Connect AI to integrate live ServiceNow into the Adalo platform and build custom mobile and web applications with real-time ServiceNow.
-
Visualize Live WooCommerce in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live WooCommerce into custom reports in Power BI.
-
How to create Box federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Box in MySQL .
-
ETL DB2 in Oracle Data Integrator
This article shows how to transfer IBM DB2 into a data warehouse using Oracle Data Integrator.
-
Create Reports with Active Directory in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Active Directory.
-
Access Live eBay Analytics in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate eBay Analytics into the statistical analysis tools available in SAS JMP. This article shows how to use eBay Analytics in the Graph Builder and Query Builder.
-
Migrating data from Databricks to Google BigQuery using CData SSIS Components.
Easily push Databricks to Google BigQuery using the CData SSIS Tasks for Databricks and Google BigQuery.
-
Automated Continuous Marketo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Marketo replication to Apache Cassandra.
-
Visualize Sage Cloud Accounting in TIBCO Spotfire through ADO.NET
Integrate Sage Business Cloud Accounting into dashboards in TIBCO Spotfire.
-
Query Spark as a MySQL Database in Node.js
Execute MySQL queries against Apache Spark SQL from Node.js.
-
Connect to Calendly as an External Source in Dremio
Use the CData JDBC Driver to connect to Calendly as an External Source in Dremio.
-
Build Visualizations of Azure Active Directory in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Active Directory in Birst.
-
Build MVC Applications with Connectivity to Google Calendar
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Calendar from an ASP.NET MVC application.
-
Publish Google Calendar-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Calendar.
-
Create GraphQL Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time GraphQL data access from reports, embedded analytics, and more.
-
Automate Drip Replication to Couchbase
Use CData Sync to Customize and automate Drip replication to Couchbase.
-
Use Dash to Build to Web Apps on MarkLogic
Create Python applications that use pandas and Dash to build MarkLogic-connected web apps.
-
Build Apps with Live Adobe Commerce in Adalo using CData Connect AI
Use CData Connect AI to integrate live Adobe Commerce into the Adalo platform and build custom mobile and web applications with real-time Adobe Commerce.
-
Integrate SFTP with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SFTP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SFTP.
-
How to Easily Query Dynamics 365 in OpenOffice Base
-