CData Software - Knowledge Base

Recent Articles

• «
• 221
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• »

• Connect to QuickBooks Online from a Connection Pool in JBoss

  Integrate QuickBooks Online into Java servlets: Use the Management Console in JBoss to install the QuickBooks Online JDBC Driver.

• How to connect PolyBase to YouTube Analytics

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live YouTube Analytics.

• Access Certinia from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Certinia from HeidiSQL.

• Create Reports with Tableau CRM Analytics in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Tableau CRM Analytics.

• Import and Visualize HCL Domino in Power View

  Create data visualizations based on HCL Domino in Excel.

• Connect to Reckon in CloverDX (formerly CloverETL)

  Transfer Reckon using the visual workflow in the CloverDX data integration tool.

• Access Live Amazon Marketplace in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Amazon Marketplace from your Google Sheets.

• Connect to Printful in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for Printful and connect to Printful in Akorbi Digital RunMyProcess.

• Connect to WordPress from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live WordPress from Filemaker Pro on Mac.

• Back Up Oracle Database to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle. In this article, we will employ an SSIS workflow to populate a database with Oracle Database data.

• Automated Continuous Airtable Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Airtable replication to Google Cloud SQL.

• Create Apps from Authorize.Net in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Authorize.Net and build apps from live Authorize.Net in Qlik Sense Cloud.

• Operational Reporting on SAP Fieldglass from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote SAP Fieldglass.

• Query Facebook through ODBC in Node.js

  Use node-odbc to execute SQL queries against Facebook from Node.js.

• Operational Reporting on Elasticsearch from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Elasticsearch.

• How to Seamlessly Import Zoho CRM Data into IBM SPSS Modeler

  Integrate Zoho CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Integrate Adobe Commerce in the Pentaho Report Designer

  Publish reports based on Adobe Commerce in the Pentaho BI tool.

• Automated Continuous SAP HANA Replication to MongoDB

  Use CData Sync for automated, continuous, customizable SAP HANA replication to MongoDB.

• Natively Connect to Zoho Books in PHP

  The CData ODBC driver for Zoho Books enables you to create PHP applications with connectivity to Zoho Books. Leverage the native support for ODBC in PHP.

• Configure the CData JDBC Driver for Kafka in a Connection Pool in Tomcat

  Connect to Apache Kafka from a connection pool in Tomcat.

• Use the CData ODBC Driver for Oracle Sales in Microsoft Power Query

  You can use the CData Oracle Sales ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Sales into Microsoft Power Query.

• Create a Data Access Object for Reckon Accounts Hosted using JDBI

  A brief overview of creating a SQL Object API for Reckon Accounts Hosted in JDBI.

• Access SAP HANA XS Advanced in PHP through Connect Server

  Connect to SAP HANA XS Advanced through the standard SQL Server libraries in PHP.

• Access Live QuickBooks Online in AWS Lambda

  Connect to live QuickBooks Online in AWS Lambda using the CData JDBC Driver.

• Analyze Adobe Commerce in Cognos Analytics

  Use CData Connect Cloud to connect to Adobe Commerce from Cognos Analytics and analyze live Adobe Commerce.

• How to Work with Bing Ads in AWS Glue Jobs Using JDBC

  Connect to Bing Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• DataBind Controls to Gmail in Delphi

  DataBind to Gmail in Delphi with standard data access components and controls.

• How to use SQLAlchemy ORM to access Access in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Access.

• Query CockroachDB through ODBC in Node.js

  Use node-odbc to execute SQL queries against CockroachDB from Node.js.

• Access Live Couchbase in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Couchbase to create a Couchbase source in TIBCO Data Virtualization Studio and gain access to live Couchbase from your TDV Server.

• Access Live Box in Coginiti Pro

  Connect to and query live Box from the GUI in the Coginiti Pro: SQL Analytics Tool.

