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
-
Automated Continuous Adobe Commerce Replication to MongoDB
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to MongoDB.
-
Connect to Live IBM Informix in MicroStrategy through CData Connect Cloud
Create a live connection to IBM Informix in CData Connect Cloud and connect to your IBM Informix from MicroStrategy.
-
Connect to QuickBooks in Jaspersoft Studio
Execute SQL to remote QuickBooks Desktop in Jaspersoft Studio.
-
Automate SuiteCRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SuiteCRM from PowerShell? This article demonstrates how to utilize the SuiteCRM Cmdlets for tasks like connecting to SuiteCRM, automating operations, downloading data, and more.
-
Automate Email Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Email from PowerShell? This article demonstrates how to utilize the Email Cmdlets for tasks like connecting to Email, automating operations, downloading data, and more.
-
Connect to Jira from PowerBuilder
This article demonstrates how to access Atlassian Jira from PowerBuilder using the Jira JDBC Driver.
-
Create Presto-Connected Nintex Workflows
Use CData Connect Cloud to connect to Presto from Nintex Workflow Cloud and build custom workflows using live Presto.
-
Integrate Live Spark into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Spark from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apache Spark SQL.
-
Connect to Google Directory 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 Google Directory.
-
How to publish and share Sage Cloud Accounting dashboards with Tableau Server
The CData ODBC driver for Sage Cloud Accounting enables you integrate Sage Business Cloud Accounting into Tableau dashboards.
-
DataBind Wijmo Grid to Couchbase
Provide real-time Couchbase to interactive controls.
-
Replicate Google Calendar from PowerShell
Write a quick PowerShell script to query Google Calendar. Use connectivity to the live data to replicate Google Calendar to SQL Server.
-
Build Automated Google Search-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Google Search and build automated workflows in Zapier.
-
Visualize Stripe in Tableau
The CData ODBC driver for Stripe enables you integrate Stripe into Tableau dashboards.
-
Automated Continuous ConstantContact Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ConstantContact replication to Apache Cassandra.
-
DataBind Typeform to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Typeform with the DevExpress Windows Forms and Web controls to provide Typeform to a chart.
-
Query, Visualize, and Share live Impala in Redash
Use CData Connect Cloud to connect to live Apache Impala in Redash for querying, visualizing, and sharing.
-
Prepare, Blend, and Analyze Sage 200 in Alteryx Designer
Build workflows to access live Sage 200 for self-service data analytics.
-
Build Dashboards with ConstantContact in DBxtra
Create dynamic dashboards and perform analytics based on ConstantContact in DBxtra.
-
How to connect PolyBase to SAP Concur
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Concur.
-
Access Cassandra from MySQL in PHP
Connect to Cassandra through the standard MySQL libraries in PHP.
-
View Reports on Real-Time Gmail in Power BI Report Server
Use the CData ODBC Driver for Gmail to visualize Gmail in Power BI Desktop and then publish them to Power BI Report Server.
-
Choosing the Best Method to Connect SAP Concur to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Concur from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Creating Clio-Connected Applications in Unqork
You can use CData Connect to feed Clio to Unqork and build custom business apps.
-
Bridge Azure Data Catalog Connectivity with Apache NiFi
Access and process Azure Data Catalog in Apache NiFi using the CData JDBC Driver.
-
Connect to Live Spark in MicroStrategy through CData Connect Cloud
Create a live connection to Spark in CData Connect Cloud and connect to your Apache Spark SQL from MicroStrategy.
-
How to Connect to Outreach.io in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Outreach.io. Leverage the pyodbc module for ODBC in Python.
-
How to connect to eBay Analytics from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for eBay Analytics and work with eBay Analytics in Microsoft Excel on Mac OS X.
-
Connect to Square from a Connection Pool in Jetty
The Square JDBC Driver supports connection pooling: This article shows how to connect faster to Square from Web apps in Jetty.
-
How to work with PayPal in Apache Spark using SQL
Access and process PayPal in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Shippo in MicroStrategy Web
Connect to Shippo in MicroStrategy Web using the CData Software JDBC Driver for Shippo.
-
Build Azure DevOps-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Azure DevOps and build Azure DevOps-connected web apps with Axios.
-
Stream Certinia into Apache Kafka Topics
Access and stream Certinia in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Avro Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze Authorize.Net with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Authorize.Net from Power Pivot. You will use the Table Import Wizard to load Authorize.Net. You can visually build the import query or use any SQL supported by the driver.
-
Connect to PayPal from HeidiSQL
Use CData Connect Cloud to connect to and query live PayPal from HeidiSQL.
-
Query SAS Data Sets in MySQL Workbench
Create a virtual MySQL database for SAS Data Sets in CData Software Connect (or Connect Server) and work with live SAS Data Sets in MySQL Workbench.
-
Import Coinbase into Microsoft Power Query
The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Coinbase. In this article, you will use the OData format to import Coinbase into Microsoft Power Query.
-
How to work with Twilio in Apache Spark using SQL
Access and process Twilio in Apache Spark using the CData Software JDBC Driver.
-
Query, Visualize, and Share live Azure DevOps in Redash
Use CData Connect Cloud to connect to live Azure DevOps in Redash for querying, visualizing, and sharing.
-
Access Active Directory from MySQL in Amazon QuickSight
Connect to Active Directory and build visualizations of Active Directory using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software ODBC Driver for Google Directory in MicroStrategy Desktop
Connect to Google Directory in MicroStrategy Desktop using the CData Software ODBC Driver for Google Directory.
-
Connect to Elasticsearch from a Connection Pool in JBoss
Integrate Elasticsearch into Java servlets: Use the Management Console in JBoss to install the Elasticsearch JDBC Driver.
-
Build Microsoft Teams-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Microsoft Teams.
-
Connect to SAP Fieldglass from a Connection Pool in JBoss
Integrate SAP Fieldglass into Java servlets: Use the Management Console in JBoss to install the SAP Fieldglass JDBC Driver.
-
Create Outreach.io-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Outreach.io from Klipfolio and build custom visualizations using live Outreach.io.
-
Use the CData ODBC Driver for Greenhouse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Greenhouse to connect to Greenhouse from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Greenhouse in Excel.
-
Feed IBM Cloud Data Engine into FineReport
How to set IBM Cloud Data Engine as a JDBC data source in FineReport.
-
Automated Continuous Acumatica Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Acumatica replication to Google BigQuery.
-
Validate SharePoint Excel Services with QuerySurge
Access and validate SharePoint Excel Services in QuerySurge using the CData JDBC Driver.
-
Access Live Sugar CRM in AWS Lambda (with IntelliJ IDEA)
Connect to live Sugar CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Design BIRT Reports on SurveyMonkey
Provide current SurveyMonkey to your embedded analytics.
-
Integrate with Clio in JReport Designer
Create charts and reports based on Clio in JReport Designer.
-
Create Excel Online Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Excel Online data access from reports, embedded analytics, and more.
-
Replicate Multiple Printify Accounts
Replicate multiple Printify accounts to one or many databases.
-
Stream Dynamics GP into Apache Kafka Topics
Access and stream Microsoft Dynamics GP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zenefits
Provide connectivity to Zenefits through an SAP BusinessObjects universe.
-
Analyze Basecamp with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Basecamp from Power Pivot. You will use the Table Import Wizard to load Basecamp. You can visually build the import query or use any SQL supported by the driver.
-
Natively Connect to SharePoint Excel Services in PHP
Create PHP applications on Linux/UNIX machines with connectivity to SharePoint Excel Services. Leverage the native support for ODBC in PHP.
-
Integrate Real-Time Access to Raisers Edge NXT in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Raisers Edge NXT in real time.
-
ETL Cassandra in Oracle Data Integrator
This article shows how to transfer Apache Cassandra into a data warehouse using Oracle Data Integrator.
-
Connect to Facebook Ads from PowerBuilder
This article demonstrates how to access Facebook Ads from PowerBuilder using the Facebook Ads JDBC Driver.
-
Connect to GitHub in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create SAP HANA XS Advanced-Connected Nintex Workflows
Use CData Software Connect Server to connect to SAP HANA XS Advanced from Nintex Workflow Cloud and build custom workflows using live SAP HANA XS Advanced.
-
Automated Continuous Marketo Replication to Oracle
Use CData Sync for automated, continuous, customizable Marketo replication to Oracle.
-
Integrate with Live Google Search Results in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Google Search from the MuleSoft Anypoint Platform to integrate live Google Search into custom reports and dashboards.
-
Analyze Highrise in R
Create data visualizations and use high-performance statistical functions to analyze Highrise CRM in Microsoft R Open.
-
Add Redshift to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Redshift with the Informatica Enterprise Data Catalog to classify and organize data.
-
Add Salesforce Marketing to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce Marketing with the Informatica Enterprise Data Catalog to classify and organize data.
-
OneNote Reporting in OBIEE with the OneNote JDBC Driver
Deploy the OneNote JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate PostgreSQL Replication to Azure Data Lake
Use CData Sync to customize and automate PostgreSQL replication to Azure Data Lake.
-
Build Google Ad Manager-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for Google Ad Manager and build visualizations and dashbaords from Google Ad Manager in Redash.
-
Connect to Certinia from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for Certinia to connect to Certinia and execute queries in PowerBuilder.
-
Automated Continuous HubSpot Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HubSpot replication to AlloyDB.
-
Connect to Trello in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to and Query Spark in QlikView over ODBC
Create data visualizations with Apache Spark SQL in QlikView.
-
Export Data from SQL Server to Bitbucket through SSIS
Easily push SQL Server data to Bitbucket using the CData SSIS Tasks for Bitbucket.
-
Use the CData Software JDBC Driver for eBay in MicroStrategy Web
Connect to eBay in MicroStrategy Web using the CData Software JDBC Driver for eBay.
-
Process & Analyze Drift in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Drift .
-
Import Salesforce Using Azure Data Factory
Use CData Connect Cloud to connect to Salesforce from Azure Data Factory and import live Salesforce & Force.com.
-
Object-Relational Mapping (ORM) with EventBrite Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Eventbrite into a Java-based ORM framework, Hibernate.
-
How to Create Power BI Visual Reports with Real-Time HarperDB
Use CData Power BI Connectors to visualize HarperDB in Power BI.
-
Use the CData Software JDBC Driver for Oracle Eloqua in MicroStrategy
Connect to Oracle Eloqua in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Eloqua.
-
How to connect to Microsoft OneDrive from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Microsoft OneDrive and work with Microsoft OneDrive in Microsoft Excel on Mac OS X.
-
Object-Relational Mapping (ORM) with Twitter Ads Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Twitter Ads into a Java-based ORM framework, Hibernate.
-
Automated Continuous Google Directory Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Directory replication to Oracle.
-
Connect to Azure Data Lake Storage as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Azure Data Lake Storage.
-
Connect to Zendesk in JRuby
Create a simple JRuby app with access to live Zendesk.
-
Connect to Dynamics CRM in JRuby
Create a simple JRuby app with access to live Microsoft Dynamics CRM.
-
Analyze Blackbaud FE NXT in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Blackbaud FE NXT and visualize live Blackbaud FE NXT in Infragistics Reveal.
-
Integrating Tally in Talend Cloud Data Management Platform
-