CData Software - Knowledge Base

Recent Articles

• «
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• 289
• 290
• 291
• »

• Automated Excel Online Replication to Teradata

  Use CData Sync to Customize and automate Microsoft Excel Online replication to Teradata.

• Build Dashboards with Printful in DBxtra

  Create dynamic dashboards and perform analytics based on Printful in DBxtra.

• Automated Continuous CSV Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable CSV replication to AlloyDB.

• Add Teradata to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Teradata with the Informatica Enterprise Data Catalog to classify and organize data.

• Connect to Airtable through External Services in Salesforce

  Use CData Connect Cloud to securely provide OData feeds of Airtable to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Airtable objects that you can access from apps and the dashboard.

• Build Xero-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Xero Accounting and build Xero-connected web apps with Axios.

• Process & Analyze SAP Business One in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Business One .

• DataBind SAP Fieldglass to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for SAP Fieldglass with the DevExpress Windows Forms and Web controls to provide SAP Fieldglass to a chart.

• How to work with Hive in Apache Spark using SQL

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

• Build Apps with Live Power BI XMLA in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Power BI XMLA into the Adalo platform and build custom mobile and web applications with real-time Power BI XMLA.

• How to connect to Google Calendar from MS Excel on Mac OS X

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

• Analyze Tableau CRM Analytics in Looker

  Use CData Connect Cloud to connect to Tableau CRM Analytics from Looker and build custom apps using live Tableau CRM Analytics.

• Connect to Google Contacts in CloverDX (formerly CloverETL)

  Transfer Google Contacts using the visual workflow in the CloverDX data integration tool.

• Connect to HCL Domino from AWS Glue

  Use CData Connect Cloud to gain access to live HCL Domino from your AWS Glue jobs.

• Replicate Google Contacts to Multiple Databases

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

• Establish a Live Connection with Dynamics CRM using Tableau Bridge

  The CData ODBC Driver for Dynamics CRM enables you to integrate live Microsoft Dynamics CRM into Tableau Cloud dashboards using the Tableau Bridge.

• Connect to Excel in Ruby

  Connect to Microsoft Excel in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• How to integrate Sage Intacct with Apache Airflow

  Access and process Sage Intacct in Apache Airflow using the CData JDBC Driver.

• Connect to RSS from Asprova with CData Software ODBC Driver for RSS

  This article shows how to connect faster to RSS data from Asprova.

• Visualize Dynamics CRM in TIBCO Spotfire through OData

  Integrate Microsoft Dynamics CRM into dashboards in TIBCO Spotfire.

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

  Connect to Microsoft Dynamics CRM from a connection pool in Tomcat.

• DataBind Charts to WordPress

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to WordPress from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• How to Connect to & Open Oracle SCM in Microsoft Excel

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

• Integrate with live Google Search Results in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Google Search in Jitterbit.

• Build ServiceNow-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ServiceNow.

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

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

• Create SSAS Tabular Models from Clio

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

• Build JDBC-ODBC Bridge-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live JDBC-ODBC Bridge.

• Create Apps from Phoenix in Qlik Sense Cloud

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

• Visualize Live Microsoft Dataverse in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Microsoft Dataverse (CDS) into custom reports in Power BI.

• Use the CData Software JDBC Driver for MarkLogic in MicroStrategy Web

  Connect to MarkLogic in MicroStrategy Web using the CData Software JDBC Driver for MarkLogic.

• Connect to Amazon DynamoDB in Jaspersoft Studio

  Execute SQL to remote Amazon DynamoDB in Jaspersoft Studio.

• Automated Continuous Kintone Replication to Azure SQL

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Printful

  Provide connectivity to Printful through an SAP BusinessObjects universe.

• Connect to Avalara AvaTax in Aqua Data Studio

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

• How to Work with Oracle Eloqua in ETL Validator JDBC

  Connect to Oracle Eloqua from ETL Validator jobs using the CData Software JDBC Driver.

• Integrate Oracle Service Cloud in the Pentaho Report Designer

  Publish reports based on Oracle Service Cloud in the Pentaho BI tool.

• Create Reports with Bitbucket in SAP Crystal Reports

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

• Automated Continuous ShipStation Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable ShipStation replication to Amazon Redshift.

• Automated Continuous Cassandra Replication to Oracle

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

• Use the CData Software JDBC Driver for Zendesk in MicroStrategy Desktop

  Connect to Zendesk in MicroStrategy Desktop using the CData Software JDBC Driver for Zendesk.

• Publish Crystal Reports on ADP

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

• Connect to Sugar CRM from a Connection Pool in JBoss

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

• Visualize Zoom in TIBCO Spotfire through OData

  Integrate Zoom into dashboards in TIBCO Spotfire.

• How to import Spark into Apache Solr

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

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

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

• Create Facebook Reports on JasperReports Server

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

• Process & Analyze SendGrid in Databricks (AWS)

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

• Create Dynamic Smartsheet Grids Using the Infragistics XamDataGrid

  Learn how you can connect Smartsheet to Infragistics XamDataGrid to build dynamic grids.

