CData Software - Knowledge Base

Recent Articles

• «
• 53
• 54
• 55
• 56
• 57
• 58
• 59
• 60
• 61
• 62
• »

• Connect to LinkedIn in RapidMiner

  Integrate LinkedIn with standard components and data source configuration wizards in RapidMiner Studio.

• A PostgreSQL Interface for Cloudant

  Use the Remoting features of the Cloudant ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to Xero as a Linked Server

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

• How to use SQLAlchemy ORM to access Google Data Catalog in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Data Catalog.

• Model, Search, and Visualize Live HCL Domino in ThoughtSpot

  Use CData Connect Cloud to connect to live HCL Domino for modeling, searching, and visualizing.

• Access Amazon Athena as a Remote Oracle Database

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

• Integrate with EventBrite using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Eventbrite to a JSON file on disk.

• How to connect to Workday from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Workday and work with Workday in Microsoft Excel on Mac OS X.

• How to Visualize Harvest Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Harvest in Python.

• Automated Continuous Avalara AvaTax Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Azure SQL.

• Working with Oracle SCM in LINQPad

  Execute LINQ queries to Oracle SCM in LINQPad.

• Replicate Multiple Typeform Accounts

  Replicate multiple Typeform accounts to one or many databases.

• Integrate Klipfolio in the Pentaho Report Designer

  Publish reports based on Klipfolio in the Pentaho BI tool.

• How to create Dynamics CRM federated tables in MySQL

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

• Replicate Twitter Ads from PowerShell

  Write a quick PowerShell script to query Twitter Ads. Use connectivity to the live data to replicate Twitter Ads to SQL Server.

• Replicate Oracle Service Cloud from PowerShell

  Write a quick PowerShell script to query Oracle Service Cloud. Use connectivity to the live data to replicate Oracle Service Cloud to SQL Server.

• How to Query Couchbase in MySQL Workbench

  Execute MySQL queries against live Couchbase from MySQL Workbench.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• How to create Visio diagrams from MYOB AccountRight

  Automatically update MYOB AccountRight with the changes you make to Visio master shapes.

• Integrate with Jira Service Management in JReport Designer

  Create charts and reports based on Atlassian Jira Service Management in JReport Designer.

• How to create Act-On federated tables in MySQL

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

• Explore Geographical Relationships in Okta with Power Map

  Create data visualizations with Okta in Power Map.

• Build Sugar CRM-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Sugar CRM from Zoho Analytics and import live Sugar CRM.

• Build Semantic Layer Views for NetSuite in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for NetSuite CRM & ERP.

• Automated Drip Replication to Teradata

  Use CData Sync to Customize and automate Drip replication to Teradata.

• Access Live Microsoft Dataverse in AWS Lambda

  Connect to live Microsoft Dataverse (CDS) in AWS Lambda using the CData JDBC Driver.

• Import ADP into the Power BI Service for Visualizations

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

• Replicate Databricks to Multiple Databases

  Replicate Databricks to disparate databases with a point-and-click configuration.

• Operational Reporting on Zoho Inventory from Spotfire Server

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

• Build Redshift-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Amazon Redshift.

• Query Outreach.io as a MySQL Database in Node.js

  Execute MySQL queries against Outreach.io from Node.js.

• Integrate Airtable in the Pentaho Report Designer

  Publish reports based on Airtable in the Pentaho BI tool.

• Connect to Harvest in RunMyProcess through Connect Server

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

• Manage HarperDB in DBArtisan as a JDBC Source

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

• Automated Continuous Instagram Replication to SQL Server

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

• Work with Live GitHub in Power Query

  Use CData Connect Cloud to connect to GitHub and work with live GitHub in Microsoft Power Query.

• Analyze eBay Analytics in R

  Use standard R functions and the development environment of your choice to analyze eBay Analytics with the CData JDBC Driver for eBay Analytics.

• Analyze Invoiced in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of Invoiced and visualize live Invoiced in Ingragistics Reveal.

• How to load Teradata data into Elasticsearch via Logstash

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

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

  Connect to Google Sheets from a connection pool in Tomcat.

• Automated Continuous Highrise Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Highrise replication to PostgreSQL.

• ETL Drift in Oracle Data Integrator

  This article shows how to transfer Drift into a data warehouse using Oracle Data Integrator.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Query Box in MySQL Workbench

  Create a virtual MySQL database for Box in CData Software Connect (or Connect Server) and work with live Box in MySQL Workbench.

• Object-Relational Mapping (ORM) with Redis Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Redis into a Java-based ORM framework, Hibernate.

• Visualize CSV in TIBCO Spotfire through ADO.NET

  Integrate CSV/TSV Files into dashboards in TIBCO Spotfire.

• A Comparison of JDBC Drivers for BigQuery

  A performance comparison of the CData JDBC Driver for Google BigQuery and the Google JDBC Driver for Google BigQuery (updated September 2019)

• Create SuiteCRM Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for SuiteCRM to build custom dashboards in Bold BI.

• Working with JotForm in LINQPad

  Execute LINQ queries to JotForm in LINQPad.

• Write a Simple Go Application to work with Microsoft Project on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Project.

• Connect to Spark in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Spark and connect to Apache Spark SQL in Akorbi Digital RunMyProcess.

• Operational Reporting on Adobe Commerce from Spotfire Server

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

• Create Reports with LDAP Objects in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date LDAP.

