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
-
How to integrate Metabase with SAP Concur
Use CData Connect Cloud to connect to live SAP Concur and create an interactive dashboard in Metabase from SAP Concur.
-
Import Bing Search Results Using Azure Data Factory
Use CData Connect Cloud to connect to Bing Search Results from Azure Data Factory and import live Bing Search.
-
Import Real-Time SAS xpt in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAS XPORT in ColdFusion.
-
How to create Visio diagrams from SAP Business One
Automatically update SAP Business One with the changes you make to Visio master shapes.
-
Use the CData Software ODBC Driver for SAP Hybris C4C in MicroStrategy
Connect to SAP Hybris C4C in MicroStrategy Developer using the CData Software ODBC Driver for SAP Hybris C4C.
-
Replicate SharePoint Excel Services to Multiple Databases
Replicate SharePoint Excel Services to disparate databases with a point-and-click configuration.
-
Natively Connect to Azure Data Catalog in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Azure Data Catalog. Leverage the native support for ODBC in PHP.
-
Connect to Microsoft Project 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 Microsoft Project.
-
Use the CData Software JDBC Driver for SFTP in MicroStrategy Desktop
Connect to SFTP in MicroStrategy Desktop using the CData Software JDBC Driver for SFTP.
-
Prepare, Blend, and Analyze GraphQL in Alteryx Designer
Build workflows to access live GraphQL for self-service data analytics.
-
Natively Connect to Microsoft Planner in PHP
The CData ODBC driver for Microsoft Planner enables you to create PHP applications with connectivity to Microsoft Planner. Leverage the native support for ODBC in PHP.
-
Connect to Twitter in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Twitter in Airbyte.
-
Choosing the Best Method to Connect Oracle Sales to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Sales from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Enable the Parquet JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Parquet.
-
Design BIRT Reports on Google Contacts
Provide current Google Contacts to your embedded analytics.
-
Working with Printful in LINQPad
Execute LINQ queries to Printful in LINQPad.
-
Use JayDeBeApi to access Adobe Commerce in Python
Use standard Python scripting and the development environment of your choice to access live Adobe Commerce.
-
DataBind Wijmo Grid to Pinterest
Provide real-time Pinterest to interactive controls.
-
Create Informatica Mappings From/To a JDBC Data Source for JSON
Create JSON data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Adobe Commerce from PowerBuilder
This article demonstrates how to access Adobe Commerce from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Commerce.
-
Configure the CData Connect Cloud Add-On for Google Sheets
Use the CData Connect Cloud Add-On to connect to your CData Connect Cloud instance from Google Sheets.
-
Analyze Microsoft Planner in Cognos Analytics
Use CData Connect Cloud to connect to Microsoft Planner from Cognos Analytics and analyze live Microsoft Planner.
-
Replicate Exact Online from PowerShell
Write a quick PowerShell script to query Exact Online. Use connectivity to the live data to replicate Exact Online to SQL Server.
-
Create Reports with Highrise in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Highrise CRM.
-
Extract, Transform, and Load SAP HANA XS Advanced in Informatica PowerCenter
Create a simple Workflow for SAP HANA XS Advanced in Informatica PowerCenter.
-
Build Pipelines with Live Oracle SCM in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Oracle SCM from Google Cloud Data Fusion, enabling the integration of live Oracle SCM into the building and management of effective data pipelines.
-
Import Real-Time YouTube Analytics in ColdFusion to Build Applications
Use CData ODBC drivers to import and use YouTube Analytics in ColdFusion.
-
Build Dynamics 365 Business Central-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Dynamics 365 Business Central and build Dynamics 365 Business Central-connected web apps with Axios.
-
Create FTP-Connected Visualizations in Klipfolio
Use CData Software Connect Server to connect to FTP from Klipfolio and build custom visualizations using live FTP Servers.
-
Integrate Cosmos DB in the Pentaho Report Designer
Publish reports based on Azure Cosmos DB in the Pentaho BI tool.
-
Model Google Spanner Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Google Spanner, enabling the direct import of real-time Google Spanner.
-
Analyze Redshift in Looker
Use CData Connect Cloud to connect to Redshift from Looker and build custom apps using live Amazon Redshift.
-
How to connect to Power BI XMLA from Spring Boot
Connect to Power BI XMLA in a Spring Boot Application using CData JDBC Power BI XMLA Driver
-
Connect to Outreach.io in HULFT Integrate
Connect to Outreach.io as a JDBC data source in HULFT Integrate
-
Access Live Oracle in Excel 365 Online (Excel for the web)
Connect to Oracle Database from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Import Real-Time Zoho Books in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Books in ColdFusion.
-
Automated Continuous Reckon Replication to MySQL
Use CData Sync for automated, continuous, customizable Reckon replication to MySQL.
-
Build SAP Concur-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Concur and build web apps with connectivity to live SAP Concur.
-
Connect to Zoho Inventory in RazorSQL
Connect to Zoho Inventory from wizards and query Zoho Inventory from the GUI in the RazorSQL database management tool.
-
Build MVC Applications with Connectivity to HBase
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HBase from an ASP.NET MVC application.
-
Use the CData ODBC Driver for HubSpot in SAS JMP
You can use the CData ODBC Driver to integrate HubSpot into the statistical analysis tools available in SAS JMP. This article shows how to use HubSpot in the Graph Builder and Query Builder.
-
Connect to GitHub from PowerBuilder
This article demonstrates how to access GitHub from Appeon PowerBuilder using the CData ADO.NET Provider for GitHub.
-
Visualize Azure Analysis Services from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Analysis Services.
-
Connect to Google Search Results in NetBeans
Connect to Google Search in NetBeans with the data source configuration wizard.
-
DataBind Veeva to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Veeva with the DevExpress Windows Forms and Web controls to provide Veeva Vault to a chart.
-
Query, Visualize, and Share live Epicor Kinetic in Redash
Use CData Connect Cloud to connect to live Epicor Kinetic in Redash for querying, visualizing, and sharing.
-
Automated Continuous Dynamics 365 Business Central Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Google BigQuery.
-
Automate SuiteCRM Replication to SAP HANA
Use CData Sync to customize and automate SuiteCRM replication to SAP HANA.
-
Use CData Connect Cloud to Access Cloudant in Microsoft Power Pivot
Use CData Connect Cloud to connect to live IBM Cloudant in the Power Pivot business intelligence tool.
-
Visualize Oracle SCM in Tableau
The CData ODBC driver for Oracle SCM enables you integrate Oracle SCM into Tableau dashboards.
-
Prepare, Blend, and Analyze API in Alteryx Designer
Build workflows to access live API for self-service data analytics.
-
Create WordPress-Connected Nintex Workflows
Use CData Connect Cloud to connect to WordPress from Nintex Workflow Cloud and build custom workflows using live WordPress.
-
Model API Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and API, enabling the direct import of real-time API.
-
Build Monday.com-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Monday.com and create custom apps in Bubble.
-
How to Access Oracle Sales Using Entity Framework
This article shows how to access Oracle Sales using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live Phoenix of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache Phoenix using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to GraphQL in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to GraphQL. Leverage the pyodbc module for ODBC in Python.
-
How to work with Zuora in Apache Spark using SQL
Access and process Zuora in Apache Spark using the CData Software JDBC Driver.
-
Automate Amazon S3 Replication to Azure Synapse
Use CData Sync to customize and automate Amazon S3 replication to Azure Synapse.
-
Integrate Real-Time Access to MYOB AccountRight in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MYOB AccountRight in real time.
-
Connect to LinkedIn Ads in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create SSAS Tabular Models from Typeform
How to build a SQL Server Analysis Service Tabular Model from Typeform using CData drivers.
-
Replicate Calendly to Multiple Databases
Replicate Calendly to disparate databases with a point-and-click configuration.
-
Manage SAS xpt in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAS xpt.
-
Analyze SAP Hybris C4C with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Hybris C4C from Power Pivot. You will use the Table Import Wizard to load SAP Hybris C4C. You can visually build the import query or use any SQL supported by the driver.
-
How to Import DB2 into SQL Server using SSIS
Easily back up IBM DB2 to SQL Server using the SSIS components for DB2.
-
Integrate IBM Cloud Object Storage with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate IBM Cloud Object Storage with External Services.
-
Load Presto to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Presto to a database.
-
Use the CData ODBC Driver for MYOB AccountRight in SAS JMP
You can use the CData ODBC Driver to integrate MYOB AccountRight into the statistical analysis tools available in SAS JMP. This article shows how to use MYOB AccountRight in the Graph Builder and Query Builder.
-
DataBind Wijmo Grid to Amazon DynamoDB
Provide real-time Amazon DynamoDB to interactive controls.
-
How to connect and process Typeform from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Typeform
-
How to connect Amazon QuickSight to Amazon S3
Create a connection to Amazon S3 in CData Connect Cloud and insert Amazon S3 into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Kintone-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Kintone and build web apps with connectivity to live Kintone.
-
Connect to Elasticsearch from Crystal Reports
Use CData Connect Cloud to connect to and report on live Elasticsearch from Crystal Reports.
-
Visualize Zoho CRM in Sisense
Create an ElastiCube in Sisense app with access to Zoho CRM.
-
Automated Continuous HBase Replication to Vertica
Use CData Sync for automated, continuous, customizable HBase replication to Vertica.
-
Access Live Zoho CRM in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for Basecamp in SAS JMP
You can use the CData ODBC Driver to integrate Basecamp into the statistical analysis tools available in SAS JMP. This article shows how to use Basecamp in the Graph Builder and Query Builder.
-
Choosing the Best Method to Connect Dynamics GP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Dynamics GP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect to Facebook Ads with Squirrel SQL client
Connect to Facebook Ads and execute queries in the Squirrel SQL Client.
-
Connect to ConstantContact in DBArtisan
Use wizards in DBArtisan to configure ConstantContact as a data source.
-
Stream Splunk into Apache Kafka Topics
Access and stream Splunk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build MVC Applications with Connectivity to DocuSign
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access DocuSign from an ASP.NET MVC application.
-
How to Access Live NetSuite in Power Automate Desktop via ODBC
The CData ODBC Driver for NetSuite enables you to integrate NetSuite CRM & ERP into workflows built using Microsoft Power Automate Desktop.
-
Feed Pipedrive into FineReport
How to set Pipedrive as a JDBC data source in FineReport.
-
How to create Zoho Creator federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Creator in MySQL .
-
Build Apps with Live Google Analytics in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Google Analytics into the Adalo platform and build custom mobile and web applications with real-time Google Analytics.
-
Prepare, Blend, and Analyze SendGrid in Alteryx Designer
Build workflows to access live SendGrid for self-service data analytics.
-
Load Trello to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Trello to a database.
-
Automated Continuous SingleStore Replication to MongoDB
Use CData Sync for automated, continuous, customizable SingleStore replication to MongoDB.
-
Connect to Azure Data Lake Storage in NetBeans
Connect to Azure Data Lake Storage in NetBeans with the data source configuration wizard.
-
Publish Salesforce-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce & Force.com.
-
Access Azure Synapse in PHP through Connect Server
Connect to Azure Synapse through the standard SQL Server libraries in PHP.
-
Build Visualizations of Exact Online in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Exact Online in Birst.
-
Import SFTP into FileMaker Pro
Create reports that integrate SFTP in Filemaker Pro.
-
Load OneNote to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft OneNote to a database.
-
Integrate CSV into Automated Tasks with Power Automate
Use CData Software Connect Server to create a virtual SQL Server database for CSV/TSV Files and integrate live CSV/TSV Files into your Power Automate (Microsoft Flow) tasks.
-
How to integrate CSV with Apache Airflow
Access and process CSV/TSV Files in Apache Airflow using the CData JDBC Driver.
-
Analyze Paylocity in Cognos Analytics
Use CData Connect Cloud to connect to Paylocity from Cognos Analytics and analyze live Paylocity.
-
Connect to Dynamics GP as a Linked Server
Use CData Connect to set up a linked server for Microsoft Dynamics GP.