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 Phoenix Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Phoenix replication to Amazon Redshift.
-
Automated Continuous Phoenix Replication to Snowflake
Use CData Sync for automated, continuous, customizable Phoenix replication to Snowflake.
-
How to connect and process Power BI XMLA from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Power BI XMLA
-
How to import Pinterest into Apache Solr
Use the CData Software JDBC Driver for Pinterest in Data Import Handler and create an automated import of Pinterest to Apache Solr Enterprise Search platform.
-
Automated Continuous Phoenix Replication to MySQL
Use CData Sync for automated, continuous, customizable Phoenix replication to MySQL.
-
Using the CData Software ODBC Driver for Redshift in PyCharm
Connect to Redshift as an ODBC data source in PyCharm using the CData Software ODBC Driver for Redshift.
-
Automated Continuous SAP Replication to Azure SQL
Use CData Sync for automated, continuous, customizable SAP replication to Azure SQL.
-
Use the CData ODBC Driver for GraphQL in Microsoft Power Query
You can use the CData GraphQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import GraphQL into Microsoft Power Query.
-
Visualize Amazon Marketplace in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Amazon Marketplace into TIBCO Spotfire.
-
Operational Reporting on ClickUp from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ClickUp.
-
Connect to Elasticsearch from PowerBuilder
This article demonstrates how to access Elasticsearch from PowerBuilder using the Elasticsearch JDBC Driver.
-
Connect to Active Directory from a Connection Pool in JBoss
Integrate Active Directory into Java servlets: Use the Management Console in JBoss to install the Active Directory JDBC Driver.
-
Use JayDeBeApi to access Slack in Python
Use standard Python scripting and the development environment of your choice to access live Slack.
-
A PostgreSQL Interface for Google Contacts
Use the SQL Gateway and Google Contacts ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live Amazon Marketplace Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amazon Marketplace data in natural language using Python.
-
Bidirectional Access to EnterpriseDB from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate EnterpriseDB in Filemaker Pro for Mac or Windows.
-
Use JayDeBeApi to access SendGrid in Python
Use standard Python scripting and the development environment of your choice to access live SendGrid.
-
Bridge Salesforce Marketing Connectivity with Apache NiFi
Access and process Salesforce Marketing Cloud in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Printful in SAS for Real-Time Reporting and Analytics
Connect to real-time Printful in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Printful.
-
Connect to SAP Ariba Procurement in DBArtisan
Use wizards in DBArtisan to configure SAP Ariba Procurement as a data source.
-
Integrate SQL Server in the Pentaho Report Designer
Publish reports based on Microsoft SQL Server in the Pentaho BI tool.
-
How to Visualize Amazon DynamoDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon DynamoDB in Python.
-
How to create an RPA flow for Marketo in UiPath Studio
Use the Marketo ODBC Driver to create workflows that access real-time Marketo without any coding.
-
How to connect to Dynamics GP from Google Apps Script
Use CData Software Connect Server to access Microsoft Dynamics GP in Google Apps Script.
-
How to create Visio diagrams from BigCommerce
Automatically update BigCommerce with the changes you make to Visio master shapes.
-
Analyze Elasticsearch in R
Use standard R functions and the development environment of your choice to analyze Elasticsearch with the CData JDBC Driver for Elasticsearch.
-
Use Biml to Build SSIS Tasks to Replicate Okta to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Okta to SQL Server.
-
Automated Continuous Freshdesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Freshdesk replication to Amazon S3.
-
Design BIRT Reports on Zoho Books
Provide current Zoho Books to your embedded analytics.
-
Automate GraphQL Replication to Couchbase
Use CData Sync to Customize and automate GraphQL replication to Couchbase.
-
How to Connect to Google Sheets in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the pyodbc module for ODBC in Python.
-
Extract, Transform, and Load Microsoft Planner in Informatica PowerCenter
Create a simple Workflow for Microsoft Planner in Informatica PowerCenter.
-
Automated Continuous Raisers Edge NXT Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to delimited files (CSV/TSV).
-
Visualize Facebook in Tableau
The CData ODBC driver for Facebook enables you integrate Facebook into Tableau dashboards.
-
Build Dashboards with Odoo in Dundas BI
Create dynamic dashboards and perform analytics based on Odoo ERP in Dundas BI.
-
How to Connect to Basecamp in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Basecamp. Leverage the pyodbc module for ODBC in Python.
-
Access Google Sheets in PHP through Connect Server
Connect to Google Sheets through the standard SQL Server libraries in PHP.
-
Connect to SQL Analysis Services as a Linked Server
Use CData Connect to set up a linked server for SQL Analysis Services.
-
Integrate Real-Time Access to Impala in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Impala in real time.
-
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.
-
Replicate REST from PowerShell
Write a quick PowerShell script to query REST. Use connectivity to the live data to replicate REST to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Online
Use CData Power BI Connectors to visualize QuickBooks Online in Power BI.
-
Authorize.Net Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Authorize.Net facts in real time.
-
Integrate ADP in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ADP from Informatica Cloud.
-
How to integrate Metabase with Cassandra
Use CData Connect Cloud to connect to live Apache Cassandra and create an interactive dashboard in Metabase from Apache Cassandra.
-
Create Informatica Mappings From/To a JDBC Data Source for Hive
Create Hive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Oracle-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Oracle from Klipfolio and build custom visualizations using live Oracle Database.
-
How to Visualize LinkedIn Data in Python with pandas
Use pandas and other modules to analyze and visualize live LinkedIn in Python.
-
Connect to BigCommerce in SpagoBI
Create reports featuring live BigCommerce in SpagoBI Studio. Host BigCommerce reports on SpagoBI Server.
-
How to create an RPA flow for HarperDB in UiPath Studio
Use the HarperDB ODBC Driver to create workflows that access real-time HarperDB without any coding.
-
Automated Continuous EnterpriseDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Apache Cassandra.
-
LINQ to Salesforce
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 Salesforce Data Provider.
-
Visualize Live Google Directory in the Power BI Service
Use CData Connect Cloud to connect to live Google Directory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with Live Oracle Service Cloud in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Oracle Service Cloud from the MuleSoft Anypoint Platform to integrate live Oracle Service Cloud into custom reports and dashboards.
-
ETL Snowflake in Oracle Data Integrator
This article shows how to transfer Snowflake into a data warehouse using Oracle Data Integrator.
-
Import Raisers Edge NXT Using Azure Data Factory
Use CData Connect Cloud to connect to Raisers Edge NXT from Azure Data Factory and import live Raisers Edge NXT.
-
Import Raisers Edge NXT into FileMaker Pro
Create reports that integrate Raisers Edge NXT in Filemaker Pro.
-
Connect to JSON Services in RapidMiner
Integrate JSON with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous EventBrite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable EventBrite replication to Amazon S3.
-
How to connect PolyBase to JotForm
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live JotForm.
-
Connect to Impala in CloverDX (formerly CloverETL)
Transfer Apache Impala using the visual workflow in the CloverDX data integration tool.
-
How to create Pipedrive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Pipedrive in MySQL .
-
Connect to Live Veeva in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Veeva in CData Connect Cloud and connect to your Veeva Vault from PostgreSQL.
-
Operational Reporting on Email from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Email.
-
Connect to Reckon as an External Source in Dremio
Use the CData JDBC Driver to connect to Reckon as an External Source in Dremio.
-
Automated Continuous Facebook Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Facebook replication to Google Cloud SQL.
-
ETL LinkedIn in Oracle Data Integrator
This article shows how to transfer LinkedIn into a data warehouse using Oracle Data Integrator.
-
Create Sage Intacct-Connected Business Apps in AppSheet
Connect to Sage Intacct via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Sage Intacct.
-
Integrate with Bing Search Results using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Bing Search to a JSON file on disk.
-
Create Greenplum-Connected Business Apps in AppSheet
Connect to Greenplum via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Pivotal GreenPlum.
-
Choosing the Best Method to Connect Klipfolio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Klipfolio from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Jira Replication to SQLite
Use CData Sync for automated, continuous, customizable Jira replication to SQLite.
-
Use the Connect Server to Access JotForm in Microsoft Power Pivot
Use the Connect Server to connect to live JotForm in the Power Pivot business intelligence tool.
-
Build GraphQL-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live GraphQL.
-
ADP Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ADP facts in real time.
-
Automated Continuous MailChimp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MailChimp replication to IBM DB2.
-
How to Access Live Sage Intacct in Power Automate Desktop via ODBC
The CData ODBC Driver for Sage Intacct enables you to integrate Sage Intacct into workflows built using Microsoft Power Automate Desktop.
-
How to Work with Invoiced in ETL Validator JDBC
Connect to Invoiced from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate ShipStation Replication to SAP HANA
Use CData Sync to customize and automate ShipStation replication to SAP HANA.
-
Automated Continuous Oracle SCM Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Microsoft Access.
-
How to Connect DBeaver to BigCommerce via a JDBC Driver
Manage BigCommerce with visual tools in DBeaver like the query browser.
-
ETL Couchbase in Oracle Data Integrator
This article shows how to transfer Couchbase into a data warehouse using Oracle Data Integrator.
-
How to connect to SurveyMonkey from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for SurveyMonkey and work with SurveyMonkey in Microsoft Excel on Mac OS X.
-
Connect to Redis as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for Redis.
-
Build Gmail-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gmail and build web apps with connectivity to live Gmail.
-
Access Sage Intacct in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Sage Intacct.
-
Automated Continuous CockroachDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CockroachDB replication to Apache Kafka.
-
How to connect to SAP Business One in DBVisualizer
Integrate SAP Business One with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Informatica Mappings From/To an ODBC Data Source for JotForm
Create an ODBC connection to JotForm in Informatica and browse and transfer JotForm.
-
Connect to and Visualize Live Zoho Projects in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Projects.
-
Build Apps with Live JDBC-ODBC Bridge Using the Low-Code Development Platform of Mendix
-