CData Software - Knowledge Base

Recent Articles

• «
• 152
• 153
• 154
• 155
• 156
• 157
• 158
• 159
• 160
• 161
• »

• Use the CData Software JDBC Driver for Power BI XMLA in MicroStrategy Web

  Connect to Power BI XMLA in MicroStrategy Web using the CData Software JDBC Driver for Power BI XMLA.

• Connect to Avalara AvaTax in RunMyProcess through Connect Server

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

• Create HDFS Dataflows on PowerBI.com

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

• Automated Continuous LinkedIn Replication to Apache Cassandra

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

• Connect to Greenhouse in SpagoBI

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

• Connect to IBM Informix in as an External Source in Dremio

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

• How to connect and process Shippo from Azure Databricks

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

• Access Freshdesk in PHP through Connect Server

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

• Bridge MongoDB Connectivity with Apache NiFi

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

• Replicate Sage Cloud Accounting for Use in Salesforce Connect

  Replicate Sage Business Cloud Accounting to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Automate Airtable Replication to SAP HANA

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

• DataBind Controls to Outreach.io in Delphi

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

• How to connect and process Oracle Eloqua from Azure Databricks

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

• Connect to SQL Server from a Connection Pool in JBoss

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

• How to Import Dynamics NAV into SQL Server using SSIS

  Easily back up Microsoft Dynamics NAV to SQL Server using the SSIS components for Dynamics NAV.

• Connect to Aha in Aqua Data Studio

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

• Analyze BigCommerce with Power Pivot

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

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

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

• Access Okta as a Remote Oracle Database

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

• Create Informatica Mappings From/To an ODBC Data Source for Email

  Create an ODBC connection to Email in Informatica and browse and transfer Email.

• Access Live Stripe in Coginiti Pro

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

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

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

• Connect to Teradata in CloverDX (formerly CloverETL)

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

• Connect to MySQL in the Denodo Platform

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

• Build Dashboards with Printify in DBxtra

  Create dynamic dashboards and perform analytics based on Printify in DBxtra.

• Connect to MarkLogic as a Linked Server

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

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

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

• Query Presto through ODBC in Node.js

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

• Integrate Sybase IQ in Your Informatica Cloud Instance

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

• Prepare, Blend, and Analyze GitHub in Alteryx Designer

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

• Author and Share Power BI Reports on Real-Time Dynamics 365 Business Central

  Use the CData ODBC Driver for Dynamics 365 Business Central to visualize Dynamics 365 Business Central in Power BI Desktop and then upload to the Power BI service.

• Build Automated Workflows with Live Splunk in Workato

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

• Build Access Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Microsoft Access and build visualizations in Tableau Cloud.

• Build Dashboards with MarkLogic in Dundas BI

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

• Automate AlloyDB Replication to Couchbase

  Use CData Sync to Customize and automate Google AlloyDB replication to Couchbase.

• Connect to DB2 in NetBeans

  Connect to IBM DB2 in NetBeans with the data source configuration wizard.

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

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

• Design BIRT Reports on XML

  Provide current XML Files to your embedded analytics.

• Process & Analyze Microsoft Exchange in Databricks (AWS)

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

• Connect to Oracle Sales from a Connection Pool in WebLogic

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

• Connect to Excel in the Denodo Platform

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

• Access SAP BusinessObjects BI as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP BusinessObjects BI from your Oracle system.

• Visualize Live Amazon DynamoDB in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon DynamoDB.

• Automated Continuous NetSuite Replication to MongoDB

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

• How to Access Confluence Using Entity Framework

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

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

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

• Integrate Live Google Sheets into Custom Business Apps Built in Power Apps

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

• How to integrate Metabase with Smartsheet

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

• Connect to Klipfolio in Jaspersoft Studio

  Execute SQL to remote Klipfolio in Jaspersoft Studio.

• Build Greenplum Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Pivotal GreenPlum and build visualizations in Tableau Cloud.

• How to pipe Google Campaign Manager 360 to CSV in PowerShell

  Use standard PowerShell cmdlets to access Google Campaign Manager 360 tables.

