CData Software - Knowledge Base

Recent Articles

• «
• 113
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• »

• DataBind Wijmo Grid to Aha

  Provide real-time Aha! to interactive controls.

• Visualize HubDB in Tableau

  The CData ODBC driver for HubDB enables you integrate HubDB into Tableau dashboards.

• Connect to CSV in DBArtisan

  Use wizards in DBArtisan to configure CSV/TSV Files as a data source.

• Automated Continuous Google Search Replication to Vertica

  Use CData Sync for automated, continuous, customizable Google Search replication to Vertica.

• Create Quickbase Dashboards in Bold BI

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

• Connect to JSON Services in RapidMiner

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

• Connect to CockroachDB in JRuby

  Create a simple JRuby app with access to live CockroachDB.

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

  Provide connectivity to Bitbucket through an SAP BusinessObjects universe.

• Replicate ADP for Use in Salesforce Connect

  Replicate ADP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect to Clio in Aqua Data Studio

  Access Clio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Integrate with Live Odoo in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Odoo from the MuleSoft Anypoint Platform to integrate live Odoo ERP into custom reports and dashboards.

• Use the CData Software JDBC Driver for SAP Business One in MicroStrategy

  Connect to SAP Business One in MicroStrategy Developer using the CData Software JDBC Driver for SAP Business One.

• Using the CData Software ODBC Driver for Marketo in PyCharm

  Connect to Marketo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Marketo.

• Access SAP Concur 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 SAP Concur.

• Query MariaDB as a SQL Server Database in Node.js

  Execute SQL Server queries against MariaDB from Node.js.

• PowerShell Scripting to Replicate Odoo to MySQL

  Write a simple PowerShell script to replicate Odoo ERP to a MySQL database.

• DataBind Wijmo Grid to Teradata

  Provide real-time Teradata to interactive controls.

• Load Pipedrive to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pipedrive to a database.

• Replicate Multiple PayPal Accounts

  Replicate multiple PayPal accounts to one or many databases.

• Connect to SAS Data Sets in Google Apps Script

  Use the ODBC Driver for SAS Data Sets and the SQL Gateway to access SAS Data Sets from Google Apps Script.

• Create SSAS Tabular Models from Oracle Service Cloud

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

• Replicate Sage 200 from PowerShell

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

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

  Connect to Bullhorn CRM from a connection pool in Tomcat.

• Create Reports from Dynamics 365 in Looker Studio

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

• Connect to SAP ByDesign in Aqua Data Studio

  Access SAP Business ByDesign from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• DataBind Wijmo Grid to Certinia

  Provide real-time Certinia to interactive controls.

• Create DB2 Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time DB2 data access from reports, embedded analytics, and more.

• Import EventBrite into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Eventbrite. In this article, you will use the OData format to import Eventbrite into Microsoft Power Query.

• Automated Continuous HBase Replication to PostgreSQL

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

• Visualize Live HCL Domino in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live HCL Domino into custom reports in Power BI.

• Automated Continuous IBM Informix Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable IBM Informix replication to delimited files (CSV/TSV).

• DataBind Wijmo Grid to MailChimp

  Provide real-time MailChimp to interactive controls.

• Automate Klaviyo Replication to SAP HANA

  Use CData Sync to customize and automate Klaviyo replication to SAP HANA.

• Connect to Azure Table as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Azure Table Storage.

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

  Use the CData Connector for Quickbase in APOS Live Data Gateway to build Semantic Layer Views for Quickbase.

• PowerShell Scripting to Replicate JotForm to MySQL

  Write a simple PowerShell script to replicate JotForm to a MySQL database.

• Analyze Cassandra in R

  Create data visualizations and use high-performance statistical functions to analyze Apache Cassandra in Microsoft R Open.

• Connect to Active Directory in RapidMiner

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

• How to Connect to ClickUp in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to ClickUp. Leverage the pyodbc module for ODBC in Python.

• Create Reports from Bullhorn CRM in Looker Studio

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

• How to connect to Google Drive from Spring Boot

  Connect to Google Drive in a Spring Boot Application using CData JDBC Google Drive Driver

• Connect to Reckon from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Reckon to connect to Reckon from Web applications running on WebLogic.

• How to create Visio diagrams from Zoho CRM

  Automatically update Zoho CRM with the changes you make to Visio master shapes.

• Connect to SAP SuccessFactors from a Connection Pool in Jetty

  The SAP SuccessFactors JDBC Driver supports connection pooling: This article shows how to connect faster to SAP SuccessFactors from Web apps in Jetty.

• Import Calendly into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Calendly and create custom reports in the Power BI Service.

• Back Up Google BigQuery to SQL Server through SSIS

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

• Work with SAP SuccessFactors in FoxPro

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

• Connect to Adobe Commerce in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Adobe Commerce in Airbyte.

• How to work with WooCommerce in Apache Spark using SQL

  Access and process WooCommerce in Apache Spark using the CData Software JDBC Driver.

• Access Live Microsoft OneDrive in Coginiti Pro

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

• How to connect to AlloyDB with Squirrel SQL client

  Connect to Google AlloyDB and execute queries in the Squirrel SQL Client.

• Automated Continuous SAS xpt Replication to Amazon S3

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

