CData Software - Knowledge Base

Recent Articles

• «
• 192
• 193
• 194
• 195
• 196
• 197
• 198
• 199
• 200
• 201
• »

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

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

• Connect to Instagram as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Instagram.

• Microsoft Project Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Project through CData Connect Cloud using different applications and tools.

• Creating Amazon Marketplace-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Amazon Marketplace to Unqork and build custom business apps.

• Automated Continuous BigCommerce Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable BigCommerce replication to Google Cloud SQL.

• Build an OLAP Cube in SSAS from Active Directory

  Establish a connection to Active Directory data from SQL Server Analysis Services, and use the Active Directory Data Provider to build OLAP cubes for use in analytics and reporting.

• Automated Continuous Azure Blob Storage Replication to Vertica

  Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Vertica.

• Design BIRT Reports on JotForm

  Provide current JotForm to your embedded analytics.

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

• Replicate FHIR for Use in Salesforce Connect

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

• Connect to Presto in SpagoBI

  Create reports featuring live Presto in SpagoBI Studio. Host Presto reports on SpagoBI Server.

• Integrate with MariaDB using Apache Camel2

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

• Integrate Live Dynamics 365 into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Microsoft Dynamics 365 and integrate live Microsoft Dynamics 365 into apps built in Microsoft Power Apps.

• Create Greenplum-Connected Applications in Appsmith

  Connect to Greenplum via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Pivotal GreenPlum.

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

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

• Connect to JotForm from PowerBuilder via JDBC

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

• Extract, Transform, and Load SAP Netweaver Gateway in Informatica PowerCenter

  Create a simple Workflow for SAP Netweaver Gateway in Informatica PowerCenter.

• Square Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Square through CData Connect Cloud using different applications and tools.

• Build Data Flows from SQL Server to Zendesk through SSIS

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

• Create Datasets from SAP Concur in Domo Workbench and Build Visualizations of SAP Concur in Domo

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

• Integrate with Dynamics 365 Business Central in JReport Designer

  Create charts and reports based on Dynamics 365 Business Central in JReport Designer.

• Integrate MarkLogic in Your Informatica Cloud Instance

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

• Integrate Klaviyo in Your Informatica Cloud Instance

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

• Connect to Avalara AvaTax from PowerBuilder via JDBC

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

• How to connect to GitHub from IntelliJ

  Integrate connectivity to GitHub with wizards in IntelliJ.

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

• Connect to Zoho CRM in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Zoho CRM in Google Apps Script.

• Query Sage Cloud Accounting in DataGrip

  Create a Data Source for Sage Cloud Accounting in DataGrip and use SQL to query live Sage Business Cloud Accounting.

• Connect to Workday in JRuby

  Create a simple JRuby app with access to live Workday.

• Build Zenefits-Connected Dashboards in Redash

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

• Use the CData ODBC Driver for Adobe Commerce in Microsoft Power Query

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

• Automated Continuous CouchDB Replication to IBM DB2

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

• Enable the Aha JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Aha!.

• Bidirectional Access to GitHub from FileMaker Pro

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

• Connect to LDAP Objects as a Linked Server via CData Connect

  Use CData Connect to set up a linked server for LDAP.

• Use the CData ODBC Driver for Active Directory in Microsoft Power Query

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

• How to connect Amazon QuickSight to Elasticsearch

  Create a connection to Elasticsearch in CData Connect Cloud and insert Elasticsearch into Amazon QuickSight SPICE to build interactive dashboards.

• How to Query Live JSON Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live JSON data in natural language using Python.

• Visualize Live Klipfolio in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Klipfolio.

• Provide OData Services of NetSuite from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for NetSuite CRM & ERP by developing a WCF Service Application.

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

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

• Automated Continuous Cosmos DB Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Cosmos DB replication to SingleStore.

• Automated Continuous Avalara AvaTax Replication to Apache Kafka

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

• Model Bing Ads Using Azure Analysis Services

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

• Build Charts with LDAP Objects in Clear Analytics

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

• Connect to Outreach.io in NetBeans

  Connect to Outreach.io in NetBeans with the data source configuration wizard.

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

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

• Import Sybase into the Power BI Service for Visualizations

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