• How to connect Amazon QuickSight to Freshdesk

  Create a connection to Freshdesk in CData Connect Cloud and insert Freshdesk into Amazon QuickSight SPICE to build interactive dashboards.

• Integrate with SuiteCRM in JReport Designer

  Create charts and reports based on SuiteCRM in JReport Designer.

• Analyze Odoo with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Odoo from Power Pivot. You will use the Table Import Wizard to load Odoo ERP. You can visually build the import query or use any SQL supported by the driver.

• Create Data Visualizations in Cognos BI with Google Sheets

  Access Google Sheets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Connect to Workday as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Workday.

• Automated Continuous LinkedIn Replication to Snowflake

  Use CData Sync for automated, continuous, customizable LinkedIn replication to Snowflake.

• Automated Continuous Dynamics 365 Business Central Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to PostgreSQL.

• Use Biml to Build SSIS Tasks to Replicate SAP ByDesign to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Business ByDesign to SQL Server.

• Author and Share Power BI Reports on Real-Time Google Data Catalog

  Use the CData ODBC Driver for Google Data Catalog to visualize Google Data Catalog in Power BI Desktop and then upload to the Power BI service.

• Automated Continuous Databricks Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Databricks replication to IBM DB2.

• Manage LinkedIn Ads in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for LinkedIn Ads.

• Use the CData Software JDBC Driver for Oracle Financials Cloud in MicroStrategy Desktop

  Connect to Oracle Financials Cloud in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle Financials Cloud.

• Bidirectional Access to Avalara AvaTax from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Avalara AvaTax in Filemaker Pro for Mac or Windows.

• Manage DocuSign in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for DocuSign.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Drip

  Provide connectivity to Drip through an SAP BusinessObjects universe.

• Import Real-Time SAP HANA via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use SAP HANA in ColdFusion.

• Bridge SendGrid Connectivity with Apache NiFi

  Access and process SendGrid in Apache NiFi using the CData JDBC Driver.

• Build a Simple VCL Application for Airtable

  How to build a simple VCL Application to view Airtable in RAD Studio using the CData ODBC Driver for Airtable.

• Query MailChimp in ColdFusion

  Write standard ColdFusion data access code to connect to MailChimp.

• View Reports on Real-Time Basecamp in Power BI Report Server

  Use the CData ODBC Driver for Basecamp to visualize Basecamp in Power BI Desktop and then publish them to Power BI Report Server.

• Create Backlog-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Backlog from Nintex Workflow Cloud and build custom workflows using live Backlog.

• Build Couchbase Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Couchbase and build visualizations in Tableau Cloud.

• Operational Reporting on Okta from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Okta.

• Create ShipStation-Connected Applications in Appsmith

  Connect to ShipStation via CData Connect Cloud in Appsmith and create custom business applications with real-time access to ShipStation.

• Use JayDeBeApi to access HCL Domino in Python

  Use standard Python scripting and the development environment of your choice to access live HCL Domino.

• Connect to Google Search Results in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Google Search Results and connect to Google Search in Akorbi Digital RunMyProcess.

• Create SSAS Tabular Models from IBM Cloud Data Engine

  How to build a SQL Server Analysis Service Tabular Model from IBM Cloud Data Engine using CData drivers.

• Working with HarperDB in LINQPad

  Execute LINQ queries to HarperDB in LINQPad.

• Author and Share Power BI Reports on Real-Time Power BI XMLA

  Use the CData ODBC Driver for Power BI XMLA to visualize Power BI XMLA in Power BI Desktop and then upload to the Power BI service.

• Connect to TigerGraph as an External Source in Dremio

  Use the CData JDBC Driver to connect to TigerGraph as an External Source in Dremio.

• How to use SQLAlchemy ORM to access Microsoft Teams in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Teams.

• Build a PostgreSQL Interface for Jira Service Management using the CData JDBC Driver

  Use the Remoting features of the Jira Service Management JDBC Driver to create a PostgreSQL entry-point for data access.

