CData Software - Knowledge Base
Recent Articles
-
How to Connect to Zoho Projects Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Projects. Leverage the pyodbc module for ODBC in Python.
-
How to import DocuSign Data into Apache Solr
Use the CData Software JDBC Driver for DocuSign in Data Import Handler and create an automated import of DocuSign to Apache Solr Enterprise Search platform.
-
Choosing the Best Method to Connect Confluence to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Atlassian Confluence from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData API Server to Access ZarMoney Data in Microsoft PowerPivot
Use the CData API Server to connect to live ZarMoney in the Power Pivot business intelligence tool.
-
Connect to Float Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Float to connect to Float and execute queries in PowerBuilder.
-
Replicate EmailOctopus Data to Multiple Databases via the CData Sync CLI
Replicate EmailOctopus to disparate databases with a single configuration.
-
Connect to Microsoft Teams Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Teams.
-
Natively Connect to Drip Data in PHP
The CData ODBC driver for Drip enables you to create PHP applications with connectivity to Drip. Leverage the native support for ODBC in PHP.
-
Bidirectional Access to Apify Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apify in Filemaker Pro for Mac or Windows.
-
How to Work with Timely Data in ETL Validator JDBC
Connect to Timely from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Import Data from ZohoPeople into Google Sheets
Import ZohoPeople into a Google spreadsheet that is automatically refreshed.
-
Process & Analyze Perplexity Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Perplexity Data.
-
Automated Continuous MessageBird Replication to SQLite
Use CData Sync for automated, continuous, customizable MessageBird replication to SQLite.
-
Import Real-Time SendGrid Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SendGrid in ColdFusion.
-
Replicate EmailOctopus Data from PowerShell
Write a quick PowerShell script to query EmailOctopus. Use connectivity to the live data to replicate EmailOctopus to SQL Server.
-
Access Lakebase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Lakebase from your Oracle system.
-
How to create an RPA flow for Printify Data in UiPath Studio
Use the Printify ODBC Driver to create workflows that access real-time Printify without any coding.
-
How to connect PolyBase to Adobe Experience Manager
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Adobe Experience Manager.
-
Operational Reporting on PostgreSQL Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PostgreSQL.
-
Visualize Live Salesloft Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesloft.
-
How to Query Live Amazon S3 Data in Perplexity MacOS Desktop
Connect to and query live Amazon S3 Data in Perplexity Desktop using CData MCP Server.
-
Build Charts with Bannerbear Data in Clear Analytics
Create dynamic charts and perform analytics based on Bannerbear in Clear Analytics.
-
Migrating data from Brex to Snowflake using CData SSIS Components.
Easily push Brex to Snowflake using the CData SSIS Tasks for Brex and Snowflake.
-
How to Work with Cohere Data in ETL Validator JDBC
Connect to Cohere from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Insightly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Insightly replication to Apache Cassandra.
-
Extend Google Sheets with Autopilot Data
Make calls to Autopilot from Google Apps Script via the API Server.
-
How to Seamlessly Import SuiteCRM Data into IBM SPSS Modeler
Integrate SuiteCRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extend Google Sheets with Cassandra Data
Make calls to Cassandra from Google Apps Script via the API Server.
-
How to Visualize Toggl Data in Python with pandas
Use pandas and other modules to analyze and visualize live Toggl in Python.
-
Validate Dynamics CRM Data with QuerySurge
Access and validate Microsoft Dynamics CRM in QuerySurge using the CData JDBC Driver.
-
Consume Paylocity OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Paylocity feeds that reflect any changes in SAP Lumira.
-
Analyze Microsoft Dataverse Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Dataverse Data from Cognos Analytics and analyze live Microsoft Dataverse (CDS).
-
Easily Integrate Drip Data in Lazarus Pascal IDE
Learn how to easily integrate live Drip in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query, Visualize, and Share live CSV Data in Redash
Use CData Connect AI to connect to live CSV/TSV Files in Redash for querying, visualizing, and sharing.
-
Enable the Zuora JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zuora.
-
Connect to SingleStore 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 SingleStore.
-
Design BIRT Reports on Airtable Data
Provide current Airtable to your embedded analytics.
-
A PostgreSQL Interface for Qualaroo Data using the CData ODBC Driver
Use the SQL Gateway and Qualaroo ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind SpaceX Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide SpaceX to a chart.
-
Connect to Google Ad Manager Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Ad Manager and the SQL Gateway to access Google Ad Manager from Google Apps Script.
-
Cassandra Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Cassandra through CData Connect AI using different applications and tools.
-
Connect to FHIR Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FHIR.
-
Automated Continuous Copper Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Copper replication to Google Cloud SQL.
-
Automated Continuous Airtable Replication to MySQL
Use CData Sync for automated, continuous, customizable Airtable replication to MySQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aircall
Provide connectivity to Aircall through an SAP BusinessObjects universe.
-
How to Visualize Sage Cloud Accounting Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sage Business Cloud Accounting in Python.
-
How to Connect DBeaver to ZeroBounce via a JDBC Driver
Manage ZeroBounce with visual tools in DBeaver like the query browser.
-
Visualize Zoom 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 Zoom into TIBCO Spotfire.
-
Access Live Salesforce CRM Analytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce CRM Analytics from your Excel spreadsheets.
-
How to create Supabase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Supabase in MySQL .
-
Create Data Visualizations Based On GraphQL Data in Mode
Use CData Connect AI to connect to GraphQL Data from Mode and build visualizations using live
-
A PostgreSQL Interface for Qualaroo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Qualaroo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Certinia Replication to SQL Server
Use CData Sync for automated, continuous, customizable Certinia replication to SQL Server.
-
Connect to Superchat Data in HULFT Integrate
Connect to Superchat as a JDBC data source in HULFT Integrate
-
Build Dashboards with Perigon Data in Dundas BI
Create dynamic dashboards and perform analytics based on Perigon in Dundas BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Pipedrive
Create Pipedrive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Dashboards with Kintone Data in Dundas BI
Create dynamic dashboards and perform analytics based on Kintone in Dundas BI.
-
Feed Microsoft Exchange Data into FineReport
How to set Microsoft Exchange as a JDBC data source in FineReport.
-
Integrate Cursor with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon DynamoDB from within the editor.
-
Analyze Active Directory Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Active Directory in Microsoft R Open.
-
Access Live Marketo Data in Excel 365 Online (Excel for the web)
Connect to Marketo from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Data Visualizations in Cognos BI with GitLab Data
Access GitLab as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Build an ETL App for Authorize.Net Data in Python with CData
Create ETL applications and real-time data pipelines for Authorize.Net in Python with petl.
-
Analyze Bright Data Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bright Data in Microsoft R Open.
-
Create SAP HANA-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP HANA Data from OutSystems and build custom enterprise apps using live SAP HANA.
-
Analyze AfterShip Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze AfterShip in Microsoft R Open.
-
Create Dynamic Ontraport Grids Using the Infragistics XamDataGrid
Learn how you can connect Ontraport to Infragistics XamDataGrid to build dynamic grids.
-
Extend Google Sheets with Elorus Data
Make calls to Elorus from Google Apps Script via the API Server.
-
Automated Continuous Oracle Eloqua Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Oracle.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for QuickBooks Online
Provide connectivity to QuickBooks Online through an SAP BusinessObjects universe.
-
Deploy the ADO.NET Provider for Samanage on an SSRS Report Server
Connect to Samanage 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.
-
Automated Continuous Sage 200 Replication to Vertica
Use CData Sync for automated, continuous, customizable Sage 200 replication to Vertica.
-
How to integrate Zoho Creator with Apache Airflow
Access and process Zoho Creator in Apache Airflow using the CData JDBC Driver.
-
Create Sugar CRM-Connected Dashboards in Grafana
Connect to Sugar CRM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sugar CRM.
-
Getting Started with the CData JDBC Driver for Mailjet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mailjet.
-
Access Rebilly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Rebilly from your Oracle system.
-
Analyze Notion Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Notion and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Easily Integrate Neo4J Data in Lazarus Pascal IDE
Learn how to easily integrate live Neo4J in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Datasets from SAP SuccessFactors in Domo Workbench and Build Visualizations of SAP SuccessFactors Data in Domo
Use the CData Software ODBC Driver for SAP SuccessFactors to create datasets from SAP SuccessFactors in Domo Workbench and then build visualizations in the Domo service.
-
Create Azure Data Lake Storage-Connected Business Apps in AppSheet
Connect to Azure Data Lake Storage Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Data Lake Storage.
-
How to Easily Query Dotmailer Data in OpenOffice Base
Connect to Dotmailer data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
DataBind Controls to SAP Data in C++Builder
DataBind to SAP ERP/NetWeaver in C++Builder with standard components and controls.
-
Building Dynamic Web Pages with Apify Data Using AngularJS
Create single-page applications with live connectivity to Apify using the CData API Server.
-
Integrate FTP Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live FTP Servers from Informatica Cloud.
-
Visualize Tanda Data in TIBCO Spotfire through ADO.NET
Integrate Tanda into dashboards in TIBCO Spotfire.
-
Build DocuSign-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for DocuSign Data and create custom apps in Mendix.
-
Visualize Shippo Data in Sisense
Create an ElastiCube in Sisense app with access to Shippo.
-
Connect to Adobe Experience Manager from a Connection Pool in WebLogic
Use the CData JDBC Driver for Adobe Experience Manager to connect to Adobe Experience Manager from Web applications running on WebLogic.
-
How to connect and process SAP Business Warehouse from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Business Warehouse.
-
Use the CData Software ODBC Driver for Teradata in MicroStrategy Desktop
Connect to Teradata in MicroStrategy Desktop using the CData Software ODBC Driver for Teradata.
-
Create Informatica Mappings From/To a JDBC Data Source for Recurly
Create Recurly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Replicate GitLab Data to Multiple Databases
Replicate GitLab to disparate databases with a point-and-click configuration.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho Books
Create an ODBC connection to Zoho Books in Informatica and browse and transfer Zoho Books.
-
Automated Continuous Humanity Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Humanity replication to Amazon S3.
-
Replicate Multiple Rebilly Accounts via the CData Sync CLI
Replicate multiple Rebilly accounts to one or many databases.
-
Connect to Google Forms 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 Google Forms and work with Google Forms in your FileMaker application.
-
Import and Visualize REST Data in Power View
Create data visualizations based on REST in Excel.
-
Build Dotmailer-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Dotmailer Data in GitHub Copilot to assist with building Dotmailer-powered applications.
-
Use the CData Software ODBC Driver for Adobe Commerce in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Commerce in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Commerce.
-
How to Query Google Contacts Data in MySQL Workbench
Execute MySQL queries against live Google Contacts from MySQL Workbench.