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
-
Create Data Visualizations Based On Oracle Eloqua in Mode
Use CData Connect Cloud to connect to Oracle Eloqua from Mode and build visualizations using live
-
Connect to Google Ad Manager from a Connection Pool in JBoss
Integrate Google Ad Manager into Java servlets: Use the Management Console in JBoss to install the Google Ad Manager JDBC Driver.
-
Automated Continuous Pipedrive Replication to Vertica
Use CData Sync for automated, continuous, customizable Pipedrive replication to Vertica.
-
Explore Geographical Relationships in Zoho Projects with Power Map
Create data visualizations with Zoho Projects in Power Map.
-
Use the CData Software ODBC Driver for SAP Fieldglass in MicroStrategy
Connect to SAP Fieldglass in MicroStrategy Developer using the CData Software ODBC Driver for SAP Fieldglass.
-
Automated Continuous MariaDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable MariaDB replication to Snowflake.
-
Visualize Live Redshift in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon Redshift.
-
Use the CData Software JDBC Driver for Sage 200 in MicroStrategy Web
Connect to Sage 200 in MicroStrategy Web using the CData Software JDBC Driver for Sage 200.
-
Visualize Cloudant in Sisense
Create an ElastiCube in Sisense app with access to IBM Cloudant.
-
Choosing the Best Method to Connect Asana to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Asana from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use JayDeBeApi to access Clio in Python
Use standard Python scripting and the development environment of your choice to access live Clio.
-
Use the CData Software JDBC Driver for Twitter in MicroStrategy Desktop
Connect to Twitter in MicroStrategy Desktop using the CData Software JDBC Driver for Twitter.
-
Use the CData Software ODBC Driver for Salesloft in MicroStrategy
Connect to Salesloft in MicroStrategy Developer using the CData Software ODBC Driver for Salesloft.
-
Work with IBM Cloud Object Storage in FoxPro
Load IBM Cloud Object Storage into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to load Sybase IQ data into Elasticsearch via Logstash
Introducing a simple method to load Sybase IQ data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Data Visualizations in Cognos BI with Todoist
Access Todoist as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Trello in Google Sheets
Use Connect Spreadsheets by CData to gain access to live Trello from your Google Sheets.
-
How to connect Amazon QuickSight to Zoho CRM
Create a connection to Zoho CRM in CData Connect Cloud and insert Zoho CRM into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live QuickBooks Online in AWS Lambda (with IntelliJ IDEA)
Connect to live QuickBooks Online in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Datasets from Invoiced in Domo Workbench and Build Visualizations of Invoiced in Domo
Use the CData Software ODBC Driver for Invoiced to create datasets from Invoiced in Domo Workbench and then build visualizations in the Domo service.
-
LINQ to Cassandra
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 Cassandra Data Provider.
-
Replicate Typeform for Use in Salesforce Connect
Replicate Typeform to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Natively Connect to Google Data Catalog in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Google Data Catalog. Leverage the native support for ODBC in PHP.
-
How to work with Tally in Apache Spark using SQL
Access and process Tally in Apache Spark using the CData Software JDBC Driver.
-
Viewing Blackbaud FE NXT in RAD Studio Data Explorer
How to view Blackbaud FE NXT in RAD Studio Data Explorer using the CData ODBC Driver for Blackbaud FE NXT.
-
How to use SQLAlchemy ORM to access SAS xpt in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAS XPORT.
-
ETL Act-On in Oracle Data Integrator
This article shows how to transfer Act-On into a data warehouse using Oracle Data Integrator.
-
Import Azure Data Catalog into Microsoft Power Query
The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Azure Data Catalog. In this article, you will use the OData format to import Azure Data Catalog into Microsoft Power Query.
-
Integrate Dynamics 365 Business Central in the Pentaho Report Designer
Publish reports based on Dynamics 365 Business Central in the Pentaho BI tool.
-
Create Reports from DocuSign in Looker Studio
Use CData Connect Cloud to gain access to live DocuSign and create custom reports in Looker Studio.
-
How to Import Cvent into SQL Server using SSIS
Easily back up Cvent to SQL Server using the SSIS components for Cvent.
-
Access Salesloft from MySQL in PHP
Connect to Salesloft through the standard MySQL libraries in PHP.
-
Operational Reporting on QuickBooks Online from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote QuickBooks Online.
-
Bridge Trello Connectivity with Apache NiFi
Access and process Trello in Apache NiFi using the CData JDBC Driver.
-
Analyze Live Outreach.io in SAS Viya
Use CData Connect Cloud to connect to Outreach.io from SAS Viya and deploy self-service analytics using live Outreach.io.
-
Connect to JSON Services in Aqua Data Studio
Access JSON from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Prepare, Blend, and Analyze LDAP Objects in Alteryx Designer
Build workflows to access live LDAP for self-service data analytics.
-
A PostgreSQL Interface for Excel Online
Use the Remoting features of the Excel Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Oracle Eloqua from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Eloqua using standard SQL.
-
Connect to Jira Service Management in JRuby
Create a simple JRuby app with access to live Atlassian Jira Service Management.
-
Extract, Transform, and Load Typeform in Informatica PowerCenter
Create a simple Workflow for Typeform in Informatica PowerCenter.
-
Connect to Greenplum in CloverDX (formerly CloverETL)
Transfer Pivotal GreenPlum using the visual workflow in the CloverDX data integration tool.
-
PowerShell Scripting to Replicate Azure Active Directory to MySQL
Write a simple PowerShell script to replicate Azure Active Directory to a MySQL database.
-
Validate BigQuery with QuerySurge
Access and validate Google BigQuery in QuerySurge using the CData JDBC Driver.
-
Use JayDeBeApi to access Parquet in Python
Use standard Python scripting and the development environment of your choice to access live Apache Parquet.
-
Back Up NetSuite CRM & ERP to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for NetSuite. In this article, we will employ an SSIS workflow to populate a database with NetSuite CRM & ERP data.
-
How to work with Impala in Apache Spark using SQL
Access and process Impala in Apache Spark using the CData Software JDBC Driver.
-
Configure a One-Way Send Port for the CData BizTalk Adapter for Salesforce
Use the CData BizTalk Adapter for Salesforce with a one-way send port to execute updategrams and data manipulation SQL in BizTalk.
-
Access Teradata from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Teradata from HeidiSQL.
-
Visualize Live Square of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Square using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Creating Microsoft Project-Connected Applications in Unqork
You can use CData Connect Cloud to feed Microsoft Project to Unqork and build custom business apps.
-
SAP HANA Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP HANA facts in real time.
-
Build Charts with DB2 in Clear Analytics
Create dynamic charts and perform analytics based on IBM DB2 in Clear Analytics.
-
DataBind Controls to LinkedIn in Delphi
DataBind to LinkedIn in Delphi with standard data access components and controls.
-
Connect to SAP Hybris C4C from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Hybris C4C using standard SQL.
-
Automate ClickUp Replication to Azure Data Lake
Use CData Sync to customize and automate ClickUp replication to Azure Data Lake.
-
Use Biml to Build SSIS Tasks to Replicate OneNote to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft OneNote to SQL Server.
-
Analyze MariaDB in Looker
Use CData Connect Cloud to connect to MariaDB from Looker and build custom apps using live MariaDB.
-
Access SAP HANA XS Advanced as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP HANA XS Advanced from your Oracle system.
-
Prepare, Blend, and Analyze Google Directory in Alteryx Designer
Build workflows to access live Google Directory for self-service data analytics.
-
Connect to Coinbase in Jaspersoft Studio
Execute SQL to remote Coinbase in Jaspersoft Studio.
-
Automated Continuous Cosmos DB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Amazon S3.
-
Automated Continuous SAP Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP replication to PostgreSQL.
-
Replicate Multiple Neo4J Accounts
Replicate multiple Neo4J accounts to one or many databases.
-
Automated Continuous Odoo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Odoo replication to Amazon Redshift.
-