CData Software - Knowledge Base

Recent Articles

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

• Connect to Hive through External Services in Salesforce

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

• Add MailChimp to Informatica Enterprise Data Catalog

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

• How to Create Power BI Visual Reports with Real-Time Reckon Accounts Hosted

  Use CData Power BI Connectors to visualize Reckon Accounts Hosted in Power BI.

• Add Adobe Analytics to Informatica Enterprise Data Catalog

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

• PowerShell Scripting to Replicate Sage Intacct to MySQL

  Write a simple PowerShell script to replicate Sage Intacct to a MySQL database.

• Validate Facebook with QuerySurge

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

• Integrate Real-Time Access to Google Ad Manager in SAPUI5 MVC Apps

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

• Rapidly Develop Oracle Financials Cloud-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.

• Author and Share Power BI Reports on Real-Time Google Drive

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

• Access Power BI XMLA from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Power BI XMLA from HeidiSQL.

• Feed Amazon S3 into FineReport

  How to set Amazon S3 as a JDBC data source in FineReport.

• Create Reports with MongoDB in SAP Crystal Reports

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

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

• Load Neo4J to a Database Using Embulk

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

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

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

• A PostgreSQL Interface for Parquet

  Use the Remoting features of the Parquet ODBC Driver to create a PostgreSQL entry-point for data access.

• Automated Oracle Financials Cloud Replication to Teradata

  Use CData Sync to Customize and automate Oracle Financials Cloud replication to Teradata.

• Load IBM Cloud Object Storage to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load IBM Cloud Object Storage to a database.

• Build Visualizations of Harvest in Birst

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

• Integrate Cassandra in the Pentaho Report Designer

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

• Use Biml to Build SSIS Tasks to Replicate Zoho Creator to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Creator to SQL Server.

• Automated Continuous Google Sheets Replication to Google BigQuery

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

• Import Dynamics GP into Microsoft Power Query

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

• Visualize LinkedIn Ads in Tableau

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

• Use Dash to Build to Web Apps on Bing Search Results

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

• How to Work with Amazon Athena in ETL Validator JDBC

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

• Import Real-Time Presto in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Presto in ColdFusion.

• Automated Continuous MailChimp Replication to MySQL

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

• Automated Continuous Authorize.Net Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Authorize.Net replication to PostgreSQL.

• Validate Google Calendar with QuerySurge

  Access and validate Google Calendar in QuerySurge using the CData JDBC Driver.

• Connect to IBM Informix in Ruby

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

• Automated Continuous Adobe Commerce Replication to IBM DB2

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

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

  Provide connectivity to Adobe Commerce through an SAP BusinessObjects universe.

• How to connect to Facebook from Spring Boot

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

• Creating Zoho Projects-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Zoho Projects to Unqork and build custom business apps.

• Configure the CData JDBC Driver for Sage 50 UK in a Connection Pool in Tomcat

  Connect to Sage 50 UK from a connection pool in Tomcat.

• Process & Analyze SurveyMonkey in Databricks (AWS)

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

• Load Bullhorn CRM to a Database Using Embulk

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

• ETL Paylocity in Oracle Data Integrator

  This article shows how to transfer Paylocity into a data warehouse using Oracle Data Integrator.

• DataBind Controls to Zendesk in Delphi

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

• Visualize Elasticsearch in TIBCO Spotfire through OData

  Integrate Elasticsearch into dashboards in TIBCO Spotfire.

• Access Cassandra as a Remote Oracle Database

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

• Automated Continuous Google Contacts Replication to MongoDB

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

• Working with Acumatica in LINQPad

  Execute LINQ queries to Acumatica ERP in LINQPad.

• How to Work with CouchDB in ETL Validator JDBC

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

• How to Work with SharePoint Excel Services in ETL Validator JDBC

  Connect to SharePoint Excel Services from ETL Validator jobs using the CData Software JDBC Driver.

• Work with Reckon Accounts Hosted in FoxPro

  Load Reckon Accounts Hosted into a FoxPro database. This article includes full code and a walk-through of the process.

• Replicate Multiple ActiveCampaign Accounts

  Replicate multiple ActiveCampaign accounts to one or many databases.

