CData Software - Knowledge Base
Recent Articles
-
How to Work with Greenplum in ETL Validator JDBC
Connect to Greenplum from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData JDBC Driver for Marketo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Marketo.
-
Build Dashboards with Hive in DBxtra
Create dynamic dashboards and perform analytics based on Apache Hive in DBxtra.
-
Create Data Visualizations in Cognos BI with JotForm
Access JotForm as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Hive into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Hive. In this article, you will use the OData format to import Apache Hive into Microsoft Power Query.
-
Visualize Live Google Spanner in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Spanner into custom reports in Power BI.
-
How to work with Stripe in Apache Spark using SQL
Access and process Stripe in Apache Spark using the CData Software JDBC Driver.
-
Create ActiveCampaign Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Printify in NetBeans
Connect to Printify in NetBeans with the data source configuration wizard.
-
Build Charts with Salesforce Pardot in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce Pardot in Clear Analytics.
-
Configure the CData JDBC Driver for Jira in a Connection Pool in Tomcat
Connect to Atlassian Jira from a connection pool in Tomcat.
-
Automated Continuous Pipedrive Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pipedrive replication to Apache Kafka.
-
DataBind Controls to Oracle SCM in C++Builder
DataBind to Oracle SCM in C++Builder with standard components and controls.
-
Access Live Salesforce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automate Amazon Athena Replication to Azure Synapse
Use CData Sync to customize and automate Amazon Athena replication to Azure Synapse.
-
Work with GitHub in FoxPro
Load GitHub into a FoxPro database. This article includes full code and a walk-through of the process.
-
Explore Geographical Relationships in SAP SuccessFactors with Power Map
Create data visualizations with SAP SuccessFactors in Power Map.
-
Model, Search, and Visualize Live BigQuery in ThoughtSpot
Use CData Connect AI to connect to live Google BigQuery for modeling, searching, and visualizing.
-
Add Avalara AvaTax to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Avalara AvaTax with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to load Power BI XMLA data into Elasticsearch via Logstash
Introducing a simple method to load Power BI XMLA data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Printful in DBArtisan
Use wizards in DBArtisan to configure Printful as a data source.
-
Automate Microsoft Planner Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Planner from PowerShell? This article demonstrates how to utilize the Microsoft Planner Cmdlets for tasks like connecting to Microsoft Planner, automating operations, downloading data, and more.
-
Build Dynamics 365 Business Central-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Dynamics 365 Business Central.
-
Build Zoom-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoom and build web apps with connectivity to live Zoom.
-
Build Dashboards with LinkedIn in DBxtra
Create dynamic dashboards and perform analytics based on LinkedIn in DBxtra.
-
How to Connect to Live Trello in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Trello for you.
-
DataBind Controls to Certinia in Delphi
DataBind to Certinia in Delphi with standard data access components and controls.
-
Use the CData Software JDBC Driver for Oracle in MicroStrategy
Connect to Oracle Database in MicroStrategy Developer using the CData Software JDBC Driver for Oracle.
-
Publish Reports with XML in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date XML Files.
-
Connect to Spark from a Connection Pool in JBoss
Integrate Apache Spark SQL into Java servlets: Use the Management Console in JBoss to install the Spark JDBC Driver.
-
How to Connect DBeaver to SAS xpt via a JDBC Driver
Manage SAS XPORT with visual tools in DBeaver like the query browser.
-
Connect to MariaDB from PowerBuilder via JDBC
This article demonstrates how to access MariaDB from PowerBuilder using the MariaDB JDBC Driver.
-
Import Real-Time Snowflake via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Snowflake in ColdFusion.
-
Getting Started with the CData Python Connector for MYOB AccountRight
Learn to install and license the CData Python Connector
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sage Intacct to Power BI dashboards. Simply drag and drop Sage Intacct into data visuals on the Power BI canvas.
-
Automate Dynamics NAV Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Dynamics NAV replication to Azure Synapse.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Amazon DynamoDB to Power BI dashboards. Simply drag and drop Amazon DynamoDB into data visuals on the Power BI canvas.
-
Automated Continuous Parquet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Parquet replication to Apache Cassandra.
-
Work with Google Calendar in FoxPro
Load Google Calendar into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to & Open Google Cloud Storage in Microsoft Excel
This article uses the CData ODBC driver for Google Cloud Storage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Back Up Salesforce Pardot to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce Pardot. In this article, we will employ an SSIS workflow to populate a database with Salesforce Pardot data.
-
Analyze SQL Analysis Services in Infragistics Reveal
Use the CData API Server to create an OData API on top of SQL Analysis Services and visualize live SQL Analysis Services in Infragistics Reveal.
-
Access Live OneNote in AWS Lambda
Connect to live Microsoft OneNote in AWS Lambda using the CData JDBC Driver.
-
Edit and Search External ShipStation Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ShipStation to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ShipStation objects that you can access from apps and the dashboard.
-
Integrate Cassandra with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cassandra with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Cassandra.
-
Design BIRT Reports on Redshift
Provide current Amazon Redshift to your embedded analytics.
-
MongoDB Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MongoDB through CData Connect AI using different applications and tools.
-
Create a Data Access Object for Snowflake using JDBI
A brief overview of creating a SQL Object API for Snowflake in JDBI.
-
Create Reports from Paylocity in Looker Studio
Use CData Connect AI to gain access to live Paylocity and create custom reports in Looker Studio.
-
Automated Continuous Azure Data Lake Storage Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to OneLake in Microsoft Fabric.
-
Creating SAP SuccessFactors-Connected Applications in Unqork
You can use CData Connect AI to feed SAP SuccessFactors to Unqork and build custom business apps.
-
Visualize Oracle Eloqua in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle Eloqua into TIBCO Spotfire.
-
Automated Continuous Certinia Replication to MongoDB
Use CData Sync for automated, continuous, customizable Certinia replication to MongoDB.
-
How to Build an ETL App for Vault CRM in Python with CData
Create ETL applications and real-time data pipelines for Veeva Vault & Vault CRM in Python with petl.
-
Access Live Cosmos DB in TIBCO Data Virtualization
-