CData Software - Knowledge Base

Recent Articles

• «
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• »

• Automated Continuous Presto Replication to Microsoft Access

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

• Use Dash to Build to Web Apps on Sage 300

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

• How to connect to RSS Feeds with Squirrel SQL client

  Connect to RSS Feeds and execute queries in the Squirrel SQL Client.

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

  Connect to Jira Assets from a connection pool in Tomcat.

• Connect to Redis in DBeaver

  Use the CData ODBC Driver to connect to Redis in DBeaver.

• Prepare, Blend, and Analyze Cosmos DB in Alteryx Designer

  Build workflows to access live Azure Cosmos DB for self-service data analytics.

• Connect to Live Azure Active Directory in MicroStrategy through CData Connect Cloud

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

• PowerShell Scripting to Replicate SAP Concur to MySQL

  Write a simple PowerShell script to replicate SAP Concur to a MySQL database.

• DataBind Controls to ActiveCampaign in Delphi

  DataBind to ActiveCampaign in Delphi with standard data access components and controls.

• Connect to DocuSign in RapidMiner

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

• How to Create Power BI Visual Reports with Real-Time Printful

  Use CData Power BI Connectors to visualize Printful in Power BI.

• Publish Workday-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Workday.

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

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

• Use the CData SSIS Components to Insert New or Update Existing Hive Records from SQL Server

  Easily push SQL Server data to Hive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Hive or update existing records with data from a SQL Server database.

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

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

• Replicate Xero to Multiple Databases

  Replicate Xero Accounting to disparate databases with a single configuration.

• Use the CData Software ODBC Driver for CockroachDB in MicroStrategy Web

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

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

• Neo4J Reporting in OBIEE with the Neo4J JDBC Driver

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

• Use the CData SSIS Components to Insert New or Update Existing OneNote Records from SQL Server

  Easily push SQL Server data to OneNote using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into OneNote or update existing records with data from a SQL Server database.

• Bridge Redis Connectivity with Apache NiFi

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

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

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

• How to work with QuickBooks Time in Apache Spark using SQL

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

• How to Visualize Sage Cloud Accounting Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Sage Business Cloud Accounting in Python.

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

  Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.

• Access Live Salesforce in AWS Lambda

  Connect to live Salesforce & Force.com in AWS Lambda using the CData JDBC Driver.

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

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

• Publish Crystal Reports on Paylocity

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

• Integrate with live Asana in Jitterbit

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

• Stream Google Directory into Apache Kafka Topics

  Access and stream Google Directory in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

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

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

• Connect to Confluence in Google Apps Script

  Use CData Connect Cloud to access Atlassian Confluence in Google Apps Script.

• Automated Continuous Dynamics 365 Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Dynamics 365 replication to SingleStore.

• Choosing the Best Method to Connect Sage 50 UK to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Sage 50 UK from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Connect to Tableau CRM Analytics in Aqua Data Studio

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

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

  Provide connectivity to Microsoft OneDrive through an SAP BusinessObjects universe.

• Visualize Paylocity in Tableau

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

• Design BIRT Reports on Box

  Provide current Box to your embedded analytics.

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

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

• How to Connect to & Open Acumatica in Microsoft Excel

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

• Automate SuiteCRM Replication to SAP HANA

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

• Automated Continuous Square Replication to Apache Kafka

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

• Build Airtable-Connected ETL Processes in Google Data Fusion

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

• Import Real-Time Twitter in ColdFusion to Build Applications

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

• How to integrate Cassandra with Apache Airflow

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

• Import Oracle into FileMaker Pro

  Create reports that integrate Oracle Database in Filemaker Pro.

• Access Live Reckon Accounts Hosted in Coginiti Pro

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

• Natively Connect to Reckon in PHP

  The CData ODBC driver for Reckon enables you to create PHP applications with connectivity to Reckon. Leverage the native support for ODBC in PHP.

• Use JayDeBeApi to access Paylocity in Python

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

• Connect to AlloyDB through External Services in Salesforce

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

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

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

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

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

• Automated Continuous MarkLogic Replication to AlloyDB

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

• PowerShell Scripting to Replicate HubDB to MySQL

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

