CData Software - Knowledge Base

Recent Articles

• «
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• »

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

  Create an ODBC connection to Google Directory in Informatica and browse and transfer Google Directory.

• Extract, Transform, and Load HubDB in Informatica PowerCenter

  Create a simple Workflow for HubDB in Informatica PowerCenter.

• How to Connect to & Open SQL Analysis Services in Microsoft Excel

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

• Connect to Typeform in Jaspersoft Studio

  Execute SQL to remote Typeform in Jaspersoft Studio.

• Connect to Adobe Analytics from PowerBuilder

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

• Integrate with REST using Apache Camel2

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

• Connect to Google Directory from AWS Glue

  Use CData Connect Cloud to gain access to live Google Directory from your AWS Glue jobs.

• Create eBay-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to eBay from Klipfolio and build custom visualizations using live eBay.

• Create Neo4J Dashboards in Bold BI

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

• Using the CData Software ODBC Driver for Couchbase in PyCharm

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

• How to connect to Google Calendar from Spring Boot

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

• Analyze Oracle HCM Cloud in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Oracle HCM Cloud and visualize Oracle HCM Cloud in SAP Analytics Cloud.

• Access Live Freshdesk in Google Sheets

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

• Query xBase in ColdFusion

  Write standard ColdFusion data access code to connect to xBase.

• How to Import AlloyDB into SQL Server using SSIS

  Easily back up Google AlloyDB to SQL Server using the SSIS components for AlloyDB.

• Connect to Microsoft Exchange in HULFT Integrate

  Connect to Microsoft Exchange as a JDBC data source in HULFT Integrate

• Create Informatica Mappings From/To a JDBC Data Source for SAP Ariba Source

  Create SAP Ariba Source data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Automated Continuous Zuora Replication to MySQL

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

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

  Execute SQL Server queries against PayPal from Node.js.

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

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

• Connect to Sybase IQ in RunMyProcess through Connect Server

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

• Build Automated Trello-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Trello and build automated workflows in Zapier.

• Connect to Redshift in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Amazon Redshift in the Denodo Virtual DataPort Administrator.

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

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

• Analyze EnterpriseDB in R

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

• DataBind Charts to Zoho Creator

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Creator 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.

• Automated Continuous Facebook Replication to IBM DB2

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

• Access Live Microsoft Teams in Excel 365 Online (Excel for the web)

  Connect to Microsoft Teams from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Create Informatica Mappings From/To a JDBC Data Source for Dropbox

  Create Dropbox data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

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

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

• Build Dashboards with Highrise in Dundas BI

  Create dynamic dashboards and perform analytics based on Highrise CRM in Dundas BI.

• Build SurveyMonkey Visualizations in Tableau Cloud

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

• Use JayDeBeApi to access Kafka in Python

  Use standard Python scripting and the development environment of your choice to access live Apache Kafka.

• How to pipe Zoho Inventory to CSV in PowerShell

  Use standard PowerShell cmdlets to access Zoho Inventory tables.

• How to Query Azure Data Lake Storage in MySQL Workbench

  Execute MySQL queries against live Azure Data Lake Storage from MySQL Workbench.

• Visualize Live Oracle HCM Cloud in Power BI (via CData Connect Cloud)

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

• Validate Unbounce with QuerySurge

  Access and validate Unbounce in QuerySurge using the CData JDBC Driver.

• Export Data from SQL Server to Databricks through SSIS

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

• Add Spark to Informatica Enterprise Data Catalog

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

• Analyze WordPress in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of WordPress and visualize live WordPress in Infragistics Reveal.

• How to load HBase data into Elasticsearch via Logstash

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

• Use the CData ODBC Driver for Excel Online from SharePoint Excel Services

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

• Build Dashboards with Azure Analysis Services in DBxtra

  Create dynamic dashboards and perform analytics based on Azure Analysis Services in DBxtra.

• Connect to Impala in RazorSQL

  Connect to Impala from wizards and query Apache Impala from the GUI in the RazorSQL database management tool.

• Build Dashboards with Google Ad Manager in DBxtra

  Create dynamic dashboards and perform analytics based on Google Ad Manager in DBxtra.

• Replicate Multiple Microsoft Project Accounts

  Replicate multiple Microsoft Project accounts to one or many databases.

• Back Up Avalara AvaTax to SQL Server through SSIS

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

