CData Software - Knowledge Base

Recent Articles

• «
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• »

• How to use SQLAlchemy ORM to access Raisers Edge NXT in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Raisers Edge NXT.

• Operational Reporting on Oracle Eloqua from Spotfire Server

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

• OLAP Reporting Directly from QuickBooks using ComponentOne OLAP for WinForms

  Rich Dudley from ComponentOne explores using the CData QuickBooks Data Provider and ComponentOne OLAP to build a powerful QuickBooks reporting application, all without writing a single line of code.

• How to Work with Google Cloud Storage in ETL Validator JDBC

  Connect to Google Cloud Storage from ETL Validator jobs using the CData Software JDBC Driver.

• Automated Continuous Printful Replication to Oracle

  Use CData Sync for automated, continuous, customizable Printful replication to Oracle.

• How to work with SAP HANA in Apache Spark using SQL

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

• Enable the Microsoft OneDrive JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Microsoft OneDrive.

• Visualize Marketo in Sisense

  Create an ElastiCube in Sisense app with access to Marketo.

• Create SAP Ariba Procurement Dataflows on PowerBI.com

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

• Visualize Square in TIBCO Spotfire through ODBC

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

• Connect to Amazon S3 from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Amazon S3 from Filemaker Pro on Mac.

• Visualize Dynamics 365 in Sisense

  Create an ElastiCube in Sisense app with access to Microsoft Dynamics 365.

• Create Informatica Mappings From/To a JDBC Data Source for Excel Online

  Create Excel Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Connect to Google Analytics in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Google Analytics in Airbyte.

• Create Neo4J-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Neo4J from AppSheet and build custom business apps using live Neo4J.

• Automated Continuous Snapchat Ads Replication to AlloyDB

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

• Create Shippo-Connected Nintex Workflows

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

• Automated Continuous Google Sheets Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Google Sheets replication to Apache Kafka.

• Create Data Visualizations Based On Confluence in Mode

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

• Integrate with PayPal using Apache Camel2

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

• Automated Continuous BambooHR Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable BambooHR replication to Microsoft Access.

• Prepare, Blend, and Analyze WooCommerce in Alteryx Designer

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

• Automated Continuous Phoenix Replication to AlloyDB

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

• Prepare, Blend, and Analyze JSON Services in Alteryx Designer

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

• Use Dash to Build to Web Apps on Xero

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

• Connect to Google Sheets in JRuby

  Create a simple JRuby app with access to live Google Sheets.

• A PostgreSQL Interface for Splunk

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

• Import Real-Time Parquet in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Apache Parquet in ColdFusion.

• Query Act CRM through ODBC in Node.js

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

• Visualize Live Dynamics 365 in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dynamics 365.

• Build Monday.com-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Monday.com from Choreo and build custom apps using live Monday.com.

• Connect to MarkLogic in SpagoBI

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

• Prepare, Blend, and Analyze Zoom in Alteryx Designer

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

• How to Create Power BI Visual Reports with Real-Time Sybase

  Use CData Power BI Connectors to visualize Sybase in Power BI.

• Replicate Cloudant to Multiple Databases

  Replicate IBM Cloudant to disparate databases with a single configuration.

• Access Workday in PHP through Connect Server

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

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

  Use CData Software Connect Server to create a virtual SQL Server Database for MarkLogic and integrate live MarkLogic into apps built in Microsoft Power Apps.

• Connect to Sage Cloud Accounting from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Sage Business Cloud Accounting from Crystal Reports.

• DataBind Wijmo Grid to Amazon S3

  Provide real-time Amazon S3 to interactive controls.

• Import Zoho Projects Using Azure Data Factory

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

• Visualize Live Zuora in Tableau

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

• Build RSS-Connected Dashboards in Redash

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

• Analyze WordPress with Power Pivot

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

• Add Exact Online to Informatica Enterprise Data Catalog

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

• Connect to SAP HANA XS Advanced in DBeaver

  Use the CData ODBC Driver to connect to SAP HANA XS Advanced in DBeaver.

• Replicate NetSuite to Multiple Databases

  Replicate NetSuite CRM & ERP to disparate databases with a point-and-click configuration.

• Connect to Azure Active Directory in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Azure Active Directory as an External Source in Dremio.

• How to Work with Adobe Commerce in ETL Validator JDBC

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

• Connect to WooCommerce from PowerBuilder

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

• Replicate Multiple Dynamics CRM Accounts

  Replicate multiple Dynamics CRM accounts to one or many databases.

• Connect to Spark in RapidMiner

  Integrate Apache Spark SQL with standard components and data source configuration wizards in RapidMiner Studio.

• Automated Presto Replication to Teradata

  Use CData Sync to Customize and automate Presto replication to Teradata.

• Connect to Gmail from HeidiSQL

  Use CData Connect Cloud to connect to and query live Gmail from HeidiSQL.

• Connect to EnterpriseDB in JRuby

  Create a simple JRuby app with access to live EnterpriseDB.

• Connect to Azure Table from AWS Glue

  Use CData Connect Cloud to gain access to live Azure Table Storage from your AWS Glue jobs.

• Build an OLAP Cube in SSAS from SendGrid

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

• Connect to Salesforce Pardot in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Salesforce Pardot as an External Source in Dremio.

• Connect to Microsoft Project in DBArtisan

  Use wizards in DBArtisan to configure Microsoft Project as a data source.

• LINQ to Google Ad Manager

  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 Google Ad Manager Data Provider.

• Create Reports from Zoho Inventory in Looker Studio

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

• Integrate Authorize.Net into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Authorize.Net and integrate live Authorize.Net into your Power Automate (Microsoft Flow) tasks.

• Connect to Sage Cloud Accounting in JRuby

  Create a simple JRuby app with access to live Sage Business Cloud Accounting.

• Connect to MariaDB in Jaspersoft Studio

  Execute SQL to remote MariaDB in Jaspersoft Studio.

• Connect to Google Ads in HULFT Integrate

  Connect to Google Ads as a JDBC data source in HULFT Integrate

• Connect to Snapchat Ads in CloverDX (formerly CloverETL)

  Transfer Snapchat Ads using the visual workflow in the CloverDX data integration tool.

• How to connect Amazon QuickSight to Amazon Marketplace

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

• Explore Geographical Relationships in Square with Power Map

  Create data visualizations with Square in Power Map.

• Aha Reporting and Star Schemas in OBIEE

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

• Certinia Reporting and Star Schemas in OBIEE

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

• Provide OData Services of Workday from a WCF Application

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

• Automated Continuous Zoho Creator Replication to MongoDB

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

• Replicate Klaviyo to Multiple Databases

  Replicate Klaviyo to disparate databases with a point-and-click configuration.

• How to Create Power BI Visual Reports with Real-Time Klaviyo

  Use CData Power BI Connectors to visualize Klaviyo in Power BI.

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

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

• Connect to HBase in HULFT Integrate

  Connect to HBase as a JDBC data source in HULFT Integrate

• Access Live Bullhorn CRM in Coginiti Pro

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

• How to load Dynamics 365 Business Central data into Elasticsearch via Logstash

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

• Connect to Microsoft Dataverse through External Services in Salesforce

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

• Connect to SAP HANA XS Advanced in CloverDX (formerly CloverETL)

  Transfer SAP HANA XS Advanced using the visual workflow in the CloverDX data integration tool.

• Automate Paylocity Replication to Azure Data Lake

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

• Integrating Google Calendar in Talend Cloud Data Management Platform

• «
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• »