• Build Shopify-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Shopify and build web apps with connectivity to live Shopify.

• Natively Connect to CouchDB in PHP

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

• Build Google Analytics-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Google Analytics and build web apps with connectivity to live Google Analytics.

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

  Create an ODBC connection to SAS Data Sets in Informatica and browse and transfer SAS Data Sets.

• Using the CData Software ODBC Driver for Active Directory in PyCharm

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

• Query SQL Server through ODBC in Node.js

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

• Use the CData ODBC Driver for Authorize.Net from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Authorize.Net to connect to Authorize.Net from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Authorize.Net in Excel.

• OneNote Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on OneNote facts in real time.

• Visualize Live Zoho Creator in Power BI (via CData Connect Cloud)

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

• Access Spark in PHP through Connect Server

  Connect to Spark through the standard SQL Server libraries in PHP.

• Connect to and Visualize Live Excel in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Excel.

• Connect to Azure Table in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Azure Table Storage in the Denodo Virtual DataPort Administrator.

• How to Visualize LinkedIn Data in Python with pandas

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

• Build Semantic Layer Views for Google Cloud Storage in APOS Live Data Gateway

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

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

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Splunk.

• Build Blackbaud FE NXT-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Blackbaud FE NXT and create custom apps in Mendix.

• Create SSAS Tabular Models from Azure Table

  How to build a SQL Server Analysis Service Tabular Model from Azure Table Storage using CData drivers.

• DB2 Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on DB2 facts in real time.

• Automate IBM Informix Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access IBM Informix from PowerShell? This article demonstrates how to utilize the IBM Informix Cmdlets for tasks like connecting to IBM Informix, automating operations, downloading data, and more.

• How to Query Oracle HCM Cloud in MySQL Workbench

  Execute MySQL queries against live Oracle HCM Cloud from MySQL Workbench.

• Build Visualizations of Calendly in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Calendly in Birst.

• Connect to Jira from HeidiSQL

  Use CData Connect Cloud to connect to and query live Atlassian Jira from HeidiSQL.

• Operational Reporting on Salesloft from Spotfire Server

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

• Connect to Adobe Analytics in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Wave Financial as a Linked Server

  Use CData Connect to set up a linked server for Wave Financial.

• Connect to Dropbox from a Connection Pool in Jetty

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

• Use the CData Software JDBC Driver for OData in MicroStrategy

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

• Cassandra Reporting in OBIEE with the Cassandra JDBC Driver

  Deploy the Cassandra JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to Typeform in Ruby

  Connect to Typeform in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Automated Continuous HubSpot Replication to MySQL

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

• Query Sybase IQ as a SQL Server in Node.js

  Execute SQL Server queries against Sybase IQ from Node.js.

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

  Execute SQL Server queries against Stripe from Node.js.

• Build Azure DevOps-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Azure DevOps from Zoho Analytics and import live Azure DevOps.

• Build Presto-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Presto and create custom apps in Mendix.

• Import Reckon into Microsoft Power Query

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

• Use the CData Software ODBC Driver for Reckon Accounts Hosted in MicroStrategy Desktop

  Connect to Reckon Accounts Hosted in MicroStrategy Desktop using the CData Software ODBC Driver for Reckon Accounts Hosted.

• Connect to Outreach.io in Jaspersoft Studio

  Execute SQL to remote Outreach.io in Jaspersoft Studio.

• Query Bullhorn CRM in DataGrip

  Create a Data Source for Bullhorn CRM in DataGrip and use SQL to query live Bullhorn CRM.

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

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

• Integrate Azure Data Catalog with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Azure Data Catalog with External Services.

• Add Cloudant to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Cloudant with the Informatica Enterprise Data Catalog to classify and organize data.

• Import Todoist into Microsoft Power Query

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

• Access Sage Intacct from MySQL in Amazon QuickSight

  Connect to Sage Intacct and build visualizations of Sage Intacct using a MySQL Connection in Amazon QuickSight.

• Connect to Live Active Directory in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Active Directory in CData Connect Cloud and connect to your Active Directory from PostgreSQL.

• Using AngularJS to Build Dynamic Web Pages with Calendly

  Use the CData Connect Server to create Calendly OData feeds and build single-page applications with live Calendly.

• Access Google Contacts from MySQL in Amazon QuickSight

  Connect to Google Contacts and build visualizations of Google Contacts using a MySQL Connection in Amazon QuickSight.

• Use the CData ODBC Driver for NetSuite in MicroStrategy

  Connect to NetSuite data in MicroStrategy Web using the CData ODBC Driver for NetSuite.

• Integrate CSV in the Pentaho Report Designer

  Publish reports based on CSV/TSV Files in the Pentaho BI tool.

• Automated Continuous Shippo Replication to Google Cloud SQL

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

• Automated Continuous Sage 200 Replication to Amazon S3

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

• Build a Simple VCL Application for Xero

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

• «
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• 289
• 290
• 291
• »