CData Software - Knowledge Base

Recent Articles

• «
• 231
• 232
• 233
• 234
• 235
• 236
• 237
• 238
• 239
• 240
• »

• How to use SQLAlchemy ORM to access SAP HANA in Python

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

• Visualize Printful in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Printful in CData Software Connect (or Connect Server) and build visualizations from live Printful in Tableau Desktop.

• How to Work with Greenplum in ETL Validator JDBC

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

• How to work with NetSuite in Apache Spark using SQL

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

• DataBind HDFS to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for HDFS with the DevExpress Windows Forms and Web controls to provide Apache HDFS to a chart.

• Use Dash to Build to Web Apps on BigCommerce

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

• Access Live SAP HANA in AWS Lambda

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

• Replicate Multiple Box Accounts

  Replicate multiple Box accounts to one or many databases.

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

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

• Analyze Dropbox in R

  Use standard R functions and the development environment of your choice to analyze Dropbox with the CData JDBC Driver for Dropbox.

• Create Datasets from Salesforce Pardot in Domo Workbench and Build Visualizations of Salesforce Pardot in Domo

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

• Import Clio into Microsoft Power Query

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

• Automated Continuous SAP Ariba Procurement Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to AlloyDB.

• How to connect and process HarperDB from Azure Databricks

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

• How to Connect DBeaver to SQL Analysis Services via a JDBC Driver

  Manage SQL Analysis Services with visual tools in DBeaver like the query browser.

• Analyze Certinia in SAP Analytics Cloud

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

• Build Google Campaign Manager 360-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Google Campaign Manager 360 and create custom apps in Bubble.

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

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

• Integrate JSON with External Services using SnapLogic

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

• Visualize Quickbase in Sisense

  Create an ElastiCube in Sisense app with access to Quickbase.

• Create IBM Cloud Data Engine Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for IBM Cloud Data Engine to build custom dashboards in Bold BI.

• Automate GitHub Replication to Azure Data Lake

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

• How to pipe GitHub to CSV in PowerShell

  Use standard PowerShell cmdlets to access GitHub tables.

• Use the CData Software JDBC Driver for QuickBooks Online in MicroStrategy Desktop

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

• Use the CData ODBC Driver for Raisers Edge NXT from SharePoint Excel Services

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

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

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

• A PostgreSQL Interface for Zoho Inventory

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

• Analyze Zoho Inventory in Cognos Analytics

  Use CData Connect Cloud to connect to Zoho Inventory from Cognos Analytics and analyze live Zoho Inventory.

• Automate Sage 300 Replication to Azure Data Lake

  Use CData Sync to customize and automate Sage 300 replication to Azure Data Lake.

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

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

• Connect to Shopify from Crystal Reports

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

• Visualize Pipedrive in TIBCO Spotfire through ODBC

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

• How to Work with LDAP Objects in AWS Glue Jobs Using JDBC

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

• Replicate Google Spanner for Use in Salesforce Connect

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

• Integrate Google Contacts in the Pentaho Report Designer

  Publish reports based on Google Contacts in the Pentaho BI tool.

• Build MVC Applications with Connectivity to Azure Analysis Services

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Analysis Services from an ASP.NET MVC application.

• Establish a Live Connection with Cosmos DB using Tableau Bridge

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

• LINQ to Sage 50 UK

  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 Sage 50 UK Data Provider.

• Query SFTP in ColdFusion

  Write standard ColdFusion data access code to connect to SFTP.

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

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

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

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

• Create Apps from OData Services in Qlik Sense Cloud

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

• Access TaxJar from MySQL in PHP

  Connect to TaxJar through the standard MySQL libraries in PHP.

• Publish HDFS-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Apache HDFS.

• Build Apps with Live Oracle Sales in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Oracle Sales into the Adalo platform and build custom mobile and web applications with real-time Oracle Sales.

• PowerShell Scripting to Replicate Quickbase to MySQL

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

• Replicate Multiple Access Accounts

  Replicate multiple Access accounts to one or many databases.

• Integrate Live Epicor Kinetic into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Epicor Kinetic from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Epicor Kinetic.

• Automate Marketo Replication to Couchbase

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

• Create Apps from Confluence in Qlik Sense Cloud

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

• Process & Analyze YouTube Analytics in Databricks (AWS)

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