• Create Dynamic Workday Grids Using the Infragistics XamDataGrid

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

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

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

• Integrate Real-Time Access to Salesforce Pardot in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Pardot in real time.

• Create BambooHR Reports on JasperReports Server

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

• Connect to Sage Intacct in Google Apps Script

  Use CData Connect Cloud to access Sage Intacct in Google Apps Script.

• Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Desktop

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

• Rapidly Develop Square-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.

• Automated Continuous Microsoft Dataverse Replication to Amazon Redshift

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

• Automated Continuous Stripe Replication to Oracle

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

• How to create Visio diagrams from Sugar CRM

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

• Build Automated Workflows with Live Salesforce Marketing in Workato

  Use CData Connect Cloud to connect to live Salesforce Marketing Cloud and build automated workflows in Workato.

• How to connect to Access from IntelliJ

  Integrate connectivity to Microsoft Access with wizards in IntelliJ.

• Replicate HBase to Multiple Databases

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

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

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

• How to Work with SAP SuccessFactors in ETL Validator JDBC

  Connect to SAP SuccessFactors from ETL Validator jobs using the CData Software JDBC Driver.

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

• Integrate with Square using Apache Camel2

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

• Use the CData ODBC Driver for eBay Analytics in SAS JMP

  You can use the CData ODBC Driver to integrate eBay Analytics into the statistical analysis tools available in SAS JMP. This article shows how to use eBay Analytics in the Graph Builder and Query Builder.

• Integrate with Jira in JReport Designer

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

• A Performance Comparison of Drivers for NoSQL

  An article comparing the read performance of CData Software Drivers for MongoDB.

• Automate Highrise Replication to Azure Synapse

  Use CData Sync to customize and automate Highrise CRM replication to Azure Synapse.

• How to connect to Office 365 in DBVisualizer

  Integrate Microsoft Office 365 with visual data analysis tools and data connection wizards in DBVisualizer

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

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

• How to import Act-On into Apache Solr

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

• How to Import Square into SQL Server using SSIS

  Easily back up Square to SQL Server using the SSIS components for Square.

• Automated Continuous Bing Search Replication to Apache Kafka

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

• How to connect to Wave Financial from MS Excel on Mac OS X

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

• Automated Continuous Hive Replication to Oracle

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

• Create SurveyMonkey Dataflows on PowerBI.com

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

• Connect to and Query DocuSign in QlikView over ODBC

  Create data visualizations with DocuSign in QlikView.

• How to connect to TigerGraph from Spring Boot

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

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

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

• Create Excel-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Excel from Klipfolio and build custom visualizations using live Microsoft Excel.

• Connect to Google Drive in as an External Source in Dremio

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

• Analyze Bing Ads with Power Pivot

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

• Model eBay Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and eBay, enabling the direct import of real-time eBay.

• Create a Data Access Object for LinkedIn using JDBI

  A brief overview of creating a SQL Object API for LinkedIn in JDBI.

• Establish a Live Connection with ConstantContact using Tableau Bridge

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

• Connect to Teradata from PowerBuilder

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

• Access Live Excel Online in TIBCO Data Virtualization

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

• Analyze Azure Active Directory in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Azure Active Directory and visualize Azure Active Directory in SAP Analytics Cloud.

• How to connect PolyBase to BigQuery

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

• Build MarkLogic-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for MarkLogic and build visualizations and dashbaords from MarkLogic in Redash.

• Create Datasets from Google Sheets in Domo Workbench and Build Visualizations of Google Sheets in Domo

  Use the CData Software ODBC Driver for Google Sheets to create datasets from Google Sheets in Domo Workbench and then build visualizations in the Domo service.

• Query Dynamics CRM in MySQL Workbench

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

• Process & Analyze ShipStation in Databricks (AWS)

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

• Connect to CouchDB from PowerBuilder

  This article demonstrates how to access Apache CouchDB from PowerBuilder using the CouchDB JDBC Driver.

• LINQ to Airtable

  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 Airtable Data Provider.

• Build Interactive Dashboards from Certinia in Amazon QuickSight

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

• Integrate with Google Data Catalog using Apache Camel2

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

• Automated Continuous Paylocity Replication to Oracle

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

• How to update Odoo from Excel

  This article explains how to transfer data from Excel to Odoo using the Excel Add-In for Odoo.

• Integrate Real-Time Access to Oracle SCM in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle SCM in real time.

• «
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• »