• Replicate Instagram to Multiple Databases via the CData Sync CLI

  Replicate Instagram to disparate databases with a single configuration.

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

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

• Automated Continuous Twitter Replication to PostgreSQL

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

• Access Live Elasticsearch in SAS JMP via ODBC

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

• Connect to DocuSign in RunMyProcess through Connect Cloud

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

• Analyze Zoho Projects with Power Pivot

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

• How to connect to Excel from IntelliJ

  Integrate connectivity to Microsoft Excel with wizards in IntelliJ.

• Connect to Dynamics 365 Business Central as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Dynamics 365 Business Central.

• Model MariaDB Using Azure Analysis Services

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

• Access Gmail from MySQL in Amazon QuickSight

  Connect to Gmail and build visualizations of Gmail using a MySQL Connection in Amazon QuickSight.

• DataBind Controls to Todoist in C++Builder

  DataBind to Todoist in C++Builder with standard components and controls.

• How to connect to Stripe from IntelliJ

  Integrate connectivity to Stripe with wizards in IntelliJ.

• How to create Visio diagrams from Zoho Inventory

  Automatically update Zoho Inventory with the changes you make to Visio master shapes.

• Import API Using Azure Data Factory

  Use CData Connect Cloud to connect to API from Azure Data Factory and import live API.

• Visualize Spark in TIBCO Spotfire through OData

  Integrate Apache Spark SQL into dashboards in TIBCO Spotfire.

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

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

• Automated Continuous Google Calendar Replication to Databricks

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

• Access Blackbaud FE NXT as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Blackbaud FE NXT from your Oracle system.

• Connect to SFTP in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for SFTP and connect to SFTP in Akorbi Digital RunMyProcess.

• Create SAS Data Sets 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 create an RPA flow for Aha in UiPath Studio

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

• Connect to Live Google Campaign Manager 360 in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Google Campaign Manager 360 in CData Connect Cloud and connect to your Google Campaign Manager 360 from PostgreSQL.

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

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

• Automate SharePoint Replication to Azure Synapse

  Use CData Sync to customize and automate Microsoft SharePoint replication to Azure Synapse.

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

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

• Connect to and Visualize Live Google Ads in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Ads.

• How to create SAP Ariba Procurement federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Ariba Procurement in MySQL .

• Automated Continuous ShipStation Replication to SingleStore

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

• Operational Reporting on Cassandra from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Apache Cassandra.

• Access Live Wave Financial in SAS JMP via ODBC

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

• Build Google Contacts-Connected Web Apps in Servoy

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

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

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

• Analyze JSON Services with Power Pivot

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

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

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

• Create Gmail Reports on JasperReports Server

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

• How to connect to SAP Concur from MS Excel on Mac OS X

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

• Connect to OneNote in Aqua Data Studio

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

• How to load Workday data into Elasticsearch via Logstash

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

• How to connect Amazon QuickSight to Zoho Books

  Create a connection to Zoho Books in CData Connect Cloud and insert Zoho Books into Amazon QuickSight SPICE to build interactive dashboards.

• How to Build Dynamic React Apps with Avro

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

• Connect to Microsoft Dataverse in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Microsoft Dataverse (CDS) in the Denodo Virtual DataPort Administrator.

• Automated Continuous Trello Replication to AlloyDB

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

• How to integrate Metabase with PayPal

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

• How to pipe Sage 50 UK to CSV in PowerShell

  Use standard PowerShell cmdlets to access Sage 50 UK tables.

• Add WordPress to Informatica Enterprise Data Catalog

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

• Connect to SAS Data Sets in CloverDX (formerly CloverETL)

  Transfer SAS Data Sets using the visual workflow in the CloverDX data integration tool.

• Automated Continuous IBM Cloud Object Storage Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Apache Cassandra.

• Natively Connect to Sugar CRM in PHP

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

• Create SSAS Tabular Models from Tally

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

• A PostgreSQL Interface for Azure Active Directory using the CData ODBC Driver

  Use the SQL Gateway and Azure Active Directory ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to ActiveCampaign in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Publish Crystal Reports on SAS xpt

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

• «
• 192
• 193
• 194
• 195
• 196
• 197
• 198
• 199
• 200
• 201
• »