CData Software - Knowledge Base
Recent Articles
-
ETL ConvertKit in Oracle Data Integrator
This article shows how to transfer ConvertKit into a data warehouse using Oracle Data Integrator.
-
How to integrate Metabase with Dropbox Data
Use CData Connect AI to connect to live Dropbox and create an interactive dashboard in Metabase from Dropbox.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Stack Exchange to Power BI dashboards. Simply drag and drop Stack Exchange into data visuals on the Power BI canvas.
-
Automated Continuous Bugsnag Replication to Vertica
Use CData Sync for automated, continuous, customizable Bugsnag replication to Vertica.
-
Use Manus AI to Talk to Your SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SAP HANA.
-
Integrate Everhour Data in Pentaho Data Integration
Build ETL pipelines based on Everhour in the Pentaho Data Integration tool.
-
Getting Started with the CData SSIS Components for AlloyDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for AlloyDB.
-
Integrate Todoist Data in the Pentaho Report Designer
Publish reports based on Todoist in the Pentaho BI tool.
-
Automate FHIR Data Replication to SAP HANA
Use CData Sync to customize and automate FHIR replication to SAP HANA.
-
Replicate Grafana Data in Heroku for Use in Salesforce Connect
Replicate Grafana to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Planio Data from IntelliJ
Integrate connectivity to Planio with wizards in IntelliJ.
-
Create SSAS Tabular Models from Clio Data
How to build a SQL Server Analysis Service Tabular Model from Clio using CData drivers.
-
Connect to Tally Data in CloverDX (formerly CloverETL)
Transfer Tally ERP using the visual workflow in the CloverDX data integration tool.
-
Use Dash to Build to Web Apps on Procore Data
Create Python applications that use pandas and Dash to build Procore-connected web apps.
-
Building Dynamic Web Pages with Postmark Data Using AngularJS
Create single-page applications with live connectivity to Postmark using the CData API Server.
-
Access Live Twitter Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twitter Ads from your Excel spreadsheets.
-
Create Reports with SAS xpt Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS XPORT.
-
Query SAS Data Sets Data as a MySQL Database in Node.js
Execute MySQL queries against SAS Data Sets from Node.js.
-
Getting Started with the CData Power BI Connector for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Amazon Marketplace.
-
Publish Neo4J-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Neo4J.
-
Integrate Live Zoho Creator Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Creator from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Creator.
-
Provide OData Services of Sugar CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sugar CRM by developing a WCF Service Application.
-
Build MVC Applications with Connectivity to ZeroBounce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZeroBounce from an ASP.NET MVC application.
-
Automate HelloSign Data Replication to Azure Data Lake
Use CData Sync to customize and automate HelloSign replication to Azure Data Lake.
-
Deploy the ADO.NET Provider for Vault CRM on an SSRS Report Server
Connect to Veeva Vault & Vault CRM 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.
-
Establish a Live Connection with Zoho CRM Data using Tableau Bridge
The CData ODBC Driver for Zoho CRM enables you to integrate live Zoho CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Configure the CData JDBC Driver for Salesforce in a Connection Pool in Tomcat
Connect to Salesforce & Force.com from a connection pool in Tomcat.
-
How to connect PolyBase to Campaigner
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Campaigner.
-
Automated Continuous MySQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MySQL replication to Google BigQuery.
-
Integrating Claude Code CLI with LionDesk 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.
-
Publish Crystal Reports on Telegram Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Telegram.
-
Automated Continuous QuickBooks Replication to Snowflake
Use CData Sync for automated, continuous, customizable QuickBooks replication to Snowflake.
-
Access Live Klaviyo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Klaviyo into the statistical analysis tools available in SAS JMP. This article shows how to use Klaviyo in the Graph Builder and Query Builder.
-
Integrate Real-Time Access to SAP Ariba Source in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Ariba Source in real time.
-
Build Automated Workflows with Live Quickbase Data in Workato
Use CData Connect AI to connect to live Quickbase and build automated workflows in Workato.
-
Import and Visualize Redshift Data in Power View
Create data visualizations based on Amazon Redshift in Excel.
-
Connect to Avaza Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import and Visualize Mouseflow Data in Power View
Create data visualizations based on Mouseflow in Excel.
-
Create Data Visualizations in Cognos BI with XML Data
Access XML Files as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData Power BI Connector for HelloSign
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create a Data Access Object for SAP HANA Data using JDBI
A brief overview of creating a SQL Object API for SAP HANA in JDBI.
-
Stream Elasticsearch Data into Apache Kafka Topics
Access and stream Elasticsearch in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to HubDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HubDB as an External Source in Dremio.
-
Automated Continuous SendInBlue Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SendInBlue replication to Apache Kafka.
-
Connect to and Query Invoiced Data in QlikView over ODBC
Create data visualizations with Invoiced in QlikView.
-
Migrating data from Workable to Snowflake using CData SSIS Components.
Easily push Workable to Snowflake using the CData SSIS Tasks for Workable and Snowflake.
-
Analyze PostgreSQL Data in Cognos Analytics
Use CData Connect AI to connect to PostgreSQL Data from Cognos Analytics and analyze live PostgreSQL.
-
Natively Connect to SAP Fieldglass Data in PHP
The CData ODBC driver for SAP Fieldglass enables you to create PHP applications with connectivity to SAP Fieldglass. Leverage the native support for ODBC in PHP.
-
Create Dynamic Adobe Experience Manager Grids Using the Infragistics XamDataGrid
Learn how you can connect Adobe Experience Manager to Infragistics XamDataGrid to build dynamic grids.
-
Query QuickBooks Online Data as a SQL Server Database in Node.js
Execute SQL Server queries against QuickBooks Online from Node.js.
-
Connect to CouchDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CouchDB and the SQL Gateway to access Apache CouchDB from Google Apps Script.
-
How to work with Office 365 Data in Apache Spark using SQL
Access and process Office 365 Data in Apache Spark using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time SuiteCRM Data
Use the CData ODBC Driver for SuiteCRM to visualize SuiteCRM in Power BI Desktop.
-
Use Manus AI to Talk to Your Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Outreach.io.
-
Connect to Datadog Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Sugar CRM Reporting in OBIEE with the Sugar CRM JDBC Driver
Deploy the Sugar CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Yelp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Yelp replication to AlloyDB.
-
Automated Continuous AdRoll Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AdRoll replication to IBM DB2.
-
Connect to Factorial Data in NetBeans
Connect to Factorial in NetBeans with the data source configuration wizard.
-
How to integrate Metabase with Phoenix Data
Use CData Connect AI to connect to live Apache Phoenix and create an interactive dashboard in Metabase from Apache Phoenix.
-
Create SAS xpt Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAS xpt data access from reports, embedded analytics, and more.
-
Connect and Visualize Live Oracle HCM Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle HCM Cloud into the Databricks platform and create visualization dashboards with real-time Oracle HCM Cloud.
-
How to Work with Testmonitor Data in ETL Validator JDBC
Connect to Testmonitor from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect Apify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Apify with IBM WebSphere for seamless data integration and connectivity.
-
How to connect SharePoint with Auth0 Data through external lists
Provide Auth0 to SharePoint users as an external list.
-
How to connect and process Apache Kafka from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Kafka.
-
Automated Continuous OData Replication to Snowflake
Use CData Sync for automated, continuous, customizable OData replication to Snowflake.
-
Natively Connect to Bitbucket Data in PHP
The CData ODBC driver for Bitbucket enables you to create PHP applications with connectivity to Bitbucket. Leverage the native support for ODBC in PHP.
-
Connect to Live Sugar CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Sugar CRM Data in CData Connect AI and connect to your Sugar CRM from MicroStrategy.
-
SendPulse Reporting in OBIEE with the SendPulse JDBC Driver
Deploy the SendPulse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Scrapfly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Scrapfly from PowerShell? This article demonstrates how to utilize the Scrapfly Cmdlets for tasks like connecting to Scrapfly, automating operations, downloading data, and more.
-
How to Easily Query LinkedIn Ads Data in OpenOffice Base
Connect to LinkedIn Ads data in OpenOffice Base using the CData ODBC Driver for LinkedIn Ads and generate reports with live data insights.
-
Use the CData SSIS Components to Insert New or Update Existing Active Directory Records from SQL Server
Easily push SQL Server data to Active Directory using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Active Directory or update existing records with data from a SQL Server database.
-
Connect to Amazon Athena Data from a Connection Pool in JBoss
Integrate Amazon Athena into Java servlets: Use the Management Console in JBoss to install the Amazon Athena JDBC Driver.
-
Configure the CData JDBC Driver for Auth0 in a Connection Pool in Tomcat
Connect to Auth0 from a connection pool in Tomcat.
-
How to work with Opsgenie Data in Apache Spark using SQL
Access and process Opsgenie Data in Apache Spark using the CData Software JDBC Driver.
-
Build Adobe Commerce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Commerce.
-
How to Connect DBeaver to SAP Business One via a JDBC Driver
Manage SAP Business One with visual tools in DBeaver like the query browser.
-
Operational Reporting on PayPal Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PayPal.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle HCM Cloud
Provide connectivity to Oracle HCM Cloud through an SAP BusinessObjects universe.
-
Automated Continuous Hubstaff Replication to Databricks
Use CData Sync for automated, continuous, customizable Hubstaff replication to Databricks.
-
How to Connect the Power BI Service to Simplesat: Complete Guide
Connect to the CData Software Power BI Connector for Simplesat from PowerBI.com to provide real-time Simplesat across the organization.
-
Build Data Flows from Cloudflare to SQL Server using SSIS
Easily back up Cloudflare to SQL Server using the SSIS components for Cloudflare.
-
How to Visualize Google Directory Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Directory in Python.
-
Automated Continuous Clockify Replication to SQLite
Use CData Sync for automated, continuous, customizable Clockify replication to SQLite.
-
Create a Data Access Object for ZarMoney Data using JDBI
A brief overview of creating a SQL Object API for ZarMoney in JDBI.
-
Access Live Neo4J Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Neo4J from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query, Visualize, and Share live MariaDB Data in Redash
Use CData Connect AI to connect to live MariaDB in Redash for querying, visualizing, and sharing.
-
Integrate Theia IDE with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create Spark Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Spark data access from reports, embedded analytics, and more.
-
Establish a Live Connection with Typeform Data using Tableau Bridge
The CData ODBC Driver for Typeform enables you to integrate live Typeform into Tableau Cloud dashboards using the Tableau Bridge.
-
Working with JobNimbus Data in LINQPad
Execute LINQ queries to JobNimbus in LINQPad.
-
Connect to Datadog Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Datadog and the SQL Gateway to access Datadog from Google Apps Script.
-
Create Informatica Mappings From/To a JDBC Data Source for HelloSign
Create HelloSign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Configure the CData JDBC Driver for LionDesk in a Connection Pool in Tomcat
Connect to LionDesk from a connection pool in Tomcat.
-
Connect to Greenplum from a Connection Pool in WebLogic
Use the CData JDBC Driver for Greenplum to connect to Pivotal GreenPlum from Web applications running on WebLogic.
-
Integrating LlamaIndex with Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Salesforce CRM Analytics in real time.
-
Connect to Wrike Data in DBArtisan
Use wizards in DBArtisan to configure Wrike as a data source.
-
Visualize Vercel 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 Vercel into TIBCO Spotfire.
-
Connect to Google Sheets Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Spreadsheets and the Script function in FileMaker Pro to connect to Google Sheets and work with Google Sheets in your FileMaker application.