CData Software - Knowledge Base

Recent Articles

• «
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• »

• Bidirectional Access to SAS Data Sets from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate SAS Data Sets in Filemaker Pro for Mac or Windows.

• Analyze IBM Informix with Power Pivot

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

• Access REST as a Remote Oracle Database

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

• How to Access SAP Hybris C4C Using Entity Framework

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

• Connect to IBM Informix in DBArtisan

  Use wizards in DBArtisan to configure IBM Informix as a data source.

• Build Automated Workflows with Live Workday in Workato

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

• Natively Connect to EventBrite in PHP

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

• Connect to Zoho Inventory in the Denodo Platform

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

• Automated Continuous Adobe Analytics Replication to Apache Kafka

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

• Access Live Greenplum in AWS Lambda

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

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

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

• Create Zenefits-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Zenefits from AppSheet and build custom business apps using live Zenefits.

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

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Workday.

• Access Zoho Books in PHP through Connect Server

  Connect to Zoho Books through the standard SQL Server libraries in PHP.

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

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

• How to connect to QuickBooks Online from MS Excel on Mac OS X

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

• Integrate with Live Zoho Inventory in MuleSoft (via CData Connect Cloud)

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

• Build Zendesk-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Zendesk from Zoho Analytics and import live Zendesk.

• Choosing the Best Method to Connect Avro to SQL Server: 5 Options Explained

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

• Import Excel into FileMaker Pro

  Create reports that integrate Microsoft Excel in Filemaker Pro.

• Manage REST in DBArtisan as a JDBC Source

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

• How to integrate ServiceNow with Apache Airflow

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

• Bridge Pipedrive Connectivity with Apache NiFi

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

• Connect to Azure DevOps in the Denodo Platform

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

• Use the CData ODBC Driver for SQL Analysis Services in SAS JMP

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

• Connect to OData Services as a Linked Server

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

• Connect to Dynamics GP in CloverDX (formerly CloverETL)

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

• Create Informatica Mappings From/To a JDBC Data Source for SQL Analysis Services

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

• Model Amazon DynamoDB Using Azure Analysis Services

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

• Work with Dynamics 365 in FoxPro

  Load Microsoft Dynamics 365 into a FoxPro database. This article includes full code and a walk-through of the process.

• Query QuickBooks Online as a MySQL Database in Node.js

  Execute MySQL queries against QuickBooks Online from Node.js.

• Connect to GraphQL in Jaspersoft Studio

  Execute SQL to remote GraphQL in Jaspersoft Studio.

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

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

• Build Procore-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Procore and build web apps with connectivity to live Procore.

• Connect to Databricks in HULFT Integrate

  Connect to Databricks as a JDBC data source in HULFT Integrate

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

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

• Asana Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Asana facts in real time.

• Connect to Clio from a Connection Pool in WebLogic

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

• Create SAP Hybris C4C-Connected Enterprise Applications in OutSystems

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

• Build Interactive Dashboards from QuickBooks in Amazon QuickSight

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

• Visualize Teradata in Tableau

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

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

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

• Analyze Cassandra in Cognos Analytics

  Use CData Connect Cloud to connect to Cassandra from Cognos Analytics and analyze live Apache Cassandra.

• How to use SQLAlchemy ORM to access LinkedIn in Python

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

• Build Semantic Layer Views for Sugar CRM in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Sugar CRM.

• Analyze JotForm with Power Pivot

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

• Analyze Typeform in R

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

• Automated Continuous Azure Active Directory Replication to Azure SQL

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

• Automated Continuous SAP Concur Replication to Apache Cassandra

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

• How to import Marketo into Apache Solr

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

• Connect to Printful in as an External Source in Dremio

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

• Connect to Email in the Denodo Platform

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

• Use JayDeBeApi to access ADP in Python

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

• How to Import BambooHR into SQL Server using SSIS

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

• Query XML in DataGrip

  Create a Data Source for XML in DataGrip and use SQL to query live XML Files.

