CData Software - Knowledge Base
Recent Articles
-
Publish ZarMoney-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZarMoney.
-
Analyze Pingdom Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pingdom with the CData JDBC Driver for Pingdom.
-
Creating SAP Ariba Procurement-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Ariba Procurement to Unqork and build custom business apps.
-
Connect to Teamgate Data in DBArtisan
Use wizards in DBArtisan to configure Teamgate as a data source.
-
Replicate ShipEngine Data to Multiple Databases via the CData Sync CLI
Replicate ShipEngine to disparate databases with a single configuration.
-
How to connect to NASA Data with Squirrel SQL client
Connect to NASA and execute queries in the Squirrel SQL Client.
-
Integrating Cursor CLI with Guru 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.
-
Automated Continuous Opsgenie Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Opsgenie replication to Amazon Redshift.
-
Access Live Salesforce CRM Analytics Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce CRM Analytics data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query Pinecone Data in DataGrip
Create a Data Source for Pinecone in DataGrip and use SQL to query live Pinecone.
-
Automated Continuous HubSpot Replication to MySQL
Use CData Sync for automated, continuous, customizable HubSpot replication to MySQL.
-
Access Reporting in OBIEE with the Access JDBC Driver
Deploy the Access JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Suadeo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Suadeo from PowerShell? This article demonstrates how to utilize the Suadeo Cmdlets for tasks like connecting to Suadeo, automating operations, downloading data, and more.
-
Create Data Visualizations in Cognos BI with PDFMonkey Data
Access PDFMonkey as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate DocuSign Data into Power Automate Desktop using CData Connect
CData Connect for DocuSign Data enables you to integrate DocuSign into workflows built using Microsoft Power Automate Desktop.
-
Extract, Transform, and Load Testmonitor Data in Informatica PowerCenter
Create a simple Workflow for Testmonitor in Informatica PowerCenter.
-
Deploy the ADO.NET Provider for MessageBird on an SSRS Report Server
Connect to MessageBird 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.
-
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.
-
Build Dashboards with Deel Data in DBxtra
Create dynamic dashboards and perform analytics based on Deel in DBxtra.
-
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.
-
Access Live SendGrid Data in Coginiti Pro
Connect to and query live SendGrid from the GUI in the Coginiti Pro: SQL Analytics 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.
-
Integrate Act-On Data in Pentaho Data Integration
Build ETL pipelines based on Act-On in the Pentaho Data Integration tool.
-
Connect to Microsoft Teams Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Teams.
-
Automated Continuous xBase Replication to SQL Server
Use CData Sync for automated, continuous, customizable xBase replication to SQL Server.
-
Integrating Claude Code CLI with Tanda 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.
-
Integrating OpenCode Terminal with Trello 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.
-
How to connect Amazon QuickSight to Twilio Data
Create a connection to Twilio in CData Connect AI and insert Twilio into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect MailerLite to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MailerLite with IBM WebSphere for seamless data integration and connectivity.
-
Import Real-Time SendGrid Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SendGrid in ColdFusion.
-
Connect to Pinterest Data in RazorSQL
Connect to Pinterest from wizards and query Pinterest from the GUI in the RazorSQL database management tool.
-
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.
-
Connect to and Query MailerLite Data in QlikView over ODBC
Create data visualizations with MailerLite in QlikView.
-
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.
-
Build Charts with Bannerbear Data in Clear Analytics
Create dynamic charts and perform analytics based on Bannerbear in Clear Analytics.
-
Automated Continuous Insightly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Insightly replication to Apache Cassandra.
-
Use the CData Software ODBC Driver for ConvertKit in MicroStrategy Web
Connect to ConvertKit in MicroStrategy Web using the CData Software ODBC Driver for ConvertKit.
-
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.
-
How to Visualize Toggl Data in Python with pandas
Use pandas and other modules to analyze and visualize live Toggl in Python.
-
Integrating Cursor CLI with Cloudflare 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.
-
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.
-
Manage Teamgate Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Teamgate.
-
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).
-
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.
-
Design BIRT Reports on Airtable Data
Provide current Airtable to your embedded analytics.
-
Build Dashboards with Neo4J Data in DBxtra
Create dynamic dashboards and perform analytics based on Neo4J in DBxtra.
-
Analyze Timely Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Timely from Power Pivot. You will use the Table Import Wizard to load Timely. You can visually build the import query or use any SQL supported by the driver.
-
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.
-
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.
-
Connect to Zoho Inventory Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho Inventory from Crystal Reports.
-
Excel Spreadsheet Automation on Google Drive Data with the QUERY Formula
Pull data from Google Drive, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Act-On in MicroStrategy Desktop
Connect to Act-On in MicroStrategy Desktop using the CData Software ODBC Driver for Act-On.
-
Use JayDeBeApi to access REST Data in Python
Use standard Python scripting and the development environment of your choice to access live REST.
-
How to Build an ETL App for Google Ad Manager Data in Python with CData
Create ETL applications and real-time data pipelines for Google Ad Manager in Python with petl.
-
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.
-
Publish ShipStation-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ShipStation.
-
Integrating Claude Code with Microsoft Entra ID Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Entra ID within assisted coding and automated development workflows.
-
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.
-
Use the CData API Server to Access Snapchat Ads Data in Microsoft PowerPivot
Use the CData API Server to connect to live Snapchat Ads in the Power Pivot business intelligence tool.
-
Build WooCommerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for WooCommerce Data and create custom apps in Bubble.
-
Feed Microsoft Exchange Data into FineReport
How to set Microsoft Exchange as a JDBC data source in FineReport.
-
How to connect to Adobe Commerce Data in DBVisualizer
Integrate Adobe Commerce with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Mistral AI Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mistral AI data access from reports, embedded analytics, and more.
-
Connect to Acumatica Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Acumatica and the SQL Gateway to access Acumatica ERP from Google Apps Script.
-
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.
-
Connect to SAP ByDesign in SpagoBI
Create reports featuring live SAP Business ByDesign in SpagoBI Studio. Host SAP ByDesign reports on SpagoBI Server.
-
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.
-
Migrating data from ADP to Snowflake using CData SSIS Components.
Easily push ADP to Snowflake using the CData SSIS Tasks for ADP and Snowflake.
-
How to Visualize Oracle Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Database in Python.
-
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.
-
Automated Continuous Oracle Eloqua Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Oracle.
-
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.
-
How to integrate Zoho Creator with Apache Airflow
Access and process Zoho Creator in Apache Airflow using the CData JDBC Driver.
-
Connect to Real-Time Google Directory Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Directory and Dataflow to import and use Google Directory in Power Apps.
-
Integrate Reckon Accounts Hosted Data in Pentaho Data Integration
Build ETL pipelines based on Reckon Accounts Hosted in the Pentaho Data Integration tool.
-
Getting Started with the CData JDBC Driver for Mailjet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mailjet.
-
Connect to Real-Time Zoho Recruit Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Zoho Recruit in Power Apps.
-
Connect to Sage Intacct Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sage Intacct from Filemaker Pro on Mac.
-
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.
-
Automated Continuous Pinterest Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Pinterest replication to PostgreSQL.
-
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.
-
Migrating data from Bugsnag to Google BigQuery using CData SSIS Components.
Easily push Bugsnag to Google BigQuery using the CData SSIS Tasks for Bugsnag and Google BigQuery.
-
Integrate Live SageHR Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SageHR to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
DataBind Controls to SAP Data in C++Builder
DataBind to SAP ERP/NetWeaver in C++Builder with standard components and controls.
-
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.
-
How to Work with Oracle Data in ETL Validator JDBC
Connect to Oracle from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Discord Replication to MongoDB
Use CData Sync for automated, continuous, customizable Discord replication to MongoDB.
-
How to Connect to & Open GetResponse Data in Microsoft Excel
This article uses the CData ODBC driver for GetResponse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Configure the CData JDBC Driver for Qualaroo in a Connection Pool in Tomcat
Connect to Qualaroo from a connection pool in Tomcat.
-
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.