CData Software - Knowledge Base

Recent Articles

• «
• 302
• 303
• 304
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• »

• How to Access Greenplum Using Entity Framework

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

• Integrate Live MariaDB into Custom Business Apps Built in Power Apps

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

• How to load Google Cloud Storage data into Elasticsearch via Logstash

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

• Integrate Confluence into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Atlassian Confluence and integrate live Atlassian Confluence into your Power Automate tasks.

• Access QuickBooks from MySQL in Amazon QuickSight

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

• Analyze SQL Server in Cognos Analytics

  Use CData Connect Cloud to connect to SQL Server from Cognos Analytics and analyze live Microsoft SQL Server.

• Use CData Connect Cloud to Access Bullhorn CRM in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Bullhorn CRM in the Power Pivot business intelligence tool.

• Create Drip-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Drip from Klipfolio and build custom visualizations using live Drip.

• How to pipe Google Cloud Storage to CSV in PowerShell

  Use standard PowerShell cmdlets to access Google Cloud Storage tables.

• Automated Continuous SAP Ariba Source Replication to Databricks

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Databricks.

• Query JSON Services in DataGrip

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

• Connect to Paylocity in DBArtisan

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

• Query, Visualize, and Share live Microsoft Exchange in Redash

  Use CData Connect Cloud to connect to live Microsoft Exchange in Redash for querying, visualizing, and sharing.

• Replicate Act CRM for Use in Salesforce Connect

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

• Automated Continuous IBM Cloud Object Storage Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Azure SQL.

• Automated Continuous Office 365 Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Office 365 replication to delimited files (CSV/TSV).

• Connect to Coinbase in CloverDX (formerly CloverETL)

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

• Use JayDeBeApi to access Trello in Python

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

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

  Create ETL applications and real-time data pipelines for SAP Business ByDesign in Python with petl.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Parquet

  Provide connectivity to Apache Parquet through an SAP BusinessObjects universe.

• Create Sage Cloud Accounting-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Sage Cloud Accounting from Klipfolio and build custom visualizations using live Sage Business Cloud Accounting.

• A PostgreSQL Interface for Azure Data Catalog

  Use the Remoting features of the Azure Data Catalog ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to SAP Hybris C4C in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for SAP Hybris C4C in Airbyte.

• How to work with Marketo in Apache Spark using SQL

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

• Natively Connect to CouchDB in PHP

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

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

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

• Manage Reckon in DBArtisan as a JDBC Source

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

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

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

• How to work with HarperDB in Apache Spark using SQL

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

• Create a Data Access Object for YouTube Analytics using JDBI

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

• DataBind Charts to Google Spanner

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Spanner from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• A PostgreSQL Interface for SingleStore

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

• Build GitHub Visualizations in Tableau Desktop

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

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

  Connect to XML Files in MicroStrategy Web using the CData Software JDBC Driver for XML.

• How to publish and share Google Contacts dashboards with Tableau Server

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

• Connect to Square in Ruby

  Connect to Square in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Query SAP in MySQL Workbench

  Create a virtual MySQL database for SAP ERP/NetWeaver in CData Software Connect (or Connect Server) and work with live SAP ERP/NetWeaver in MySQL Workbench.

• Automate Kafka Replication to SAP HANA

  Use CData Sync to customize and automate Apache Kafka replication to SAP HANA.

• Connect to SAP Ariba Source from a Connection Pool in WebLogic

  Use the CData JDBC Driver for SAP Ariba Source to connect to SAP Ariba Source from Web applications running on WebLogic.

• How to Build Dynamic React Apps with Sage 200

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

• Provide OData Services of MariaDB from a WCF Application

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

• How to Access Live BigCommerce in Power Automate Desktop via ODBC

  The CData ODBC Driver for BigCommerce enables you to integrate BigCommerce into workflows built using Microsoft Power Automate Desktop.

• Create GitHub Reports on JasperReports Server

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

• How to Import Teradata into SQL Server using SSIS

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

• A PostgreSQL Interface for Instagram

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

• Build an OLAP Cube in SSAS from Redshift

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

• Excel Spreadsheet Automation with the QUERY Formula

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

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

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

• Connect to ShipStation from a Connection Pool in WebLogic

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

• Rapidly Develop Zoom-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Import and Visualize Airtable in Power View

  Create data visualizations based on Airtable in Excel.

• Extract, Transform, and Load SAP Fieldglass in Informatica PowerCenter

  Create a simple Workflow for SAP Fieldglass in Informatica PowerCenter.

