CData Software - Knowledge Base

Recent Articles

• «
• 328
• 329
• 330
• 331
• 332
• 333
• 334
• 335
• 336
• 337
• »

• Access Live Act-On in Coginiti Pro

  Connect to and query live Act-On from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Automated Continuous Sage 200 Replication to Oracle

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

• Create Zoho Creator Dashboards in Bold BI

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

• Connect to and Query Azure Data Lake Storage in QlikView over ODBC

  Create data visualizations with Azure Data Lake Storage in QlikView.

• Create QuickBooks Time Dataflows on PowerBI.com

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

• How to Connect DBeaver to MarkLogic via a JDBC Driver

  Manage MarkLogic with visual tools in DBeaver like the query browser.

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

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

• Access Live Oracle in Google Sheets

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

• Build Dropbox-Connected Dashboards in Redash

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

• Import Shippo into the Power BI Service for Visualizations

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

• Automate CSV Replication to Azure Synapse

  Use CData Sync to customize and automate CSV/TSV Files replication to Azure Synapse.

• Analyze Harvest with Power Pivot

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

• How to Build an ETL App for Monday.com in Python with CData

  Create ETL applications and real-time data pipelines for Monday.com in Python with petl.

• YouTube Analytics Reporting in OBIEE with the YouTube Analytics JDBC Driver

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

• Connect to Authorize.Net from PowerBuilder

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Authorize.Net

  Provide connectivity to Authorize.Net through an SAP BusinessObjects universe.

• Use Dash to Build to Web Apps on Azure Analysis Services

  Create Python applications that use pandas and Dash to build Azure Analysis Services-connected web apps.

• Access MailChimp from MySQL in HeidiSQL

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

• Create Zoom Dataflows on PowerBI.com

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

• LINQ to SharePoint

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

• Integrate Real-Time Access to TaxJar in SAPUI5 MVC Apps

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

• Connect to Oracle Sales in RazorSQL

  Connect to Oracle Sales from wizards and query Oracle Sales from the GUI in the RazorSQL database management tool.

• Connect to PayPal in Airbyte ELT Pipelines

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

• Work with Spark in FoxPro

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

• Connect to Microsoft Planner as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Planner.

• Use the CData Software JDBC Driver for Jira Assets in MicroStrategy

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

• Automated Continuous Unbounce Replication to Databricks

  Use CData Sync for automated, continuous, customizable Unbounce replication to Databricks.

• Integrate Live Google Sheets into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Google Sheets from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Sheets.

• Prepare, Blend, and Analyze Bing Search Results in Alteryx Designer

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

• How to Connect the Power BI Service to Oracle HCM Cloud: Complete Guide

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

• How to Build Dynamic React Apps with SAP ByDesign

  Use the CData Connect and React to Build Dynamic Web Apps with Live SAP ByDesign .

• Analyze Square in R

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

• Extract, Transform, and Load Tally in Informatica PowerCenter

  Create a simple Workflow for Tally ERP in Informatica PowerCenter.

• Feed Jira Assets into FineReport

  How to set Jira Assets as a JDBC data source in FineReport.

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

  Connect to Bing Search from a connection pool in Tomcat.

• Connect to Facebook from AWS Glue

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

• Automated Continuous HBase Replication to MongoDB

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

• Viewing AlloyDB in RAD Studio Data Explorer

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

• Feed Bing Ads into FineReport

  How to set Bing Ads as a JDBC data source in FineReport.

• Model, Search, and Visualize Live DocuSign in ThoughtSpot

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

• Connect to Slack from PowerBuilder

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

• Connect to Google Ads in CloverDX (formerly CloverETL)

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

• Connect to BambooHR from PowerBuilder

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

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

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

• Connect to Microsoft OneDrive in CloverDX (formerly CloverETL)

  Transfer Microsoft OneDrive using the visual workflow in the CloverDX data integration tool.

• Connect to Live MYOB AccountRight in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to MYOB AccountRight in CData Connect Cloud and connect to your MYOB AccountRight from PostgreSQL.

• Integrate Real-Time Access to SAP Concur in SAPUI5 MVC Apps

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

• Build Automated Microsoft Planner-Connected Workflows in Zapier

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

• Replicate Sybase IQ to Multiple Databases

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