• Automated Continuous Microsoft Exchange Replication to PostgreSQL

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

• Create SSAS Tabular Models from Quickbase

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

• Connect to Snowflake through External Services in Salesforce

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

• Use the CData ODBC Driver for Cassandra in Microsoft Power Query

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

• LINQ to Calendly

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

• Automated Continuous eBay Replication to Google Cloud SQL

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

• Connect to Avalara AvaTax in DBeaver

  Use the CData ODBC Driver to connect to Avalara AvaTax in DBeaver.

• Automated Continuous Klipfolio Replication to MongoDB

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

• Automate Microsoft Teams Replication to Azure Synapse

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

• How to Connect to IBM Informix in Using Python: 6 Steps

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

• Create Reports from Google Campaign Manager 360 in Looker Studio

  Use CData Connect Cloud to gain access to live Google Campaign Manager 360 and create custom reports in Looker Studio.

• Query LinkedIn Ads as a SQL Server Database in Node.js

  Execute SQL Server queries against LinkedIn Ads from Node.js.

• Analyze Marketo in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Marketo and visualize live Marketo in Infragistics Reveal.

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

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

• How to work with ShipStation in Apache Spark using SQL

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

• Create YouTube Analytics-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to YouTube Analytics from Klipfolio and build custom visualizations using live YouTube Analytics.

• Automated Continuous Cloudant Replication to Vertica

  Use CData Sync for automated, continuous, customizable Cloudant replication to Vertica.

• How to Connect the Power BI Service to Raisers Edge NXT: Complete Guide

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

• Write a Simple Go Application to work with Sybase IQ on Linux

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

• Establish a Live Connection with ActiveCampaign using Tableau Bridge

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

• Create SAP HANA-Connected Nintex Workflows

  Use CData Connect Cloud to connect to SAP HANA from Nintex Workflow Cloud and build custom workflows using live SAP HANA.

• Prepare, Blend, and Analyze ShipStation in Alteryx Designer

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

• Model Oracle Financials Cloud Using Azure Analysis Services

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

• Automated Continuous Power BI XMLA Replication to SQLite

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to SQLite.

• Access Live PostgreSQL in AWS Lambda

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

• Connect to Odoo from Crystal Reports

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

• Explore Geographical Relationships in SAP Business One with Power Map

  Create data visualizations with SAP Business One in Power Map.

• Replicate Sybase for Use in Salesforce Connect

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

• Work with Calendly in FoxPro

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

• Connect to JDBC-ODBC Bridge in Aqua Data Studio

  Access JDBC-ODBC Bridge from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Automated Continuous Drift Replication to Google Cloud SQL

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

• Visualize Live QuickBooks Time in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live QuickBooks Time.

• Automated Continuous Act-On Replication to SQLite

  Use CData Sync for automated, continuous, customizable Act-On replication to SQLite.

• Automated Continuous EventBrite Replication to Apache Cassandra

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

• Access Live SingleStore in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for SingleStore to create a SingleStore source in TIBCO Data Virtualization Studio and gain access to live SingleStore from your TDV Server.

• Create a Data Access Object for ServiceNow using JDBI

  A brief overview of creating a SQL Object API for ServiceNow in JDBI.

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

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

• Use the CData ODBC Driver for Drip in SAS JMP

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

• Publish Reports with Microsoft Dataverse in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Dataverse (CDS).

• How to Connect DBeaver to Bing Search via a JDBC Driver

  Manage Bing Search with visual tools in DBeaver like the query browser.

• Access Live Act CRM in Excel 365 Online (Excel for the web)

  Connect to Act CRM from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• DataBind Controls to XML in C++Builder

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

• Connect to and Query Sybase IQ in QlikView over ODBC

  Create data visualizations with Sybase IQ in QlikView.

• How to pipe ClickUp to CSV in PowerShell

  Use standard PowerShell cmdlets to access ClickUp tables.

• Analyze Trello in Cognos Analytics

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

• Integrate Live Exact Online into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Exact Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Exact Online.

• Visualize Amazon S3 from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Amazon S3.

• Use the CData Software JDBC Driver for Calendly in MicroStrategy Desktop

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

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

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

• «
• 231
• 232
• 233
• 234
• 235
• 236
• 237
• 238
• 239
• 240
• »