• Create Dynamic Google Search Grids Using the Infragistics XamDataGrid

  Learn how you can connect Google Search to Infragistics XamDataGrid to build dynamic grids.

• Prepare, Blend, and Analyze Confluence in Alteryx Designer

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

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

  Connect to HubDB 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.

• Build HBase Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Apache HBase and build visualizations in Tableau Cloud.

• Automated Continuous Facebook Replication to Apache Cassandra

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

• Automated Continuous Reckon Accounts Hosted Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to PostgreSQL.

• Automate BigQuery Replication to Azure Data Lake

  Use CData Sync to customize and automate Google BigQuery replication to Azure Data Lake.

• Create Apps from eBay in Qlik Sense Cloud

  Use CData Connect Cloud to connect to eBay and build apps from live eBay in Qlik Sense Cloud.

• Connect to Marketo from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Marketo from Crystal Reports.

• Model, Search, and Visualize Live Monday.com in ThoughtSpot

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

• Connect to Stripe from AWS Glue

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

• Automated Continuous Trello Replication to Databricks

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

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

  Connect to Odoo ERP in MicroStrategy Web using the CData Software JDBC Driver for Odoo.

• Integrate MailChimp into Power Automate Desktop using CData Connect

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

• Connect to Trello in Google Apps Script

  Use CData Connect Cloud to access Trello in Google Apps Script.

• Query Couchbase as a MySQL Database in Node.js

  Execute MySQL queries against Couchbase from Node.js.

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

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

• Natively Connect to HubSpot in PHP

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

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

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

• Working with Okta in LINQPad

  Execute LINQ queries to Okta in LINQPad.

• Integrate QuickBooks Time with External Services using SnapLogic

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

• How to use SQLAlchemy ORM to access Xero in Python

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

• Create Reports with Reckon in SAP Crystal Reports

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

• Import Real-Time Square in ColdFusion to Build Applications

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

• How to connect Amazon QuickSight to Azure Data Lake Storage

  Create a connection to Azure Data Lake Storage in CData Connect Cloud and insert Azure Data Lake Storage into Amazon QuickSight SPICE to build interactive dashboards.

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

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

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

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

• Connect to Neo4J from PowerBuilder

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

• Automated Continuous LinkedIn Replication to Google BigQuery

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

• A PostgreSQL Interface for Facebook Ads

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

• Connect to Hive from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Apache Hive from Crystal Reports.

• DataBind Wijmo Grid to Google Data Catalog

  Provide real-time Google Data Catalog to interactive controls.

• Build Visualizations of HDFS in Birst

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

• How to Work with Office 365 in AWS Glue Jobs Using JDBC

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

• Query Act CRM in ColdFusion

  Write standard ColdFusion data access code to connect to Act CRM.

• How to create Wave Financial federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Wave Financial in MySQL .

• How to pipe Bullhorn CRM to CSV in PowerShell

  Use standard PowerShell cmdlets to access Bullhorn CRM tables.

• Integrate SAP Business One in the Pentaho Report Designer

  Publish reports based on SAP Business One in the Pentaho BI tool.

• How to work with Xero in Apache Spark using SQL

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

• Visualize Impala in TIBCO Spotfire through ADO.NET

  Integrate Apache Impala into dashboards in TIBCO Spotfire.

• Feed SAP ByDesign into FineReport

  How to set SAP Business ByDesign as a JDBC data source in FineReport.

• Create Reports from SAP ByDesign in Looker Studio

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

• Automated Continuous Typeform Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Typeform replication to SQL Server.

• Visualize PostgreSQL in Tableau

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

• Use Biml to Build SSIS Tasks to Replicate Bing Search Results to SQL Server

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

• Connect to Facebook from PowerBuilder

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

• Publish Crystal Reports on Redshift

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

• DataBind Controls to Todoist in C++Builder

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

• How to import Azure Synapse into Apache Solr

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

• «
• 152
• 153
• 154
• 155
• 156
• 157
• 158
• 159
• 160
• 161
• »