CData Software - Knowledge Base

Recent Articles

• «
• 456
• 457
• 458
• 459
• 460
• 461
• 462
• 463
• 464
• 465
• »

• How to use SQLAlchemy ORM to access Google Ads in Python

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

• How to update Zoho CRM from Excel

  This article explains how to transfer data from Excel to Zoho CRM using the Excel Add-In for Zoho CRM.

• Connect to Procore from PowerBuilder via JDBC

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

• Automated Continuous IBM Informix Replication to Google BigQuery

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

• Access Live Sybase in TIBCO Data Virtualization

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

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

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

• Build Apps with Live Google Contacts in Adalo using CData Connect Cloud

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

• Query Sage Intacct in ColdFusion

  Write standard ColdFusion data access code to connect to Sage Intacct.

• Connect to Invoiced in HULFT Integrate

  Connect to Invoiced as a JDBC data source in HULFT Integrate

• Automated Continuous Sage 200 Replication to AlloyDB

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

• Trigger LinkedIn IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Analyze Oracle Sales in Looker

  Use CData Connect Cloud to connect to Oracle Sales from Looker and build custom apps using live Oracle Sales.

• Enable the Azure Synapse JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Azure Synapse.

• Create Data Visualizations Based On Workday in Mode

  Use CData Connect Cloud to connect to Workday from Mode and build visualizations using live

• Replicate Twitter for Use in Salesforce Connect

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

• Import Oracle Sales Using Azure Data Factory

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

• Operational Reporting on PayPal from Spotfire Server

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

• Easily Integrate MongoDB in Lazarus Pascal IDE

  Learn how to easily integrate live MongoDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Visualize Live Oracle Sales of Power BI Report Builder in Power BI Service

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

• Import Snapchat Ads into Microsoft Power Query

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

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

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

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

• Visualize SharePoint Excel Services in TIBCO Spotfire through ADO.NET

  Integrate SharePoint Excel Services into dashboards in TIBCO Spotfire.

• How to pipe Excel Online to CSV in PowerShell

  Use standard PowerShell cmdlets to access Excel Online tables.

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

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

• Connect to Unbounce in Aqua Data Studio

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

• Query Sybase through ODBC in Node.js

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

• Connect to Live Yahoo! Japan Data Solution in MicroStrategy through CData Connect Cloud

  Create a live connection to Yahoo! Japan Data Solution in CData Connect Cloud and connect to your Yahoo! Japan Data Solution from MicroStrategy.

• Replicate Multiple Parquet Accounts

  Replicate multiple Parquet accounts to one or many databases.

• Create SSAS Tabular Models from Amazon Marketplace

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

• Build Data Flows from JSON to SQL Server using SSIS

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

• Migrating data from Paylocity to Databricks using CData SSIS Components.

  Easily push Paylocity to Databricks using the CData SSIS Tasks for Paylocity and Databricks.

• Build Visualizations of Salesloft in Birst

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

• Analyze Amazon Athena with Power Pivot

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

• Visualize SQL Server in TIBCO Spotfire through ODBC

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

• Access Live Zoho Creator in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Zoho Creator from your Google Sheets.

• Connect to Dynamics 365 Business Central from AWS Glue

  Use CData Connect Cloud to gain access to live Dynamics 365 Business Central from your AWS Glue jobs.

• Bind Live Gmail Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Gmail data

• Analyze Live Shopify in SAS Viya

  Use CData Connect Cloud to connect to Shopify from SAS Viya and deploy self-service analytics using live Shopify.

• DataBind Controls to Microsoft Dataverse in Delphi

  DataBind to Microsoft Dataverse (CDS) in Delphi with standard data access components and controls.

• Analyze Redis in Infragistics Reveal

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

• Provide OData Services of Amazon Marketplace from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Amazon Marketplace by developing a WCF Service Application.

• LINQ to Parquet

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

• Create Datasets from Zoho Creator in Domo Workbench and Build Visualizations of Zoho Creator in Domo

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

• Connect to eBay as a SQL Server Linked Server

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

• Connect to Redshift in CloverDX (formerly CloverETL)

  Transfer Amazon Redshift using the visual workflow in the CloverDX data integration tool.