• Create Reports with Trello in SAP Crystal Reports

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

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

  Connect to Klipfolio from a connection pool in Tomcat.

• Query ServiceNow through ODBC in Node.js

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

• Enable the ConstantContact JDBC Driver in KNIME

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

• Build Interactive Dashboards from HDFS in Amazon QuickSight

  Create a virtual SQL Server database for Apache HDFS in CData Software Connect Server and import Apache HDFS into Amazon QuickSight SPICE to build interactive dashboards.

• Analyze Todoist with Power Pivot

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

• Natively Connect to IBM Cloud Data Engine in PHP

  The CData ODBC driver for IBM Cloud Data Engine enables you to create PHP applications with connectivity to IBM Cloud Data Engine. Leverage the native support for ODBC in PHP.

• How to connect to CockroachDB from Spring Boot

  Connect to CockroachDB in a Spring Boot Application using CData JDBC CockroachDB Driver

• Load Zuora to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zuora to a database.

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

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

• Automated Continuous PayPal Replication to MySQL

  Use CData Sync for automated, continuous, customizable PayPal replication to MySQL.

• Use Dash to Build to Web Apps on SAP ByDesign

  Create Python applications that use pandas and Dash to build SAP ByDesign-connected web apps.

• Replicate SQL Server from PowerShell

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

• Write a Simple Go Application to work with Paylocity on Linux

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

• Prepare, Blend, and Analyze Square in Alteryx Designer

  Build workflows to access live Square for self-service data analytics.

• Bridge Tally Connectivity with Apache NiFi

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

• Automated GraphQL Replication to Teradata

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

• Connect to Oracle SCM in RapidMiner

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

• Connect to Live Google Spanner in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Google Spanner in CData Connect Cloud and connect to your Google Spanner from PostgreSQL.

• Connect to Blackbaud FE NXT from HeidiSQL

  Use CData Connect Cloud to connect to and query live Blackbaud FE NXT from HeidiSQL.

• Connect to Live Zoho Inventory in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Zoho Inventory in CData Connect Cloud and connect to your Zoho Inventory from PostgreSQL.

• Visualize Live Sage Intacct in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Sage Intacct.

• Explore Geographical Relationships in Azure Data Lake Storage with Power Map

  Create data visualizations with Azure Data Lake Storage in Power Map.

• How to Visualize Oracle Data in Python with pandas

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

• Use the CData Software ODBC Driver for Power BI XMLA in MicroStrategy Desktop

  Connect to Power BI XMLA in MicroStrategy Desktop using the CData Software ODBC Driver for Power BI XMLA.

• Access Google Analytics in PHP through Connect Server

  Connect to Google Analytics through the standard SQL Server libraries in PHP.

• Access Live Kintone in AWS Lambda

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

• Replicate Zuora for Use in Salesforce Connect

  Replicate Zuora to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Publish Reports with eBay in SAP Crystal Reports

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

• Visualize Live Oracle HCM Cloud in the Power BI Service

  Use CData Connect Cloud to connect to live Oracle HCM Cloud and create custom reports in the Power BI Service through the On-Premises Gateway.

• Analyze Xero in Looker

  Use CData Connect Cloud to connect to Xero from Looker and build custom apps using live Xero Accounting.

• Import and Visualize SAP Ariba Source in Power View

  Create data visualizations based on SAP Ariba Source in Excel.

• How to connect and process Clio from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Clio

• Create Informatica Mappings From/To an ODBC Data Source for EventBrite

  Create an ODBC connection to EventBrite in Informatica and browse and transfer Eventbrite.

• How to integrate Reckon Accounts Hosted with Apache Airflow

  Access and process Reckon Accounts Hosted in Apache Airflow using the CData JDBC Driver.

• Model, Search, and Visualize Live Zoho Projects in ThoughtSpot

  Use CData Connect Cloud to connect to live Zoho Projects for modeling, searching, and visualizing.

• How to use SQLAlchemy ORM to access Snapchat Ads in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Snapchat Ads.

• Replicate Multiple Amazon S3 Accounts

  Replicate multiple Amazon S3 accounts to one or many databases.

• Integrate with Sage Intacct in JReport Designer

  Create charts and reports based on Sage Intacct in JReport Designer.

• How to publish and share Tableau CRM Analytics dashboards with Tableau Server

  The CData ODBC driver for Tableau CRM Analytics enables you integrate Tableau CRM Analytics into Tableau dashboards.

• Write a Simple Go Application to work with Twitter on Linux

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

• Create IBM Cloud Data Engine-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to IBM Cloud Data Engine from AppSheet and build custom business apps using live IBM Cloud Data Engine.

• Automated Continuous Clio Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Clio replication to Apache Cassandra.

• Automated Continuous ShipStation Replication to Apache Kafka

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

• Create Reports with Oracle in SAP Crystal Reports

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

• Work with Shopify in FoxPro

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

• Establish a Live Connection with Spark using Tableau Bridge

  The CData ODBC Driver for Spark enables you to integrate live Apache Spark SQL into Tableau Cloud dashboards using the Tableau Bridge.

• Create Reports with MYOB AccountRight in SAP Crystal Reports

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

• «
• 113
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• »