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
-
Use the CData Software JDBC Driver for Redis in MicroStrategy Desktop
Connect to Redis in MicroStrategy Desktop using the CData Software JDBC Driver for Redis.
-
Analyze Live Bing Search Results in SAS Viya
Use CData Connect Cloud to connect to Bing Search from SAS Viya and deploy self-service analytics using live Bing Search.
-
Integrate Twitter Ads in the Pentaho Report Designer
Publish reports based on Twitter Ads in the Pentaho BI tool.
-
Write a Simple Go Application to work with Drip on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Drip.
-
Enable the MarkLogic JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MarkLogic.
-
Publish Smartsheet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Smartsheet.
-
Analyze Zoho Creator in Cognos Analytics
Use CData Connect Cloud to connect to Zoho Creator from Cognos Analytics and analyze live Zoho Creator.
-
Automated Continuous eBay Replication to Oracle
Use CData Sync for automated, continuous, customizable eBay replication to Oracle.
-
Analyze Freshdesk with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Freshdesk from Power Pivot. You will use the Table Import Wizard to load Freshdesk. You can visually build the import query or use any SQL supported by the driver.
-
Replicate SAP BusinessObjects BI for Use in Salesforce Connect
Replicate SAP BusinessObjects BI to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
ETL QuickBooks Time in Oracle Data Integrator
This article shows how to transfer QuickBooks Time into a data warehouse using Oracle Data Integrator.
-
How to Import HubSpot into SQL Server using SSIS
Easily back up HubSpot to SQL Server using the SSIS components for HubSpot.
-
How to Connect to Zoho Inventory in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Inventory. Leverage the pyodbc module for ODBC in Python.
-
Operational Reporting on Trello from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Trello.
-
Use Biml to Build SSIS Tasks to Replicate SAS Data Sets to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAS Data Sets to SQL Server.
-
Visualize LDAP Objects from Tableau
Use the Tableau Desktop business intelligence tool to connect to LDAP.
-
Feed Amazon S3 into FineReport
How to set Amazon S3 as a JDBC data source in FineReport.
-
DataBind Jira Assets to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Jira Assets with the DevExpress Windows Forms and Web controls to provide Jira Assets to a chart.
-
Visualize Live ADP of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ADP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
LINQ to Quickbase
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Quickbase Data Provider.
-
Back Up SFTP to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SFTP. In this article, we will employ an SSIS workflow to populate a database with SFTP data.
-
Build Google Search-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Search and build web apps with connectivity to live Google Search.
-
Build Apps with Live Workday in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Workday into the Adalo platform and build custom mobile and web applications with real-time Workday.
-
Using AngularJS to Build Dynamic Web Pages with Amazon Athena
Use the CData Connect Server to create Amazon Athena OData feeds and build single-page applications with live Amazon Athena.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Data Catalog
Provide connectivity to Azure Data Catalog through an SAP BusinessObjects universe.
-
How to integrate Wave Financial with Apache Airflow
Access and process Wave Financial in Apache Airflow using the CData JDBC Driver.
-
Connect to Google Calendar from PowerBuilder
This article demonstrates how to access Google Calendar from Appeon PowerBuilder using the CData ADO.NET Provider for Google Calendar.
-
Connect to Veeva in Jaspersoft Studio
Execute SQL to remote Veeva Vault in Jaspersoft Studio.
-
Back Up Azure Data Lake Storage to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Data Lake Storage. In this article, we will employ an SSIS workflow to populate a database with Azure Data Lake Storage data.
-
Connect to Neo4J in RunMyProcess through Connect Server
Use CData Connect Server to create an OData API for Neo4J and connect to Neo4J in Akorbi Digital RunMyProcess.
-
PowerShell Scripting to Replicate FTP to MySQL
Write a simple PowerShell script to replicate FTP Servers to a MySQL database.
-
Use the Connect Server to Access Kafka in Microsoft Power Pivot
Use the Connect Server to connect to live Apache Kafka in the Power Pivot business intelligence tool.
-
Build Visualizations of Dynamics CRM in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Dynamics CRM in Birst.
-
Create Amazon Athena-Connected Business Apps in AppSheet
Connect to Amazon Athena via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Amazon Athena.
-
Automate Amazon DynamoDB Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon DynamoDB replication to Azure Data Lake.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy
Connect to Google Calendar in MicroStrategy Developer using the CData Software JDBC Driver for Google Calendar.
-
Import Real-Time Azure Active Directory in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Active Directory in ColdFusion.
-
Prepare, Blend, and Analyze Sage 200 in Alteryx Designer
Build workflows to access live Sage 200 for self-service data analytics.
-
Model Google Calendar Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Google Calendar, enabling the direct import of real-time Google Calendar.
-
Visualize Live Sybase IQ in the Power BI Service
Use CData Software Connect Server to create a virtual SQL Server database for Sybase IQ and create custom reports in the Power BI Service.
-
Visualize Confluence in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Atlassian Confluence into TIBCO Spotfire.
-
How to Connect DBeaver to MailChimp via a JDBC Driver
Manage MailChimp with visual tools in DBeaver like the query browser.
-
A PostgreSQL Interface for Oracle Eloqua
Use the Remoting features of the Oracle Eloqua ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect and process Avro from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Avro
-
Access Live Box in Coginiti Pro
Connect to and query live Box from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Bridge Square Connectivity with Apache NiFi
Access and process Square in Apache NiFi using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Square
Access Square as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to integrate Metabase with BigQuery
Use CData Connect Cloud to connect to live Google BigQuery and create an interactive dashboard in Metabase from Google BigQuery.
-
Explore Geographical Relationships in Klaviyo with Power Map
Create data visualizations with Klaviyo in Power Map.
-
How to Connect to ClickUp in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ClickUp. Leverage the pyodbc module for ODBC in Python.
-
Using the CData Software ODBC Driver for QuickBooks Time in PyCharm
Connect to QuickBooks Time as an ODBC data source in PyCharm using the CData Software ODBC Driver for QuickBooks Time.
-
Access Live Google Calendar in Google Sheets
Use CData Connect Cloud to gain access to live Google Calendar from your Google Sheets.
-
Use JayDeBeApi to access IBM Cloud Data Engine in Python
Use standard Python scripting and the development environment of your choice to access live IBM Cloud Data Engine.
-
Use the CData Software ODBC Driver for Cassandra in MicroStrategy Desktop
Connect to Apache Cassandra in MicroStrategy Desktop using the CData Software ODBC Driver for Cassandra.
-
How to Connect to Microsoft Teams in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Teams. Leverage the pyodbc module for ODBC in Python.
-
Connect to Stripe as an External Source in Dremio
Use the CData JDBC Driver to connect to Stripe as an External Source in Dremio.
-
Connect to QuickBooks Time as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live QuickBooks Time.
-
How to connect and process HarperDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HarperDB
-
How to use SQLAlchemy ORM to access Jira in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Atlassian Jira.
-
Deploy the ADO.NET Provider for Basecamp on an SSRS Report Server
Connect to Basecamp 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.
-
Automated Continuous CockroachDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable CockroachDB replication to Snowflake.
-
Build Dashboards with Blackbaud FE NXT in DBxtra
Create dynamic dashboards and perform analytics based on Blackbaud FE NXT in DBxtra.
-
Connect to Snapchat Ads in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Act-On in DBArtisan
Use wizards in DBArtisan to configure Act-On as a data source.
-
Analyze HDFS in R
Create data visualizations and use high-performance statistical functions to analyze Apache HDFS in Microsoft R Open.
-
Access Live Sage Cloud Accounting in Excel (Desktop)
Use CData Connect Cloud to gain access to live Sage Business Cloud Accounting from your Excel spreadsheets.
-
Use the CData Software JDBC Driver for Raisers Edge NXT in MicroStrategy Web
Connect to Raisers Edge NXT in MicroStrategy Web using the CData Software JDBC Driver for Raisers Edge NXT.
-
Build Cloudant-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Cloudant and create custom apps in Bubble.
-
Bridge Shopify Connectivity with Apache NiFi
Access and process Shopify in Apache NiFi using the CData JDBC Driver.
-
Automate IBM Cloud Data Engine Replication to SAP HANA
Use CData Sync to customize and automate IBM Cloud Data Engine replication to SAP HANA.
-
Integrating Raisers Edge NXT in Talend Cloud Data Management Platform
-