• Connect to Google Search Results in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Google Search Results and connect to Google Search in Akorbi Digital RunMyProcess.

• Create Data Visualizations in Cognos BI with Box

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

• Integrate with live Active Directory in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Active Directory in Jitterbit.

• Deploy the ADO.NET Provider for Workday on an SSRS Report Server

  Connect to Workday from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Visualize Jira in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Atlassian Jira into TIBCO Spotfire.

• Create Informatica Mappings From/To an ODBC Data Source for Oracle Financials Cloud

  Create an ODBC connection to Oracle Financials Cloud in Informatica and browse and transfer Oracle Financials Cloud.

• Replicate GraphQL for Use in Salesforce Connect

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

• Access Hive 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 Apache Hive.

• Build Dashboards with Amazon Marketplace in Dundas BI

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

• Use the CData Software ODBC Driver for ShipStation in SAS for Real-Time Reporting and Analytics

  Connect to real-time ShipStation in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ShipStation.

• Publish Bitbucket-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Bitbucket.

• Connect to Monday.com in Google Apps Script

  Use CData Connect Cloud to access Monday.com in Google Apps Script.

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

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

• Automated Continuous Twitter Ads Replication to Oracle

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

• Analyze SAP HANA XS Advanced in R

  Create data visualizations and use high-performance statistical functions to analyze SAP HANA XS Advanced in Microsoft R Open.

• How to integrate Metabase with Instagram

  Use CData Connect Cloud to connect to live Instagram and create an interactive dashboard in Metabase from Instagram.

• Connect to Kafka from a Connection Pool in Jetty

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

• Replicate Multiple QuickBooks Online Accounts

  Replicate multiple QuickBooks Online accounts to one or many databases.

• Query Zoho Projects in ColdFusion

  Write standard ColdFusion data access code to connect to Zoho Projects.

• Analyze Dynamics CRM in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Microsoft Dynamics CRM and visualize Microsoft Dynamics CRM in SAP Analytics Cloud.

• Connect to JDBC-ODBC Bridge from a Connection Pool in Jetty

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

• How to Connect DBeaver to Exact Online via a JDBC Driver

  Manage Exact Online with visual tools in DBeaver like the query browser.

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

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

• Import Stripe into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Stripe and provide access to live Stripe for custom reports in the Power BI Service.

• How to publish and share Printify dashboards with Tableau Server

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

• Automated Continuous Sage 300 Replication to Apache Cassandra

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

• Access FTP as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FTP Servers from your Oracle system.

• Integrate PostgreSQL in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PostgreSQL from Informatica Cloud.

• Integrate Google Spanner into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Google Spanner and integrate live Google Spanner into your Power Automate tasks.

• Build Visualizations of Okta in Birst

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

• How to Use CData Connect to Access Live Highrise in Power Automate

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

• Extract, Transform, and Load Excel Online in Informatica PowerCenter

  Create a simple Workflow for Microsoft Excel Online in Informatica PowerCenter.

• Build Apps with Live NetSuite CRM & ERP in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live NetSuite CRM & ERP into the Adalo platform and build custom mobile and web applications with real-time NetSuite CRM & ERP.

• Build Dashboards with SQL Analysis Services in DBxtra

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

• How to work with Cassandra in Apache Spark using SQL

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

• Connect to Google Sheets in DBArtisan

  Use wizards in DBArtisan to configure Google Sheets as a data source.

• Deploy the ADO.NET Provider for WordPress on an SSRS Report Server

  Connect to WordPress from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Analyze IBM Cloud Object Storage in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of IBM Cloud Object Storage and visualize live IBM Cloud Object Storage in Ingragistics Reveal.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Connect to eBay Analytics from PowerBuilder

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

• Back Up Printful to SQL Server through SSIS

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

• Automated Continuous ClickUp Replication to Amazon Redshift

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

• Integrate with Stripe using Apache Camel2

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

• Automate Salesloft Replication to Couchbase

  Use CData Sync to Customize and automate Salesloft replication to Couchbase.

• Validate HubSpot with QuerySurge

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

• Create Informatica Mappings From/To a JDBC Data Source for JDBC-ODBC Bridge

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

• «
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• »