CData Software - Knowledge Base

Recent Articles

• «
• 130
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• »

• Query Box in ColdFusion

  Write standard ColdFusion data access code to connect to Box.

• How to create an RPA flow for Marketo in UiPath Studio

  Use the Marketo ODBC Driver to create workflows that access real-time Marketo without any coding.

• Connect to Xero from a Connection Pool in WebLogic

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

• Connect to Google Campaign Manager 360 in SpagoBI

  Create reports featuring live Google Campaign Manager 360 in SpagoBI Studio. Host Google Campaign Manager 360 reports on SpagoBI Server.

• Publish Crystal Reports on MongoDB

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

• Use JayDeBeApi to access LDAP Objects in Python

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

• Access Google Ad Manager in PHP through Connect Server

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

• Use Dash to Build to Web Apps on SingleStore

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

• Use the CData Software JDBC Driver for REST in MicroStrategy

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

• Integrate Reckon into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Reckon and integrate live Reckon into your Power Automate (Microsoft Flow) tasks.

• How to connect to SFTP in DBVisualizer

  Integrate SFTP with visual data analysis tools and data connection wizards in DBVisualizer

• Import Real-Time Greenhouse in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Greenhouse in ColdFusion.

• Replicate Multiple CSV Accounts

  Replicate multiple CSV accounts to one or many databases.

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

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

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

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

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

  Provide connectivity to Invoiced through an SAP BusinessObjects universe.

• Access Live CouchDB in Coginiti Pro

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

• Create Datasets from Pinterest in Domo Workbench and Build Visualizations of Pinterest in Domo

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

• Use the CData ODBC Driver for Cosmos DB from SharePoint Excel Services

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

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

  The CData ODBC Driver for Airtable enables you to integrate Airtable into workflows built using Microsoft Power Automate Desktop.

• Explore Geographical Relationships in Todoist with Power Map

  Create data visualizations with Todoist in Power Map.

• A PostgreSQL Interface for Google Campaign Manager 360

  Use the SQL Gateway and Google Campaign Manager 360 ODBC Driver to create a PostgreSQL entry-point for data access.

• How to connect and process Coinbase from Azure Databricks

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

• Analyze Cosmos DB in R

  Create data visualizations and use high-performance statistical functions to analyze Azure Cosmos DB in Microsoft R Open.

• Create Reports from Act-On in Looker Studio

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

• Build Bing Search-Connected Apps in Mendix

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

• Work with Live Marketo in Power Query

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

• Create Zoho Inventory Reports on JasperReports Server

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

• Visualize Salesforce Marketing from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Salesforce Marketing Cloud.

• PowerShell Scripting to Replicate GitHub to MySQL

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

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

  Provide connectivity to Amazon DynamoDB through an SAP BusinessObjects universe.

• Create Data Visualizations in Cognos BI with Spark

  Access Apache Spark SQL as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Connect to Databricks in CloverDX (formerly CloverETL)

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

• DataBind Airtable to the DevExpress Data Grid

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

• Access Spark as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Spark SQL from your Oracle system.

• Analyze Instagram in R

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

• Connect to SendGrid from HeidiSQL

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

• How to load PayPal data into Elasticsearch via Logstash

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

• Integrate with SAP Business One in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live SAP Business One in SnapLogic.

• Import Email into FileMaker Pro

  Create reports that integrate Email in Filemaker Pro.

• Extract, Transform, and Load Act-On in Informatica PowerCenter

  Create a simple Workflow for Act-On in Informatica PowerCenter.

• Automated Continuous Amazon S3 Replication to SQLite

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

• Automated Continuous Zuora Replication to Microsoft Access

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

• Object-Relational Mapping (ORM) with Adobe Commerce 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 Adobe Commerce into a Java-based ORM framework, Hibernate.

• Connect to SAP Fieldglass in as an External Source in Dremio

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

• Automated Continuous Harvest Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Harvest replication to Google BigQuery.

• Automated Continuous Sage 300 Replication to Vertica

  Use CData Sync for automated, continuous, customizable Sage 300 replication to Vertica.

• How to Connect the Power BI Service to Bing Search: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Enable the SAP ByDesign JDBC Driver in KNIME

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

• Connect to and Query Elasticsearch in QlikView over ODBC

  Create data visualizations with Elasticsearch in QlikView.

