CData Software - Knowledge Base
Recent Articles
-
Connect to and Query OpenWeatherMap Data in QlikView over ODBC
Create data visualizations with OpenWeatherMap in QlikView.
-
Import Real-Time ZeroBounce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZeroBounce in ColdFusion.
-
Access Greenhouse Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Greenhouse.
-
How to Work with Okta Data in ETL Validator JDBC
Connect to Okta from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Datasets from Coinbase in Domo Workbench and Build Visualizations of Coinbase Data in Domo
Use the CData Software ODBC Driver for Coinbase to create datasets from Coinbase in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Python Connector for Vault CRM
Learn to install and license the CData Python Connector
-
Connect to and Visualize Live SAP BusinessObjects BI Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP BusinessObjects BI.
-
Connect to ServiceNow in SpagoBI
Create reports featuring live ServiceNow in SpagoBI Studio. Host ServiceNow reports on SpagoBI Server.
-
Build Charts with Tavily Data in Clear Analytics
Create dynamic charts and perform analytics based on Tavily in Clear Analytics.
-
Consume QuickBooks Time OData Feeds in PowerBuilder
This article demonstrates how to consume QuickBooks Time as OData feeds from PowerBuilder using the API Server.
-
Provide OData Services of Google Translate Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Translate by developing a WCF Service Application.
-
How to Work with Sendwithus Data in AWS Glue Jobs Using JDBC
Connect to Sendwithus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Trello Data from a Connection Pool in JBoss
Integrate Trello into Java servlets: Use the Management Console in JBoss to install the Trello JDBC Driver.
-
Connect to SQL Analysis Services Data from Crystal Reports
Use CData Connect AI to connect to and report on live SQL Analysis Services from Crystal Reports.
-
Provide OData Services of Paylocity Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Paylocity by developing a WCF Service Application.
-
Use JayDeBeApi to access GetResponse Data in Python
Use standard Python scripting and the development environment of your choice to access live GetResponse.
-
DataBind EnterpriseDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for EnterpriseDB with the DevExpress Windows Forms and Web controls to provide EnterpriseDB to a chart.
-
Migrating data from PingOne to Google BigQuery using CData SSIS Components.
Easily push PingOne to Google BigQuery using the CData SSIS Tasks for PingOne and Google BigQuery.
-
Connect to SparkPost Data in DBArtisan
Use wizards in DBArtisan to configure SparkPost as a data source.
-
Automate Sybase IQ Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sybase IQ replication to Azure Data Lake.
-
Automated Continuous Box Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Box replication to Google Cloud SQL.
-
How to update Wave Financial from Excel
This article explains how to transfer data from Excel to Wave Financial using the Excel Add-In for Wave Financial.
-
Integrate Live Adobe Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Adobe Analytics to Blue Prism using the CData ODBC Driver for Adobe Analytics to create automated workflows for repetitive business tasks.
-
Analyze Google Drive Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Drive from Power Pivot. You will use the Table Import Wizard to load Google Drive. You can visually build the import query or use any SQL supported by the driver.
-
How to Seamlessly Import GetResponse Data into IBM SPSS Modeler
Integrate GetResponse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Coinbase Data in Heroku for Use in Salesforce Connect
Replicate Coinbase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to create Visio diagrams from Xero Data
Automatically update Xero Accounting with the changes you make to Visio master shapes.
-
How to Work with PhantomBuster Data in AWS Glue Jobs Using JDBC
Connect to PhantomBuster from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Validate Apify Data with QuerySurge
Access and validate Apify in QuerySurge using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP SuccessFactors
Provide connectivity to SAP SuccessFactors through an SAP BusinessObjects universe.
-
Integrate LaunchDarkly Data in the Pentaho Report Designer
Publish reports based on LaunchDarkly in the Pentaho BI tool.
-
Replicate Multiple QuickBooks Accounts via the CData Sync CLI
Replicate multiple QuickBooks accounts to one or many databases.
-
Build MVC Applications with Connectivity to QuickBooks Online Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access QuickBooks Online from an ASP.NET MVC application.
-
Integrating LangChain with Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Salesforce Pardot within automated workflows.
-
Bridge Mode Connectivity with Apache NiFi
Access and process Mode in Apache NiFi using the CData JDBC Driver.
-
Migrating data from Active Directory to Snowflake using CData SSIS Components.
Easily push Active Directory to Snowflake using the CData SSIS Tasks for Active Directory and Snowflake.
-
Build Dashboards with Avaza Data in Dundas BI
Create dynamic dashboards and perform analytics based on Avaza in Dundas BI.
-
Build an OLAP Cube in SSAS from LaunchDarkly Data
Establish a connection to LaunchDarkly data from SQL Server Analysis Services, and use the LaunchDarkly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Browserless Data from MySQL in PHP
Connect to Browserless through the standard MySQL libraries in PHP.
-
How to Visualize Productboard Data in Python with pandas
Use pandas and other modules to analyze and visualize live Productboard in Python.
-
How to Connect Dropbox Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Dropbox data in real time using natural language.
-
Connect to Exact Online Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Exact Online in the Denodo Virtual DataPort Administrator.
-
Integrate Live Anaplan Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Anaplan to Blue Prism using the CData ODBC Driver for Anaplan to create automated workflows for repetitive business tasks.
-
Operational Reporting on Ontraport Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Ontraport.
-
Connect to Procore Data in Google Apps Script via Connect AI
Use CData Connect AI to access Procore in Google Apps Script.
-
How to connect and process Adobe Experience Manager from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Experience Manager.
-
How to Work with Procore Data in ETL Validator JDBC
Connect to Procore from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live Moosend Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Moosend using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Elasticsearch Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Elasticsearch Data and connect to Elasticsearch in Akorbi Digital RunMyProcess.
-
Migrating data from Google Spanner to Snowflake using CData SSIS Components.
Easily push Google Spanner to Snowflake using the CData SSIS Tasks for Google Spanner and Snowflake.
-
Explore Geographical Relationships in Shippo Data with Power Map
Create data visualizations with Shippo in Power Map.
-
Use Dash to Build Web Apps on Presto Data via CData Connect AI
Build interactive Dash web apps on live Presto using pandas and the CData Connect AI Python SDK.
-
Connect to Aweber Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Aweber.
-
Connect to Greenplum Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Greenplum and the Script function in FileMaker Pro to connect to Greenplum and work with Pivotal GreenPlum in your FileMaker application.
-
How to use SQLAlchemy ORM to access Monday.com Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Monday.com.
-
Automate Bitly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Bitly from PowerShell? This article demonstrates how to utilize the Bitly Cmdlets for tasks like connecting to Bitly, automating operations, downloading data, and more.
-
Connect to Datadog Data in NetBeans
Connect to Datadog in NetBeans with the data source configuration wizard.
-
Build Facebook-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Facebook Data and create custom apps in Mendix.
-
Connect to OpenWeatherMap in SpagoBI
Create reports featuring live OpenWeatherMap in SpagoBI Studio. Host OpenWeatherMap reports on SpagoBI Server.
-
Analyze Brex Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Brex with the CData JDBC Driver for Brex.
-
Automate Todoist Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Todoist from PowerShell? This article demonstrates how to utilize the Todoist Cmdlets for tasks like connecting to Todoist, automating operations, downloading data, and more.
-
Integrate Live JotForm Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live JotForm to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
ETL Workday in Oracle Data Integrator
This article shows how to transfer Workday into a data warehouse using Oracle Data Integrator.
-
Create Reports from Zoho Projects Data in Looker Studio
Use CData Connect AI to gain access to live Zoho Projects and create custom reports in Looker Studio.
-
Perform Batch Operations with IBM Informix Data in Apache NiFi
Connect to IBM Informix and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Rebilly
Provide connectivity to Rebilly through an SAP BusinessObjects universe.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Hive to Power BI dashboards. Simply drag and drop Apache Hive into data visuals on the Power BI canvas.
-
Choosing the Best Method to Connect Oracle Sales to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Sales from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Charts with Jira Assets Data in Clear Analytics
Create dynamic charts and perform analytics based on Jira Assets in Clear Analytics.
-
Access Live Scrapfly Data in Coginiti Pro
Connect to and query live Scrapfly from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Gumroad Data from PowerBuilder via JDBC
This article demonstrates how to access Gumroad from PowerBuilder using the Gumroad JDBC Driver.
-
Replicate Azure Blob Storage Data to Multiple Databases via the CData Sync CLI
Replicate Azure Blob Storage to disparate databases with a single configuration.
-
How to Easily Query SAP Concur Data in OpenOffice Base
Connect to SAP Concur data in OpenOffice Base using the CData ODBC Driver for SAP Concur and generate reports with live data insights.
-
Visualize Hacker News Data in TIBCO Spotfire through ADO.NET
Integrate Hacker News into dashboards in TIBCO Spotfire.
-
How to Connect to Live Azure DevOps Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Azure DevOps securely in real time.
-
Connect to SageHR from a Connection Pool in WebLogic
Use the CData JDBC Driver for SageHR to connect to SageHR from Web applications running on WebLogic.
-
Connect Shortcut Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Shortcut using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to ShipStation Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ShipStation.
-
Automated Continuous Mouseflow Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mouseflow replication to MongoDB.
-
Getting Started with the CData Connect AI Python SDK for Certinia
Install the CData Connect AI Python SDK to read and write live Certinia with standard DB-API 2.0 Python code.
-
Getting Started with the CData Python Connector for Dropbox
Learn to install and license the CData Python Connector
-
A PostgreSQL Interface for LinkedIn Data using the CData ODBC Driver
Use the SQL Gateway and LinkedIn ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Zoho Creator Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Zoho Creator.
-
How to connect to Adobe Commerce Data from IntelliJ
Integrate connectivity to Adobe Commerce with wizards in IntelliJ.
-
How to Connect DBeaver to Mailgun via a JDBC Driver
Manage Mailgun with visual tools in DBeaver like the query browser.
-
Moving Data from Guru to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Guru data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Azure Data Lake Storage Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure Data Lake Storage in SnapLogic.
-
Integrating SAP ByDesign Data in Talend Cloud Data Management Platform
Connect SAP ByDesign Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP ByDesign.
-
Use ChatGPT to Talk to Your SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Business ByDesign for you.
-
Integrate Sentry Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sentry from Informatica Cloud.
-
Back Up Microsoft Dynamics NAV to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics NAV. In this article, we will employ an SSIS workflow to populate a database with Microsoft Dynamics NAV data.
-
Use Azure AI Foundry to Talk to Your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Zoho CRM for you.
-
Build a Singer.io Tap for ServiceNow With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ServiceNow data using
-
Integrate with Hive Data in JReport Designer
Create charts and reports based on Apache Hive in JReport Designer.
-
Integrate Klipfolio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Klipfolio with External Services.
-
Connect to Pushbullet Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pushbullet as an External Source in Dremio.
-
Connect to Presto Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Presto from Filemaker Pro on Mac.
-
How to Build an ETL App for SendGrid Data in Python with CData
Create ETL applications and real-time data pipelines for SendGrid in Python with petl.
-
Visualize Live CockroachDB Data in the Power BI Service
Use CData Connect AI to connect to live CockroachDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Sage Cloud Accounting Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to delimited files (CSV/TSV).