• Analyze Zendesk in R

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

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

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

• How to Query Facebook Ads in MySQL Workbench

  Execute MySQL queries against live Facebook Ads from MySQL Workbench.

• How to Visualize Basecamp Data in Python with pandas

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

• A PostgreSQL Interface for FHIR

  Use the Remoting features of the FHIR ODBC Driver to create a PostgreSQL entry-point for data access.

• Publish Adobe Commerce-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Adobe Commerce.

• Automated Continuous ServiceNow Replication to MongoDB

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

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

  Use CData Power BI Connectors to visualize CSV/TSV Files in Power BI.

• Analyze LinkedIn Ads in R

  Create data visualizations and use high-performance statistical functions to analyze LinkedIn Ads in Microsoft R Open.

• Design BIRT Reports on MYOB AccountRight

  Provide current MYOB AccountRight to your embedded analytics.

• Deploy the ADO.NET Provider for SAP Hybris C4C on an SSRS Report Server

  Connect to SAP Hybris C4C 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.

• Connect to Freshdesk from PowerBuilder

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

• Connect to XML in DBArtisan

  Use wizards in DBArtisan to configure XML Files as a data source.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Automate Tableau CRM Analytics Replication to SAP HANA

  Use CData Sync to customize and automate Tableau CRM Analytics replication to SAP HANA.

• Build Charts with Snowflake in Clear Analytics

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

• Use CData Connect Cloud to Access Zoho CRM in Microsoft Power Pivot

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

• Connect to Couchbase in CloverDX (formerly CloverETL)

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

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

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

• Connect to Twitter from a Connection Pool in JBoss

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

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

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

• Edit and Search External Outreach.io Objects in Salesforce Connect

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

• Visualize Azure Data Catalog in TIBCO Spotfire through ODBC

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

• Operational Reporting on Confluence from Spotfire Server

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

• Access LinkedIn in PHP through Connect Server

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

• How to Access LinkedIn Using Entity Framework

  This article shows how to access LinkedIn using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Prepare, Blend, and Analyze FHIR in Alteryx Designer

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

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

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

• Use the CData Software JDBC Driver for Elasticsearch in MicroStrategy

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

• Access Live OData Services in AWS Lambda

  Connect to live OData in AWS Lambda using the CData JDBC Driver.

• A PostgreSQL Interface for Amazon Marketplace

  Use the SQL Gateway and Amazon Marketplace ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to Bullhorn CRM from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Bullhorn CRM from Filemaker Pro on Mac.

• Create SSAS Tabular Models from Splunk

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

• Build Charts with Adobe Analytics in Clear Analytics

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

• Access JSON Services from MySQL in HeidiSQL

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

• Connect to Microsoft OneDrive in HULFT Integrate

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

• Visualize Live Facebook Ads in the Power BI Service

  Use CData Connect Cloud to connect to live Facebook Ads and create custom reports in the Power BI Service through the On-Premises Gateway.

• Automated Continuous SAP HANA XS Advanced Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to IBM DB2.

• Replicate Google Calendar for Use in Salesforce Connect

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

• Connect to DocuSign in DBArtisan

  Use wizards in DBArtisan to configure DocuSign as a data source.

• DataBind Controls to Zoho CRM in Delphi

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

• How to Import Dropbox into SQL Server using SSIS

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

• PowerShell Scripting to Replicate OData Services to MySQL

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

• How to load Azure Active Directory data into Elasticsearch via Logstash

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

• A PostgreSQL Interface for Power BI XMLA

  Use the Remoting features of the Power BI XMLA JDBC Driver to create a PostgreSQL entry-point for data access.

• Use the CData ODBC Driver for Coinbase in SAS JMP

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

• Visualize Act-On in TIBCO Spotfire through ODBC

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

• Import Real-Time Bing Ads in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Bing Ads in ColdFusion.

• Prepare, Blend, and Analyze Microsoft Teams in Alteryx Designer

  Build workflows to access live Microsoft Teams for self-service data analytics.

• Validate MariaDB with QuerySurge

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

• Stream Clio into Apache Kafka Topics

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

• Connect to Dynamics 365 Business Central in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Dynamics 365 Business Central in the Denodo Virtual DataPort Administrator.

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