• Viewing SAP in RAD Studio Data Explorer

  How to view SAP ERP/NetWeaver in RAD Studio Data Explorer using the CData ODBC Driver for SAP.

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

  Connect to Amazon DynamoDB from a connection pool in Tomcat.

• Use the CData Software JDBC Driver for Invoiced in MicroStrategy

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

• Integrate HDFS in the Pentaho Report Designer

  Publish reports based on Apache HDFS in the Pentaho BI tool.

• Design BIRT Reports on Acumatica

  Provide current Acumatica ERP to your embedded analytics.

• Automated Continuous RSS Replication to Databricks

  Use CData Sync for automated, continuous, customizable RSS replication to Databricks.

• Integrate Procore into Automated Tasks with Power Automate

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

• How to connect to Zendesk from Spring Boot

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

• Export Data from SQL Server to Sybase IQ through SSIS

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

• Load Sage Intacct to a Database Using Embulk

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

• How to Visualize SAP Fieldglass Data in Python with pandas

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

• Connect to MongoDB from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for MongoDB to connect to MongoDB and execute queries in PowerBuilder.

• Create Salesforce Marketing-Connected Enterprise Applications in OutSystems

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

• Import Basecamp into the Power BI Service for Visualizations

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

• How to connect to Google Directory in DBVisualizer

  Integrate Google Directory with visual data analysis tools and data connection wizards in DBVisualizer

• Publish Oracle Eloqua-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Oracle Eloqua.

• Use CData Connect Cloud to Access Couchbase in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Couchbase in the Power Pivot business intelligence tool.

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

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

• Visualize Live Dynamics GP in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Microsoft Dynamics GP and create custom reports in the Power BI Service.

• Connect to API in Airbyte ELT Pipelines

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

• Process & Analyze Oracle HCM Cloud in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle HCM Cloud .

• Automated Continuous eBay Replication to Azure SQL

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

• How to integrate GraphQL with Apache Airflow

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

• Use the CData Software ODBC Driver for Amazon Athena in MicroStrategy Web

  Connect to Amazon Athena in MicroStrategy Web using the CData Software ODBC Driver for Amazon Athena.

• Automated Continuous Zendesk Replication to MongoDB

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

• Visualize Live SAP in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for SAP ERP/NetWeaver and create custom reports in the Power BI Service.

• Integrate Impala with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Impala with External Services.

• How to use SQLAlchemy ORM to access QuickBooks Time in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of QuickBooks Time.

• Google Campaign Manager 360 Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Google Campaign Manager 360 facts in real time.

• Automated Continuous Asana Replication to MySQL

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

• Automated Continuous Databricks Replication to MySQL

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

• Replicate Multiple Outreach.io Accounts

  Replicate multiple Outreach.io accounts to one or many databases.

• How to connect and process Invoiced from Azure Databricks

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

• Build Dashboards with Elasticsearch in Dundas BI

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

• Design BIRT Reports on Splunk

  Provide current Splunk to your embedded analytics.

• How to Work with Aha in ETL Validator JDBC

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

• Connect to DocuSign in Aqua Data Studio

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

• Access Live Splunk in Coginiti Pro

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

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

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

• Automated Continuous Klipfolio Replication to Apache Kafka

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

• Back Up SAP HANA to SQL Server through SSIS

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

• Connect to Adobe Analytics from a Connection Pool in Jetty

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

• Integrate with Cloudant in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live IBM Cloudant in SnapLogic.

• Create MariaDB-Connected Visualizations in Klipfolio

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

• How to Work with Power BI XMLA in AWS Glue Jobs Using JDBC

  Connect to Power BI XMLA from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Connect to ConstantContact in as an External Source in Dremio

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

• Connect to ActiveCampaign in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Azure Table from Asprova with CData Software ODBC Driver for Azure Table

  This article shows how to connect faster to Azure Table data from Asprova.

• Connect to Acumatica in Google Apps Script

  Use CData Connect Cloud to access Acumatica ERP in Google Apps Script.

• Create Reports with SAP Fieldglass in SAP Crystal Reports

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

• How to Work with MongoDB in AWS Glue Jobs Using JDBC

  Connect to MongoDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• «
• 328
• 329
• 330
• 331
• 332
• 333
• 334
• 335
• 336
• 337
• »