• Connect to Oracle Eloqua in SpagoBI

  Create reports featuring live Oracle Eloqua in SpagoBI Studio. Host Oracle Eloqua reports on SpagoBI Server.

• Publish Amazon DynamoDB-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Amazon DynamoDB.

• Create Trello-Connected Nintex Workflows

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

• Connect to Sage 50 UK in SpagoBI

  Create reports featuring live Sage 50 UK in SpagoBI Studio. Host Sage 50 UK reports on SpagoBI Server.

• How to Connect to & Open Oracle HCM Cloud in Microsoft Excel

  This article uses the CData ODBC driver for Oracle HCM Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Provide OData Services of Salesforce from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Salesforce & Force.com by developing a WCF Service Application.

• Visualize Greenplum in TIBCO Spotfire through ADO.NET

  Integrate Pivotal GreenPlum into dashboards in TIBCO Spotfire.

• Integrate Parquet in the Pentaho Report Designer

  Publish reports based on Apache Parquet in the Pentaho BI tool.

• Using the CData Software ODBC Driver for Phoenix in PyCharm

  Connect to Phoenix as an ODBC data source in PyCharm using the CData Software ODBC Driver for Phoenix.

• Author and Share Power BI Reports on Real-Time Microsoft Planner

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

• Automated Continuous MongoDB Replication to Google Cloud SQL

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

• Replicate Microsoft Teams from PowerShell

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

• Build Procore Visualizations in Tableau Cloud

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

• Connect to Live SuiteCRM in MicroStrategy through CData Software Connect Server

  Create a virtual database for SuiteCRM in CData Software Connect Server and connect to it from MicroStrategy.

• Use the Connect Server to Access Google Drive in Microsoft Power Pivot

  Use the Connect Server to connect to live Google Drive in the Power Pivot business intelligence tool.

• Publish SAP SuccessFactors-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAP SuccessFactors.

• Analyze Cassandra in Infragistics Reveal

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

• DataBind Charts to Tally

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Tally ERP from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Replicate Multiple FHIR Accounts

  Replicate multiple FHIR accounts to one or many databases.

• DataBind Controls to SharePoint Excel Services in C++Builder

  DataBind to SharePoint Excel Services in C++Builder with standard components and controls.

• Create SSAS Tabular Models from IBM Cloud Data Engine

  How to build a SQL Server Analysis Service Tabular Model from IBM Cloud Data Engine using CData drivers.

• Connect to Jira Service Management in RazorSQL

  Connect to Jira Service Management from wizards and query Atlassian Jira Service Management from the GUI in the RazorSQL database management tool.

• A PostgreSQL Interface for Azure Table

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

• Create Apps from ActiveCampaign in Qlik Sense Cloud

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

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

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

• Connect to DB2 in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous MariaDB Replication to SQL Server

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

• Author and Share Power BI Reports on Real-Time Adobe Analytics

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

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

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

• Access Live HCL Domino in TIBCO Data Virtualization

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

• How to connect and process Oracle HCM Cloud from Azure Databricks

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

• Build Semantic Layer Views for Azure Table in APOS Live Data Gateway

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

• How to create an RPA flow for IBM Cloud Object Storage in UiPath Studio

  Use the IBM Cloud Object Storage ODBC Driver to create workflows that access real-time IBM Cloud Object Storage without any coding.

• Create Reports from Azure Synapse in Looker Studio

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

• Visualize Twilio in TIBCO Spotfire through ADO.NET

  Integrate Twilio into dashboards in TIBCO Spotfire.

• Access Live CockroachDB in Coginiti Pro

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

• Publish Reports with BambooHR in SAP Crystal Reports

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

• Validate ActiveCampaign with QuerySurge

  Access and validate ActiveCampaign in QuerySurge using the CData JDBC Driver.

• Create HubSpot-Connected Enterprise Applications in OutSystems

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

• Create Dynamic PayPal Grids Using the Infragistics XamDataGrid

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

• ETL Jira Service Management in Oracle Data Integrator

  This article shows how to transfer Atlassian Jira Service Management into a data warehouse using Oracle Data Integrator.

• Build TaxJar Visualizations in Tableau Cloud

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

• A PostgreSQL Interface for Highrise

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

• Natively Connect to Invoiced in PHP

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

• xBase Reporting and Star Schemas in OBIEE

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

• Viewing Phoenix in RAD Studio Data Explorer

  How to view Apache Phoenix in RAD Studio Data Explorer using the CData ODBC Driver for Phoenix.

• Natively Connect to Act-On in PHP

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

• Analyze Marketo with Power Pivot

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

• «
• 302
• 303
• 304
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• »