CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Python Connector for ConstantContact
Learn to install and license the CData Python Connector
-
Enable the Microsoft OneDrive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft OneDrive.
-
Connect and Query Live MariaDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MariaDB into Databricks
-
Connect to Access in SpagoBI
Create reports featuring live Microsoft Access in SpagoBI Studio. Host Access reports on SpagoBI Server.
-
Automate Confluence Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Atlassian Confluence and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Oracle HCM Cloud in Aqua Data Studio
Access Oracle HCM Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Data Visualizations Based On Google Directory in Mode
Use CData Connect AI to connect to Google Directory from Mode and build visualizations using live
-
Enable the QuickBooks Online JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with QuickBooks Online.
-
Connect to Jira in RazorSQL
Connect to Jira from wizards and query Atlassian Jira from the GUI in the RazorSQL database management tool.
-
Integrate Sage 200 in Pentaho Data Integration
Build ETL pipelines based on Sage 200 in the Pentaho Data Integration tool.
-
Build Data Flows from Okta to SQL Server using SSIS
Easily back up Okta to SQL Server using the SSIS components for Okta.
-
Automated Continuous SAP Ariba Source Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Azure SQL Database.
-
Access Live QuickBooks Time in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate QuickBooks Time into the statistical analysis tools available in SAS JMP. This article shows how to use QuickBooks Time in the Graph Builder and Query Builder.
-
Choosing the Best Method to Connect Impala to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Impala from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to CSV as an External Source in Dremio
Use the CData JDBC Driver to connect to CSV as an External Source in Dremio.
-
Connect to Airtable 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 Airtable.
-
Access Microsoft Project as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Project from your Oracle system.
-
Automated Continuous Excel Replication to MySQL
Use CData Sync for automated, continuous, customizable Excel replication to MySQL.
-
Connect and Query Live CockroachDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live CockroachDB into Databricks
-
Publish Jira-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Atlassian Jira.
-
Getting Started with the CData Excel Add-In for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesforce Marketing.
-
Connect to Microsoft Project in ACL Analytics
Connect to Microsoft Project via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Project.
-
Edit and Search External PostgreSQL Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of PostgreSQL to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PostgreSQL objects that you can access from apps and the dashboard.
-
Natively Connect to Redis in PHP
The CData ODBC driver for Redis enables you to create PHP applications with connectivity to Redis. Leverage the native support for ODBC in PHP.
-
Manage Zoho Inventory in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Inventory.
-
Easily Integrate Confluence in Lazarus Pascal IDE
Learn how to easily integrate live Atlassian Confluence in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Microsoft Teams Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Databricks.
-
Building Dynamic Web Pages with Amazon S3 Using AngularJS
Create single-page applications with live connectivity to Amazon S3 using the CData API Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Smartsheet
Provide connectivity to Smartsheet through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for HarperDB in Microsoft Power Query
You can use the CData HarperDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HarperDB into Microsoft Power Query.
-
Bidirectional Access to TigerGraph from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate TigerGraph in Filemaker Pro for Mac or Windows.
-
Analyze ShipStation in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ShipStation in Microsoft R Open.
-
Add Coinbase to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Coinbase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Google Calendar in Pentaho Data Integration
Build ETL pipelines based on Google Calendar in the Pentaho Data Integration tool.
-
Use Biml to Build SSIS Tasks to Replicate Couchbase to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Couchbase to SQL Server.
-
Automated Continuous SAP Ariba Source Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Databricks.
-
Access Live QuickBooks Time in AWS Lambda
Connect to live QuickBooks Time in AWS Lambda using the CData JDBC Driver.
-
Model Adobe Analytics Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Adobe Analytics, enabling the direct import of real-time Adobe Analytics.
-
Import Shippo into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Shippo. In this article, you will use the OData format to import Shippo into Microsoft Power Query.
-
Sybase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sybase facts in real time.
-
Build Avalara AvaTax-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Avalara AvaTax.
-
Build Data Flows from Greenhouse to SQL Server using SSIS
Easily back up Greenhouse to SQL Server using the SSIS components for Greenhouse.
-
How to connect to Cloudant from Spring Boot
Connect to Cloudant in a Spring Boot Application using CData JDBC Cloudant Driver
-
Building Dynamic Web Pages with FHIR Using AngularJS
Create single-page applications with live connectivity to FHIR using the CData API Server.
-
Load Calendly to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Calendly to a database.
-
Choosing the Best Method to Connect Email to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Email from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Kintone 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 Kintone.
-
How to use SQLAlchemy ORM to access Google Spanner in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Spanner.
-
Access Live Bullhorn CRM in AWS Lambda
Connect to live Bullhorn CRM in AWS Lambda using the CData JDBC Driver.
-
Build Data Flows from SQL Server to ADP through SSIS
Easily push SQL Server data to ADP using the CData SSIS Tasks for ADP.
-
Import Square into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Square. In this article, you will use the OData format to import Square into Microsoft Power Query.
-
Automate YouTube Analytics Replication to SAP HANA
Use CData Sync to customize and automate YouTube Analytics replication to SAP HANA.
-
Rapidly Develop Salesforce Pardot-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Snapchat Ads
Provide connectivity to Snapchat Ads through an SAP BusinessObjects universe.
-
How to load WooCommerce data into Elasticsearch via Logstash
Introducing a simple method to load WooCommerce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Oracle SCM in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle SCM in Google Apps Script.
-
Use JayDeBeApi to access BambooHR in Python
Use standard Python scripting and the development environment of your choice to access live BambooHR.
-
Analyze Klipfolio in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Klipfolio in Microsoft R Open.
-
Design BIRT Reports on Snowflake
Provide current Snowflake to your embedded analytics.
-
Automated Continuous Procore Replication to Snowflake
Use CData Sync for automated, continuous, customizable Procore replication to Snowflake.
-
Build Semantic Layer Views for Sage Intacct in APOS Live Data Gateway
Use the CData Connector for Sage Intacct in APOS Live Data Gateway to build Semantic Layer Views for Sage Intacct.
-
Automated Continuous Spark Replication to SQL Server
Use CData Sync for automated, continuous, customizable Spark replication to SQL Server.
-
How to Seamlessly Import MYOB AccountRight Data into IBM SPSS Modeler
Integrate MYOB AccountRight data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live Confluence into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Confluence from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Atlassian Confluence.
-
Access Live Kintone in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Kintone from your Google Sheets.
-
Getting Started with the CData PowerShell Cmdlets for Pinterest
-