CData Software - Knowledge Base
Recent Articles
-
Visualize Cassandra Data in Sisense
Create an ElastiCube in Sisense app with access to Apache Cassandra.
-
Connect to MYOB AccountRight Data from Crystal Reports
Use CData Connect AI to connect to and report on live MYOB AccountRight from Crystal Reports.
-
How to connect to SAP HANA Data from IntelliJ
Integrate connectivity to SAP HANA with wizards in IntelliJ.
-
Create Informatica Mappings From/To a JDBC Data Source for Toggl
Create Toggl data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Live SurveyMonkey Data in MicroStrategy through CData Connect AI
Create a live connection to SurveyMonkey Data in CData Connect AI and connect to your SurveyMonkey from MicroStrategy.
-
How to Query Live BenchmarkEmail Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live BenchmarkEmail data in natural language using Python.
-
How to connect Amazon QuickSight to Slack Data
Create a connection to Slack in CData Connect AI and insert Slack into Amazon QuickSight SPICE to build interactive dashboards.
-
A PostgreSQL Interface for Omnisend Data using the CData ODBC Driver
Use the SQL Gateway and Omnisend ODBC Driver to create a PostgreSQL entry-point for data access.
-
SAP Ariba Procurement Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Ariba Procurement through CData Connect AI using different applications and tools.
-
Automated Continuous ZohoSubscriptions Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to AlloyDB.
-
View Reports on Real-Time HDFS Data in Power BI Report Server
Use the CData ODBC Driver for HDFS to visualize Apache HDFS in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Avaza Data in TIBCO Spotfire through ADO.NET
Integrate Avaza into dashboards in TIBCO Spotfire.
-
Back Up Google Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Ads. In this article, we will employ an SSIS workflow to populate a database with Google Ads data.
-
Automate Autopilot Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Autopilot from PowerShell? This article demonstrates how to utilize the Autopilot Cmdlets for tasks like connecting to Autopilot, automating operations, downloading data, and more.
-
Connect and Query Live PayPal Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live PayPal into Databricks
-
Load Sybase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sybase to a database.
-
Migrating data from Contentful to Google BigQuery using CData SSIS Components.
Easily push Contentful to Google BigQuery using the CData SSIS Tasks for Contentful and Google BigQuery.
-
DataBind Controls to Samanage Data in Delphi
DataBind to Samanage in Delphi with standard data access components and controls.
-
Query Teradata Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Teradata entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for Redis in Microsoft Power Query
You can use the CData Redis ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Redis into Microsoft Power Query.
-
Getting Started with the CData ODBC Driver for MariaDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MariaDB.
-
Using the CData Software ODBC Driver for Contentful in PyCharm
Connect to Contentful as an ODBC data source in PyCharm using the CData Software ODBC Driver for Contentful.
-
Build Dashboards with Clio Data in Dundas BI
Create dynamic dashboards and perform analytics based on Clio in Dundas BI.
-
Connect to and Visualize Live Workable Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Workable.
-
Connect to Sendwithus Data in HULFT Integrate
Connect to Sendwithus as a JDBC data source in HULFT Integrate
-
Connect to MailChimp Data in Ruby
Connect to MailChimp in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Import Real-Time LinkedIn Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LinkedIn in ColdFusion.
-
Build Dashboards with ZendeskSell Data in DBxtra
Create dynamic dashboards and perform analytics based on ZendeskSell in DBxtra.
-
Replicate Multiple Email Accounts via the CData Sync CLI
Replicate multiple Email accounts to one or many databases.
-
Automated Continuous Salesforce Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Salesforce replication to Azure SQL Database.
-
Consume IBM Informix OData Feeds in SAP Lumira
Use the API Server to create data visualizations on IBM Informix feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Amazon Marketplace Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to IBM DB2.
-
Creating Okta-Connected Applications in Unqork
You can use CData Connect AI to feed Okta to Unqork and build custom business apps.
-
Connect to Real-Time ScrapingBee Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ScrapingBee in Power Apps.
-
Create Informatica Mappings From/To a JDBC Data Source for Eventbrite
Create Eventbrite data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Codex CLI with SAP Ariba Procurement 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.
-
Oracle Eloqua Reporting in OBIEE with the Oracle Eloqua JDBC Driver
Deploy the Oracle Eloqua JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Dash to Build to Web Apps on BigCommerce Data
Create Python applications that use pandas and Dash to build BigCommerce-connected web apps.
-
How to Connect to SharePoint Excel Services Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SharePoint Excel Services. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for Amazon Athena in Microsoft Power Query
You can use the CData Amazon Athena ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon Athena into Microsoft Power Query.
-
ETL Testmonitor in Oracle Data Integrator
This article shows how to transfer Testmonitor into a data warehouse using Oracle Data Integrator.
-
Connect to Bugsnag Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Bugsnag and work with Bugsnag in your FileMaker applications.
-
Automate LDAP Objects Replication to Couchbase
Use CData Sync to Customize and automate LDAP replication to Couchbase.
-
Query Google Tasks Data as a MySQL Database in Node.js
Execute MySQL queries against Google Tasks from Node.js.
-
How to Query Live Brex Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Brex data in natural language using Python.
-
Process & Analyze Unbounce Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Unbounce Data.
-
Connect to Helpscout Data in JRuby
Create a simple JRuby app with access to live Helpscout.
-
Build Semantic Layer Views for Sugar CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sugar CRM.
-
Visualize Adobe Commerce 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 Adobe Commerce into TIBCO Spotfire.
-
Automated Continuous Dynamics CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Amazon S3.
-
Bridge Productboard Connectivity with Apache NiFi
Access and process Productboard in Apache NiFi using the CData JDBC Driver.
-
Visualize Microsoft OneDrive Data in Tableau
The CData ODBC driver for Microsoft OneDrive enables you integrate Microsoft OneDrive into Tableau dashboards.
-
Getting Started with the CData ADO.NET Provider for Qualaroo
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Datasets from AdRoll in Domo Workbench and Build Visualizations of AdRoll Data in Domo
Use the CData Software ODBC Driver for AdRoll to create datasets from AdRoll in Domo Workbench and then build visualizations in the Domo service.
-
Publish eBay Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live eBay Analytics.
-
Build Visualizations of Hive Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache Hive in Birst.
-
Build Act CRM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Act CRM Data and create custom apps in Bubble.
-
Automated Continuous Shopify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Shopify replication to Snowflake.
-
DataBind ConvertKit Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ConvertKit to a chart.
-
Load Calendly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Calendly to a database.
-
Create Humanity Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Humanity from PowerBI.com to create Power BI Dataflows with real-time data.
-
Work with Live Raisers Edge NXT Data in Power Query
Use CData Connect AI to connect to Raisers Edge NXT and work with live Raisers Edge NXT in Microsoft Power Query.
-
Getting Started with the CData Connect AI Python SDK for Google Calendar
Install the CData Connect AI Python SDK to read and write live Google Calendar with standard DB-API 2.0 Python code.
-
Import Real-Time RSS Feeds via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use RSS Feeds in ColdFusion.
-
Connect to Rebilly Data in CloverDX (formerly CloverETL)
Transfer Rebilly using the visual workflow in the CloverDX data integration tool.
-
Connect to Avaza Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Avaza and work with Avaza in your FileMaker application.
-
Manage Jumpseller Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Jumpseller.
-
Access Live RSS Feeds in TIBCO Data Virtualization
Use the RSS Tibco DV Adapter to create a RSS Feeds data source in TIBCO Data Virtualization Studio and gain access to live RSS Feeds from your TDV Server.
-
Automate WooCommerce Data Replication to SAP HANA
Use CData Sync to customize and automate WooCommerce replication to SAP HANA.
-
Visualize SAP ByDesign Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Business ByDesign.
-
Automate Shortcut Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Shortcut from PowerShell? This article demonstrates how to utilize the Shortcut Cmdlets for tasks like connecting to Shortcut, automating operations, downloading data, and more.
-
Integrate Live FreshBooks Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Freshservice Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Freshservice in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Jodoo Replication to Vertica
Use CData Sync for automated, continuous, customizable Jodoo replication to Vertica.
-
How to Connect to Live Couchbase Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Couchbase for you.
-
Integrate with Live Greenplum Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Greenplum from the MuleSoft Anypoint Platform to integrate live Pivotal GreenPlum into custom reports and dashboards.
-
Create QuickBooks Time-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to QuickBooks Time Data from OutSystems and build custom enterprise apps using live QuickBooks Time.
-
How to Easily Query Superchat Data in OpenOffice Base
Connect to Superchat data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Azure Data Catalog Data in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Data Catalog in FileMaker Pro to connect to Azure Data Catalog and work with Azure Data Catalog in your FileMaker applications.
-
How to Query Oracle Eloqua Reporting Data in MySQL Workbench
Execute MySQL queries against live Oracle Eloqua Reporting from MySQL Workbench.
-
Use JayDeBeApi to access Pipedrive Data in Python
Use standard Python scripting and the development environment of your choice to access live Pipedrive.
-
Connect to Salesforce CRM Analytics Data in DBeaver
Use the CData ODBC Driver to connect to Salesforce CRM Analytics in DBeaver.
-
How to Create Power BI Visual Reports with Real-Time PayPal Data
Use CData Power BI Connectors to visualize PayPal in Power BI.
-
Query Snapchat Ads Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Snapchat Ads and perform CRUD operations on Snapchat Ads from Node.js.
-
Use Dash to Build to Web Apps on Cosmos DB Data
Create Python applications that use pandas and Dash to build Cosmos DB-connected web apps.
-
Design BIRT Reports on SAP HANA Data
Provide current SAP HANA to your embedded analytics.
-
Import Anaplan Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Anaplan. In this article, you will use the OData format to import Anaplan into Microsoft Power Query.
-
Explore Geographical Relationships in Klipfolio Data with Power Map
Create data visualizations with Klipfolio in Power Map.
-
Getting Started with the CData ADO.NET Provider for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Add Teamgate Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Teamgate with the Informatica Enterprise Data Catalog to classify and organize data.
-
Validate GitHub Data with QuerySurge
Access and validate GitHub in QuerySurge using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for ServiceNow in MicroStrategy
Connect to ServiceNow in MicroStrategy Developer using the CData Software JDBC Driver for ServiceNow.
-
Create Informatica Mappings From/To a JDBC Data Source for Mailgun
Create Mailgun data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query, Visualize, and Share live Presto Data in Redash
Use CData Connect AI to connect to live Presto in Redash for querying, visualizing, and sharing.
-
Create Mode Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mode data access from reports, embedded analytics, and more.
-
Bidirectional Access to Microsoft Exchange Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Exchange in Filemaker Pro for Mac or Windows.
-
Choosing the Best Method to Connect Dynamics 365 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Dynamics 365 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating OpenCode Terminal with Avro 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.
-
Create Data Visualizations in Cognos BI with Discourse Data
Access Discourse as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Charts to MailerLite Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MailerLite 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.