• Use Dash to Build to Web Apps on Dynamics 365 Business Central

  Create Python applications that use pandas and Dash to build Dynamics 365 Business Central-connected web apps.

• Publish Crystal Reports on ShipStation

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipStation.

• Stream FHIR into Apache Kafka Topics

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

• How to Connect to & Open Salesforce Marketing in Microsoft Excel

  This article uses the CData ODBC driver for Salesforce Marketing to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Create Reports from WordPress in Looker Studio

  Use CData Connect Cloud to gain access to live WordPress and create custom reports in Looker Studio.

• Process & Analyze PayPal in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live PayPal .

• Analyze SAP ByDesign in R

  Use standard R functions and the development environment of your choice to analyze SAP Business ByDesign with the CData JDBC Driver for SAP ByDesign.

• Work with Active Directory in FoxPro

  Load Active Directory into a FoxPro database. This article includes full code and a walk-through of the process.

• How to import Coinbase into Apache Solr

  Use the CData Software JDBC Driver for Coinbase in Data Import Handler and create an automated import of Coinbase to Apache Solr Enterprise Search platform.

• Access Cloudant from MySQL in Amazon QuickSight

  Connect to Cloudant and build visualizations of IBM Cloudant using a MySQL Connection in Amazon QuickSight.

• How to load Zoho CRM data into Elasticsearch via Logstash

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

• Build SAP Hybris C4C-Connected Apps in Choreo

  Use CData Connect Cloud to connect to SAP Hybris C4C from Choreo and build custom apps using live SAP Hybris C4C.

• How to Access Live CSV in Power Automate Desktop via ODBC

  The CData ODBC Driver for CSV enables you to integrate CSV/TSV Files into workflows built using Microsoft Power Automate Desktop.

• Viewing Teradata in RAD Studio Data Explorer

  How to view Teradata in RAD Studio Data Explorer using the CData ODBC Driver for Teradata.

• Integrate Stripe in the Pentaho Report Designer

  Publish reports based on Stripe in the Pentaho BI tool.

• Connect to Monday.com from PowerBuilder

  This article demonstrates how to access Monday.com from Appeon PowerBuilder using the CData ADO.NET Provider for Monday.com.

• Automate SAP Fieldglass Replication to Azure Synapse

  Use CData Sync to customize and automate SAP Fieldglass replication to Azure Synapse.

• Feed Redshift into FineReport

  How to set Amazon Redshift as a JDBC data source in FineReport.

• Automated Continuous Splunk Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Splunk replication to Amazon S3.

• How to connect to Google Search Results from IntelliJ

  Integrate connectivity to Google Search with wizards in IntelliJ.

• Automated Continuous Zendesk Replication to MongoDB

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

• DataBind Wijmo Grid to Email

  Provide real-time Email to interactive controls.

• Natively Connect to Twitter in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Twitter. Leverage the native support for ODBC in PHP.

• Connect to Quickbase in RunMyProcess through Connect Cloud

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

• Bridge Highrise Connectivity with Apache NiFi

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

• Replicate Multiple Google Analytics Accounts

  Replicate multiple Google Analytics accounts to one or many databases.

• Establish a Live Connection with Google Analytics using Tableau Bridge

  The CData ODBC Driver for Google Analytics enables you to integrate live Google Analytics into Tableau Cloud dashboards using the Tableau Bridge.

• Automated Continuous Reckon Accounts Hosted Replication to Databricks

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Databricks.

• Object-Relational Mapping (ORM) with Zoho CRM Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Zoho CRM into a Java-based ORM framework, Hibernate.

• Rapidly Develop CSV-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Export Data from SQL Server to Dynamics GP through SSIS

  Easily push SQL Server data to Dynamics GP using the CData SSIS Tasks for Dynamics GP.

• Query Microsoft Dataverse in DataGrip

  Create a Data Source for Microsoft Dataverse in DataGrip and use SQL to query live Microsoft Dataverse (CDS).

• Query HCL Domino in MySQL Workbench

  Create a virtual MySQL database for HCL Domino in CData Software Connect (or Connect Server) and work with live HCL Domino in MySQL Workbench.

• Connect to Oracle Service Cloud in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Oracle Service Cloud in Airbyte.

• Create Reports with Dropbox in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Dropbox.

• Create CSV-Connected Nintex Workflows

  Use CData Software Connect Server to connect to CSV from Nintex Workflow Cloud and build custom workflows using live CSV/TSV Files.

• Automated Continuous WooCommerce Replication to SingleStore

  Use CData Sync for automated, continuous, customizable WooCommerce replication to SingleStore.

• Connect to CouchDB as a Linked Server

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

• Manage Smartsheet in DBArtisan as a JDBC Source

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

• Create Informatica Mappings From/To a JDBC Data Source for IBM Cloud Object Storage

  Create IBM Cloud Object Storage data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Connect to Live Blackbaud FE NXT in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Blackbaud FE NXT in CData Connect Cloud and connect to your Blackbaud FE NXT from PostgreSQL.

• Visualize Live Excel of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Microsoft Excel using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Import AlloyDB Using Azure Data Factory

  Use CData Connect Cloud to connect to AlloyDB from Azure Data Factory and import live Google AlloyDB.

• Enable the SAP HANA JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with SAP HANA.

• A PostgreSQL Interface for EnterpriseDB

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

• Create Xero Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• «
• 53
• 54
• 55
• 56
• 57
• 58
• 59
• 60
• 61
• 62
• »