• Extract, Transform, and Load Jira Service Management in Informatica PowerCenter

  Create a simple Workflow for Atlassian Jira Service Management in Informatica PowerCenter.

• Build Okta-Connected ETL Processes in Google Data Fusion

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

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

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

• Use the CData Software ODBC Driver for SAP in MicroStrategy Desktop

  Connect to SAP ERP/NetWeaver in MicroStrategy Desktop using the CData Software ODBC Driver for SAP.

• Visualize Clio in TIBCO Spotfire through ADO.NET

  Integrate Clio into dashboards in TIBCO Spotfire.

• How to work with Parquet in Apache Spark using SQL

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

• Integrate Google Campaign Manager 360 in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Campaign Manager 360 from Informatica Cloud.

• Create Oracle SCM-Connected Visualizations in Klipfolio

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

• Using AngularJS to Build Dynamic Web Pages with Wave Financial

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

• Connect to and Visualize Live Smartsheet in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Smartsheet.

• Connect to GraphQL in Google Apps Script

  Use the ODBC Driver for GraphQL and the SQL Gateway to access GraphQL from Google Apps Script.

• Import and Visualize Microsoft Planner in Power View

  Create data visualizations based on Microsoft Planner in Excel.

• Automated Continuous TaxJar Replication to Apache Cassandra

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

• How to update Oracle Sales from Excel

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

• How to Connect to & Open Harvest in Microsoft Excel

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

• Automated Continuous SAP ByDesign Replication to Azure SQL

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

• Build Charts with GitHub in Clear Analytics

  Create dynamic charts and perform analytics based on GitHub in Clear Analytics.

• Integrate with SharePoint using Apache Camel2

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

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

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

• Automated Continuous Raisers Edge NXT Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Apache Kafka.

• Connect to Oracle HCM Cloud from Asprova with CData Software ODBC Driver for Oracle HCM Cloud

  This article shows how to connect faster to Oracle HCM Cloud data from Asprova.

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

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

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

• Use Biml to Build SSIS Tasks to Replicate DB2 to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM DB2 to SQL Server.

• Working with Freshdesk in LINQPad

  Execute LINQ queries to Freshdesk in LINQPad.

• Connect to and Visualize Live Azure Table in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Table Storage.

• Analyze HCL Domino in Cognos Analytics

  Use CData Connect Cloud to connect to HCL Domino from Cognos Analytics and analyze live HCL Domino.

• Connect to Twilio as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Twilio.

• Import Sage 50 UK into the Power BI Service for Visualizations

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

• Use JayDeBeApi to access LinkedIn Ads in Python

  Use standard Python scripting and the development environment of your choice to access live LinkedIn Ads.

• Access Invoiced from MySQL in HeidiSQL

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

• Automated Continuous Zoom Replication to Local Delimited Files

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

• How to use SQLAlchemy ORM to access Jira Assets in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Jira Assets.

• Explore Geographical Relationships in LinkedIn with Power Map

  Create data visualizations with LinkedIn in Power Map.

• Visualize Dynamics CRM from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics CRM.

• How to load Zendesk data into Elasticsearch via Logstash

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

• Prepare, Blend, and Analyze Google Calendar in Alteryx Designer

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Campaign Manager 360

  Provide connectivity to Google Campaign Manager 360 through an SAP BusinessObjects universe.

• Create MailChimp-Connected Enterprise Applications in OutSystems

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

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

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

• Access SAP as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP ERP/NetWeaver from your Oracle system.

• Manage Slack in DBArtisan as a JDBC Source

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

• Connect to and Query QuickBooks in QlikView over ODBC

  Create data visualizations with QuickBooks Desktop in QlikView.

• Connect to Marketo from PowerBuilder

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

• How to work with Cosmos DB in Apache Spark using SQL

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

• Connect to Instagram in Google Apps Script

  Use the ODBC Driver for Instagram and the SQL Gateway to access Instagram from Google Apps Script.

• Use the CData ODBC Driver for Hive in Microsoft Power Query

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

• Integrate Zoho Creator into Power Automate Desktop using CData Connect

  CData Connect for Zoho Creator enables you to integrate Zoho Creator into workflows built using Microsoft Power Automate Desktop.

• DataBind Charts to QuickBooks

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to QuickBooks Desktop 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 integrate Zoho CRM with Apache Airflow

  Access and process Zoho CRM in Apache Airflow using the CData JDBC Driver.

• «
• 130
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• »