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
-
Write a Simple Go Application to work with Sage Intacct on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage Intacct.
-
Bridge SAP Concur Connectivity with Apache NiFi
Access and process SAP Concur in Apache NiFi using the CData JDBC Driver.
-
How to work with Dynamics GP in Apache Spark using SQL
Access and process Dynamics GP in Apache Spark using the CData Software JDBC Driver.
-
Analyze ConstantContact in Infragistics Reveal
Use the CData Connect Server to create an OData API on top of ConstantContact and visualize live ConstantContact in Ingragistics Reveal.
-
Use the CData Software ODBC Driver for WordPress in MicroStrategy
Connect to WordPress in MicroStrategy Developer using the CData Software ODBC Driver for WordPress.
-
Automate Azure Synapse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Synapse from PowerShell? This article demonstrates how to utilize the Azure Synapse Cmdlets for tasks like connecting to Azure Synapse, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To a JDBC Data Source for ClickUp
Create ClickUp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to import Jira Service Management into Apache Solr
Use the CData Software JDBC Driver for Jira Service Management in Data Import Handler and create an automated import of Atlassian Jira Service Management to Apache Solr Enterprise Search platform.
-
Replicate Multiple Todoist Accounts
Replicate multiple Todoist accounts to one or many databases.
-
How to Work with Gmail in ETL Validator JDBC
Connect to Gmail from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Wijmo Grid to Zoho Books
Provide real-time Zoho Books to interactive controls.
-
Access Live Reckon in AWS Lambda (with IntelliJ IDEA)
Connect to live Reckon in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Oracle HCM Cloud in Looker
Use CData Connect Cloud to connect to Oracle HCM Cloud from Looker and build custom apps using live Oracle HCM Cloud.
-
Build Sugar CRM-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Sugar CRM and create custom apps in Mendix.
-
Connect to Odoo in Google Apps Script
Use the ODBC Driver for Odoo and the SQL Gateway to access Odoo ERP from Google Apps Script.
-
Integrate Live Jira into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Jira from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Atlassian Jira.
-
Replicate Multiple Act CRM Accounts
Replicate multiple Act CRM accounts to one or many databases.
-
DataBind Shippo to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Shippo with the DevExpress Windows Forms and Web controls to provide Shippo to a chart.
-
How to update Dynamics GP from Excel
This article explains how to transfer data from Excel to Dynamics GP using the Excel Add-In for Dynamics GP.
-
How to connect to SharePoint Excel Services with Squirrel SQL client
Connect to SharePoint Excel Services and execute queries in the Squirrel SQL Client.
-
How to create an RPA flow for Highrise in UiPath Studio
Use the Highrise ODBC Driver to create workflows that access real-time Highrise CRM without any coding.
-
Build ConstantContact-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for ConstantContact and build visualizations and dashbaords from ConstantContact in Redash.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Data Lake Storage
Provide connectivity to Azure Data Lake Storage through an SAP BusinessObjects universe.
-
Access Live Dynamics CRM in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Dynamics CRM to create a Microsoft Dynamics CRM source in TIBCO Data Virtualization Studio and gain access to live Microsoft Dynamics CRM from your TDV Server.
-
How to Query Procore in MySQL Workbench
Execute MySQL queries against live Procore from MySQL Workbench.
-
Use the CData ODBC Driver for Redis in Microsoft Power Query
You can use the CData Redis ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Redis into Microsoft Power Query.
-
Create Informatica Mappings From/To a JDBC Data Source for Facebook
Create Facebook data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to create Redis federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Redis in MySQL .
-
Visualize Live CockroachDB in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live CockroachDB into custom reports in Power BI.
-
Automated Continuous Salesforce Pardot Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to SingleStore.
-
Connect to WordPress in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for WordPress in Airbyte.
-
Build Microsoft Planner-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Microsoft Planner from Zoho Analytics and import live Microsoft Planner.
-
Connect to Sybase in CloverDX (formerly CloverETL)
Transfer Sybase using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous REST Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable REST replication to Microsoft Access.
-
Import Confluence into the Power BI Service for Visualizations
Use CData Connect Cloud to connect to Confluence and provide access to live Atlassian Confluence for custom reports in the Power BI Service.
-
Replicate Multiple Kintone Accounts
Replicate multiple Kintone accounts to one or many databases.
-
Automated Continuous Raisers Edge NXT Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Google BigQuery.
-
Connect to Sugar CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sugar CRM to connect to Sugar CRM from Web applications running on WebLogic.
-
How to update Redshift from Excel
This article explains how to transfer data from Excel to Redshift using the Excel Add-In for Redshift.
-
Build Dashboards with AlloyDB in Dundas BI
Create dynamic dashboards and perform analytics based on Google AlloyDB in Dundas BI.
-
Automated Continuous Odoo Replication to Oracle
Use CData Sync for automated, continuous, customizable Odoo replication to Oracle.
-
Replicate Multiple SharePoint Excel Services Accounts
Replicate multiple SharePoint Excel Services accounts to one or many databases.
-
How to Execute Stored Procedures with the CData BizTalk Adapter for Salesforce
You can use stored procedures provided by the CData BizTalk Adapter for Salesforce to automate working with Salesforce data in BizTalk. Stored procedures implement actions available in the underlying API.
-
Back Up MySQL to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MySQL. In this article, we will employ an SSIS workflow to populate a database with MySQL data.
-
How to Build an ETL App for Sage Intacct in Python with CData
Create ETL applications and real-time data pipelines for Sage Intacct in Python with petl.
-
LINQ to Confluence
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 Confluence Data Provider.
-
Connect to WordPress in RapidMiner
Integrate WordPress with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Create Power BI Visual Reports with Real-Time Access
Use CData Power BI Connectors to visualize Microsoft Access in Power BI.
-
DataBind Charts to Okta
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Okta from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Back Up SAP Hybris C4C to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Hybris C4C. In this article, we will employ an SSIS workflow to populate a database with SAP Hybris C4C data.
-
Connect to eBay in JRuby
Create a simple JRuby app with access to live eBay.
-
Integrating Adobe Analytics in Talend Cloud Data Management Platform
-