Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →CData Software - Knowledge Base
Recent Articles
-
How to connect to Neo4J from IntelliJ
Integrate connectivity to Neo4J with wizards in IntelliJ.
-
Use Dash to Build to Web Apps on Square
Create Python applications that use pandas and Dash to build Square-connected web apps.
-
Use Dash to Build to Web Apps on Dynamics CRM
Create Python applications that use pandas and Dash to build Dynamics CRM-connected web apps.
-
Connect to and Visualize Live Cassandra in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Cassandra.
-
Access Kintone from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Kintone from HeidiSQL.
-
Stream SAP HANA XS Advanced into Apache Kafka Topics
Access and stream SAP HANA XS Advanced in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Work with JotForm in FoxPro
Load JotForm into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize SAP Business One in Sisense
Create an ElastiCube in Sisense app with access to SAP Business One.
-
How to Query Live Oracle SCM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle SCM data in natural language using Python.
-
Automated Continuous Workday Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Workday replication to Apache Cassandra.
-
Publish Box-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Box.
-
Author and Share Power BI Reports on Real-Time Google Directory
Use the CData ODBC Driver for Google Directory to visualize Google Directory in Power BI Desktop and then upload to the Power BI service.
-
Using AngularJS to Build Dynamic Web Pages with Zenefits
Use the CData Connect Server to create Zenefits OData feeds and build single-page applications with live Zenefits.
-
Build Klipfolio Visualizations in Tableau Cloud
Use CData Software Connect Server to create a virtual SQL Server Database for Klipfolio and build visualizations in Tableau Cloud.
-
Connect to Zoho Projects in Aqua Data Studio
Access Zoho Projects from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Amazon DynamoDB in SpagoBI
Create reports featuring live Amazon DynamoDB in SpagoBI Studio. Host Amazon DynamoDB reports on SpagoBI Server.
-
Use the CData Software JDBC Driver for SAS xpt in MicroStrategy Desktop
Connect to SAS XPORT in MicroStrategy Desktop using the CData Software JDBC Driver for SAS xpt.
-
DataBind Wijmo Grid to Google Cloud Storage
Provide real-time Google Cloud Storage to interactive controls.
-
Visualize Live Amazon Athena of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon Athena using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Enable the Hive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Hive.
-
How to work with Printful in Apache Spark using SQL
Access and process Printful in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live Tableau CRM Analytics in the Power BI Service
Use CData Connect Cloud to connect to live Tableau CRM Analytics and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Dynamics GP Replication to MongoDB
Use CData Sync for automated, continuous, customizable Dynamics GP replication to MongoDB.
-
Create Data Visualizations in Cognos BI with Exact Online
Access Exact Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Reports with Adobe Commerce in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Commerce.
-
Load Monday.com to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Monday.com to a database.
-
How to connect to Xero from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Xero and work with Xero Accounting in Microsoft Excel on Mac OS X.
-
Use Biml to Build SSIS Tasks to Replicate IBM Cloud Object Storage to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM Cloud Object Storage to SQL Server.
-
Analyze GraphQL in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of GraphQL and visualize GraphQL in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Tally in MicroStrategy Web
Connect to Tally ERP in MicroStrategy Web using the CData Software ODBC Driver for Tally.
-
Connect to FHIR from a Connection Pool in Jetty
The FHIR JDBC Driver supports connection pooling: This article shows how to connect faster to FHIR from Web apps in Jetty.
-
Build Visualizations of SAS xpt in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAS XPORT in Birst.
-
Operational Reporting on SuiteCRM from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SuiteCRM.
-
How to integrate Couchbase with Apache Airflow
Access and process Couchbase in Apache Airflow using the CData JDBC Driver.
-
Author and Share Power BI Reports on Real-Time Access
Use the CData ODBC Driver for Access to visualize Microsoft Access in Power BI Desktop and then upload to the Power BI service.
-
Connect to SAP Ariba Source from PowerBuilder
This article demonstrates how to access SAP Ariba Source from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Ariba Source.
-
Create Shippo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Shippo data access from reports, embedded analytics, and more.
-
Use the CData ODBC Driver for DB2 in Microsoft Power Query
You can use the CData DB2 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM DB2 into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time Spark
Use CData Power BI Connectors to visualize Apache Spark SQL in Power BI.
-
Connect to Zoho Projects in Jaspersoft Studio
Execute SQL to remote Zoho Projects in Jaspersoft Studio.
-
Use the CData ODBC Driver for TigerGraph in SAS JMP
You can use the CData ODBC Driver to integrate TigerGraph into the statistical analysis tools available in SAS JMP. This article shows how to use TigerGraph in the Graph Builder and Query Builder.
-
A PostgreSQL Interface for SAP BusinessObjects BI
Use the Remoting features of the SAP BusinessObjects BI ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live OData Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live OData data in natural language using Python.
-
Create SSAS Tabular Models from Greenplum
How to build a SQL Server Analysis Service Tabular Model from Pivotal GreenPlum using CData drivers.
-
How to connect to Amazon Athena from IntelliJ
Integrate connectivity to Amazon Athena with wizards in IntelliJ.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Highrise
Provide connectivity to Highrise CRM through an SAP BusinessObjects universe.
-
Integrate with Invoiced using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Invoiced to a JSON file on disk.
-
Connect to Bing Search Results from HeidiSQL
Use CData Connect Cloud to connect to and query live Bing Search from HeidiSQL.
-
Access Live Airtable in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Airtable to create a Airtable source in TIBCO Data Virtualization Studio and gain access to live Airtable from your TDV Server.
-
Query Amazon DynamoDB in DataGrip
Create a Data Source for Amazon DynamoDB in DataGrip and use SQL to query live Amazon DynamoDB.
-
Integrate Twitter into Power Automate Desktop using CData Connect
CData Connect for Twitter enables you to integrate Twitter into workflows built using Microsoft Power Automate Desktop.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP SuccessFactors
Provide connectivity to SAP SuccessFactors through an SAP BusinessObjects universe.
-
Automated Continuous Drift Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Drift replication to Apache Cassandra.
-
Query OData Services in MySQL Workbench
Create a virtual MySQL database for OData in CData Software Connect (or Connect Server) and work with live OData in MySQL Workbench.
-
Connect to Raisers Edge NXT in SpagoBI
Create reports featuring live Raisers Edge NXT in SpagoBI Studio. Host Raisers Edge NXT reports on SpagoBI Server.
-
How to load Phoenix data into Elasticsearch via Logstash
Introducing a simple method to load Phoenix data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build HarperDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HarperDB.
-
Build Hive-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Hive and create custom apps in Mendix.
-
Create Datasets from Exact Online in Domo Workbench and Build Visualizations of Exact Online in Domo
Use the CData Software ODBC Driver for Exact Online to create datasets from Exact Online in Domo Workbench and then build visualizations in the Domo service.
-
How to publish and share Greenhouse dashboards with Tableau Server
The CData ODBC driver for Greenhouse enables you integrate Greenhouse into Tableau dashboards.
-
Create Dynamic SAS Data Sets Grids Using the Infragistics XamDataGrid
Learn how you can connect SAS Data Sets to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Quickbase in DBeaver
Use the CData ODBC Driver to connect to Quickbase in DBeaver.
-
Create Reports with Sage Intacct in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage Intacct.
-
How to Connect the Power BI Service to HubSpot: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to integrate Marketo with Apache Airflow
Access and process Marketo in Apache Airflow using the CData JDBC Driver.
-
Working with Email in LINQPad
Execute LINQ queries to Email in LINQPad.
-
Automated Continuous eBay Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable eBay Analytics replication to PostgreSQL.
-
Automated Continuous MariaDB Replication to Azure SQL
Use CData Sync for automated, continuous, customizable MariaDB replication to Azure SQL.
-
Build Semantic Layer Views for SAS Data Sets in APOS Live Data Gateway
Use the CData Connector for SAS Data Sets in APOS Live Data Gateway to build Semantic Layer Views for SAS Data Sets.
-
How to create MySQL federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MySQL in MySQL .
-
Automated Continuous MySQL Replication to Vertica
Use CData Sync for automated, continuous, customizable MySQL replication to Vertica.
-
Connect to Authorize.Net from a Connection Pool in WebLogic
Use the CData JDBC Driver for Authorize.Net to connect to Authorize.Net from Web applications running on WebLogic.
-
Connect to Slack from a Connection Pool in JBoss
Integrate Slack into Java servlets: Use the Management Console in JBoss to install the Slack JDBC Driver.
-
How to create Visio diagrams from Pipedrive
Automatically update Pipedrive with the changes you make to Visio master shapes.
-
How to Work with Amazon DynamoDB in ETL Validator JDBC
Connect to Amazon DynamoDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Oracle Financials Cloud in R
Use standard R functions and the development environment of your choice to analyze Oracle Financials Cloud with the CData JDBC Driver for Oracle Financials Cloud.
-
Use the CData ODBC Driver for Sage 200 in Microsoft Power Query
You can use the CData Sage 200 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage 200 into Microsoft Power Query.
-
Use the CData Software JDBC Driver for ActiveCampaign in MicroStrategy Web
Connect to ActiveCampaign in MicroStrategy Web using the CData Software JDBC Driver for ActiveCampaign.
-
How to Use a Microsoft Access Database to Update WooCommerce in Real Time
Update WooCommerce data by creating a linked table in Microsoft Access with the CData WooCommerce ODBC Driver.
-
Access Avro from MySQL in PHP
Connect to Avro through the standard MySQL libraries in PHP.
-
Visualize Live Azure Table in the Power BI Service
Use CData Connect Cloud to connect to live Azure Table Storage and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Exact Online in MicroStrategy Web
Connect to Exact Online in MicroStrategy Web using the CData Software JDBC Driver for Exact Online.
-
Integrate with SQL Analysis Services using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SQL Analysis Services to a JSON file on disk.
-
Connect to CSV in as an External Source in Dremio
Use the CData JDBC Driver to connect to CSV as an External Source in Dremio.
-
Connect to Excel Online in CloverDX (formerly CloverETL)
Transfer Microsoft Excel Online using the visual workflow in the CloverDX data integration tool.
-
Build Semantic Layer Views for Google Directory in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Google Directory.
-
Access Live Confluence in AWS Lambda
Connect to live Atlassian Confluence in AWS Lambda using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Reckon
Access Reckon as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import and Visualize WooCommerce in Power View
Create data visualizations based on WooCommerce in Excel.
-
How to Work with Microsoft Project in AWS Glue Jobs Using JDBC
Connect to Microsoft Project from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
SSIS Components Getting Started Guide
A basic guide to using the CData SSIS Components for Salesforce to transfer data into a MS SQL Server database.
-
Connect to Jira Assets in DBArtisan
Use wizards in DBArtisan to configure Jira Assets as a data source.
-
Connect to Slack in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Automated YouTube Analytics-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live YouTube Analytics and build automated workflows in Zapier.
-
Build Automated Workflows with Live NetSuite in Workato
Use CData Connect Cloud to connect to live NetSuite CRM & ERP and build automated workflows in Workato.
-
How to Query Live SAS xpt Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAS XPORT data in natural language using Python.
-
Create Data Visualizations in Cognos BI with TaxJar
Access TaxJar as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Stream xBase into Apache Kafka Topics
Access and stream xBase in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Work with Sugar CRM in FoxPro
Load Sugar CRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access QuickBooks Time from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live QuickBooks Time from HeidiSQL.