• Automated Continuous SAP Fieldglass Replication to Azure SQL

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

• Access CockroachDB as a Remote Oracle Database

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

• Build SAP Business One Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live SAP Business One and build visualizations in Tableau Cloud.

• How to Build an ETL App for Clio in Python with CData

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

• How to Use a Microsoft Access Database to Update MarkLogic in Real Time

  Update MarkLogic data by creating a linked table in Microsoft Access with the CData MarkLogic ODBC Driver.

• Import Oracle Sales into the Power BI Service for Visualizations

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

• Working with Sage 300 in LINQPad

  Execute LINQ queries to Sage 300 in LINQPad.

• Replicate Multiple Reckon Accounts Hosted Accounts

  Replicate multiple Reckon Accounts Hosted accounts to one or many databases.

• Visualize SingleStore in TIBCO Spotfire through ADO.NET

  Integrate SingleStore into dashboards in TIBCO Spotfire.

• Export Data from SQL Server to Stripe through SSIS

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

• Establish a Live Connection with Reckon using Tableau Bridge

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Automated Continuous Excel Online Replication to MySQL

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

• Process & Analyze Smartsheet in Databricks (AWS)

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

• Use the CData Software JDBC Driver for QuickBooks in MicroStrategy

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

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

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

• Analyze Azure Synapse in Cognos Analytics

  Use CData Connect Cloud to connect to Azure Synapse from Cognos Analytics and analyze live Azure Synapse.

• DataBind Wijmo Grid to LinkedIn

  Provide real-time LinkedIn to interactive controls.

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

  Connect to Apache Spark SQL 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.

• LINQ to DB2

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

• DataBind Wijmo Grid to IBM Informix

  Provide real-time IBM Informix to interactive controls.

• How to Connect the Power BI Service to Google Analytics: Complete Guide

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

• How to connect to MySQL from Spring Boot

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

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

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

• Build Pipelines with Live Redshift in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Redshift from Google Cloud Data Fusion, enabling the integration of live Amazon Redshift into the building and management of effective data pipelines.

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

  Connect to Harvest from a connection pool in Tomcat.

• Connect to MongoDB from a Connection Pool in Jetty

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

• Query SAS xpt through ODBC in Node.js

  Use node-odbc to execute SQL queries against SAS XPORT from Node.js.

• How to work with MailChimp in Apache Spark using SQL

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

• Connect to Excel Online as a Linked Server

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

• How to Access SurveyMonkey Using Entity Framework

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

• Automated Continuous Active Directory Replication to Apache Kafka

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

• Analyze Zendesk in SAP Analytics Cloud

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

• Create Reports from Airtable in Looker Studio

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

• Visualize MySQL from Tableau

  Use the Tableau Desktop business intelligence tool to connect to MySQL.

• Write a Simple Go Application to work with Zenefits on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zenefits.

• Automated Continuous SAP Hybris C4C Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Google BigQuery.

• Replicate DocuSign from PowerShell

  Write a quick PowerShell script to query DocuSign. Use connectivity to the live data to replicate DocuSign to SQL Server.

• A PostgreSQL Interface for Salesforce Pardot

  Use the Remoting features of the Salesforce Pardot JDBC Driver to create a PostgreSQL entry-point for data access.

• Connect to Bitbucket from a Connection Pool in Jetty

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

• Connect to SharePoint as a SQL Server Linked Server

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

• Build Facebook Ads Visualizations in Tableau Cloud

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

• Query Redshift through ODBC in Node.js

  Use node-odbc to execute SQL queries against Amazon Redshift from Node.js.

• Natively Connect to eBay Analytics in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to eBay Analytics. Leverage the native support for ODBC in PHP.

• Build a Simple VCL Application for Acumatica

  How to build a simple VCL Application to view Acumatica ERP in RAD Studio using the CData ODBC Driver for Acumatica.

• «
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• »