• Access Google Analytics from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Google Analytics from HeidiSQL.

• Import Zoho Inventory into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Zoho Inventory and provide access to live Zoho Inventory for custom reports in the Power BI Service.

• Create Twilio-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Twilio from OutSystems and build custom enterprise apps using live Twilio.

• Visualize WordPress in Sisense

  Create an ElastiCube in Sisense app with access to WordPress.

• Automate FHIR Replication to Azure Data Lake

  Use CData Sync to customize and automate FHIR replication to Azure Data Lake.

• DataBind Controls to Trello in C++Builder

  DataBind to Trello in C++Builder with standard components and controls.

• Access SuiteCRM as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SuiteCRM from your Oracle system.

• Stream SFTP into Apache Kafka Topics

  Access and stream SFTP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automated Continuous Zoom Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Zoom replication to SQL Server.

• Connect to Live Highrise in MicroStrategy through CData Software Connect Server

  Create a virtual database for Highrise in CData Software Connect Server and connect to it from MicroStrategy.

• Automated Continuous MYOB AccountRight Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Apache Kafka.

• Integrate with live Jira Service Management in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Atlassian Jira Service Management in Jitterbit.

• Connect to Azure DevOps in Jaspersoft Studio

  Execute SQL to remote Azure DevOps in Jaspersoft Studio.

• Integrate Trello in Pentaho Data Integration

  Build ETL pipelines based on Trello in the Pentaho Data Integration tool.

• Integrate with live Confluence in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Atlassian Confluence in Jitterbit.

• How to connect to Zoho Inventory in DBVisualizer

  Integrate Zoho Inventory with visual data analysis tools and data connection wizards in DBVisualizer

• Use the CData Software JDBC Driver for Printful in MicroStrategy

  Connect to Printful in MicroStrategy Developer using the CData Software JDBC Driver for Printful.

• Connect to Salesforce Marketing in CloverDX (formerly CloverETL)

  Transfer Salesforce Marketing Cloud using the visual workflow in the CloverDX data integration tool.

• Automate YouTube Analytics Replication to SAP HANA

  Use CData Sync to customize and automate YouTube Analytics replication to SAP HANA.

• Connect to SAP Hybris C4C in HULFT Integrate

  Connect to SAP Hybris C4C as a JDBC data source in HULFT Integrate

• How to load Greenplum data into Elasticsearch via Logstash

  Introducing a simple method to load Greenplum data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• How to create Snowflake federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Snowflake in MySQL .

• Access CockroachDB from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live CockroachDB from HeidiSQL.

• Access HDFS 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 Apache HDFS.

• Connect to Azure DevOps as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure DevOps.

• Integrate BigCommerce with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate BigCommerce with External Services.

• A PostgreSQL Interface for Azure Analysis Services using the CData ODBC Driver

  Use the SQL Gateway and Azure Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.

• Access Live CouchDB in AWS Lambda

  Connect to live Apache CouchDB in AWS Lambda using the CData JDBC Driver.

• Connect to Microsoft Teams in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Microsoft Teams and connect to Microsoft Teams in Akorbi Digital RunMyProcess.

• 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.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for IBM Informix

  Provide connectivity to IBM Informix through an SAP BusinessObjects universe.

• Import Real-Time Azure Synapse via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Azure Synapse in ColdFusion.

• Build Zoho Inventory Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Zoho Inventory and build visualizations in Tableau Cloud.

• How to Seamlessly Import Excel Data into IBM SPSS Modeler

  Integrate Excel data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Access Live Acumatica in Google Sheets via Connect Cloud

  Use CData Connect Cloud to gain access to live Acumatica ERP from your Google Sheets.

• Visualize ShipStation in TIBCO Spotfire through OData

  Integrate ShipStation into dashboards in TIBCO Spotfire.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Amazon S3

  Provide connectivity to Amazon S3 through an SAP BusinessObjects universe.

• «
• 221
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• »