• Consume Adobe Analytics OData Feeds in PowerBuilder

  This article demonstrates how to consume Adobe Analytics as OData feeds from PowerBuilder using the API Server.

• How to work with SAP Hybris C4C in Apache Spark using SQL

  Access and process SAP Hybris C4C in Apache Spark using the CData Software JDBC Driver.

• Access SurveyMonkey from MySQL in PHP

  Connect to SurveyMonkey through the standard MySQL libraries in PHP.

• Connect to NetSuite in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Access Zoho CRM from MySQL in Amazon QuickSight

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

• Import Real-Time Smartsheet via JDBC in ColdFusion to Build Applications

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

• Use the CData Software JDBC Driver for SAP Netweaver Gateway in MicroStrategy Desktop

  Connect to SAP Netweaver Gateway in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Netweaver Gateway.

• Automate Dynamics 365 Replication to SAP HANA

  Use CData Sync to customize and automate Microsoft Dynamics 365 replication to SAP HANA.

• Connect to and Visualize Live Google Spanner in Tableau Prep

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

• Automated Continuous LinkedIn Ads Replication to Databricks

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

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

• Easily Integrate Google Spanner in Lazarus Pascal IDE

  Learn how to easily integrate live Google Spanner in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Build Active Directory-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Active Directory and create custom apps in Bubble.

• Publish Crystal Reports on IBM Cloud Data Engine

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date IBM Cloud Data Engine.

• Create SSAS Tabular Models from WooCommerce

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

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

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

• Integrate QuickBooks in Your Informatica Cloud Instance

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

• Work with Okta in FoxPro

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

• Automated Continuous SQL Server Replication to Vertica

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

• Connect to Teradata in DBArtisan

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

• Connect to Google Spanner in DBArtisan

  Use wizards in DBArtisan to configure Google Spanner as a data source.

• Publish GitHub-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live GitHub.

• Analyze Redis in Looker

  Use CData Connect Cloud to connect to Redis from Looker and build custom apps using live Redis.

• Create BCart-Connected Nintex Workflows

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

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

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

• Create a Data Access Object for Reckon using JDBI

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

• Integrate Coinbase in Pentaho Data Integration

  Build ETL pipelines based on Coinbase in the Pentaho Data Integration tool.

• How to Query Live Azure Active Directory Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Azure Active Directory data in natural language using Python.

• How to connect PolyBase to SuiteCRM

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SuiteCRM.

• Connect to CouchDB from a Connection Pool in WebLogic

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

• Connect to Avro in RazorSQL

  Connect to Avro from wizards and query Apache Avro from the GUI in the RazorSQL database management tool.

• Integrate with Google Campaign Manager 360 in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Google Campaign Manager 360 in SnapLogic.

• Import OneNote Using Azure Data Factory

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

• Automated Continuous PayPal Replication to MongoDB

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

• Create Datasets from Quickbase in Domo Workbench and Build Visualizations of Quickbase in Domo

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

• Add Printful to Informatica Enterprise Data Catalog

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

• Automated Continuous Pinterest Replication to SingleStore

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

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

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

• Access SAP Netweaver Gateway 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 SAP Netweaver Gateway.

• Connect to SAP BusinessObjects BI from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time SAP BusinessObjects BI using standard SQL.

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

  You can use the CData SAP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP ERP/NetWeaver into Microsoft Power Query.

• Create Informatica Mappings From/To a JDBC Data Source for SAP Netweaver Gateway

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

• ETL DocuSign in Oracle Data Integrator

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

• How to Connect DBeaver to Oracle SCM via a JDBC Driver

  Manage Oracle SCM with visual tools in DBeaver like the query browser.

• Analyze Square in R via ODBC

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

• Connect to Raisers Edge NXT in Jaspersoft Studio

  Execute SQL to remote Raisers Edge NXT in Jaspersoft Studio.

• Automated Continuous Salesforce Marketing Replication to PostgreSQL

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

• Connect to TigerGraph in Claris FileMaker Pro

• «
• 456
• 457
• 458
• 459
• 460
• 461
• 462
• 463
• 464
• 465
• »