CData Software - Knowledge Base

Recent Articles

• «
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• »

• Automated Continuous Avro Replication to SQL Server

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

• How to create Smartsheet federated tables in MySQL

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

• Validate SAP BusinessObjects BI with QuerySurge

  Access and validate SAP BusinessObjects BI in QuerySurge using the CData JDBC Driver.

• Bill an Invoice with the CData Excel Add-In for QuickBooks

  The CData Excel Add-In for QuickBooks makes it easy to transfer data in and out of QuickBooks Desktop and QuickBooks Online. In this article, you will create an Invoice spreadsheet that can be sent to customers. Customers can then insert the Invoice data as Bills to their company files or their company on QuickBooks Online.

• Add GraphQL to Informatica Enterprise Data Catalog

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

• Connect to Microsoft Project in the Denodo Platform

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

• Create EventBrite-Connected Business Apps in AppSheet

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

• Visualize Live SAP Hybris C4C in the Power BI Service

  Use CData Connect Cloud to connect to live SAP Hybris C4C and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to SuiteCRM as a Linked Server

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

• How to Connect to Amazon S3 in Using Python: 6 Steps

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

• View Reports on Real-Time Amazon DynamoDB in Power BI Report Server

  Use the CData ODBC Driver for Amazon DynamoDB to visualize Amazon DynamoDB in Power BI Desktop and then publish them to Power BI Report Server.

• ETL HDFS in Oracle Data Integrator

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

• Access Live WooCommerce in Google Sheets

  Use CData Connect Cloud to gain access to live WooCommerce from your Google Sheets.

• How to create Power BI XMLA federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Power BI XMLA in MySQL .

• Analyze Salesforce Marketing with Power Pivot

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

• Integrate with IBM Informix in JReport Designer

  Create charts and reports based on IBM Informix in JReport Designer.

• Publish Reports with Office 365 in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Office 365.

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

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

• Using AngularJS to Build Dynamic Web Pages with IBM Cloud Object Storage

  Use the CData Connect Server to create IBM Cloud Object Storage OData feeds and build single-page applications with live IBM Cloud Object Storage.

• Integrate with live HCL Domino in Jitterbit

  Use CData Connect Cloud to connect to and integrate live HCL Domino in Jitterbit.

• How to connect PolyBase to Google Cloud Storage

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

• Prepare, Blend, and Analyze BigQuery in Alteryx Designer

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

• Write a Simple Go Application to work with Microsoft OneDrive on Linux

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

• Integrate with live SAP SuccessFactors in Jitterbit

  Use CData Connect Cloud to connect to and integrate live SAP SuccessFactors in Jitterbit.

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

  Connect to Exact Online 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.

• Prepare, Blend, and Analyze Pinterest in Alteryx Designer

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

• Replicate Jira Service Management to Multiple Databases

  Replicate Atlassian Jira Service Management to disparate databases with a point-and-click configuration.

• Integrate with TaxJar in JReport Designer

  Create charts and reports based on TaxJar in JReport Designer.

• Connect to Live Twitter Ads in MicroStrategy through CData Connect Cloud

  Create a live connection to Twitter Ads in CData Connect Cloud and connect to your Twitter Ads from MicroStrategy.

• DataBind SingleStore to the DevExpress Data Grid

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

• Import Aha into FileMaker Pro

  Create reports that integrate Aha! in Filemaker Pro.

• Automated Continuous Impala Replication to Oracle

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

• Create Data Visualizations in Cognos BI with ShipStation

  Access ShipStation as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• How to Build Dynamic React Apps with Freshdesk

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

• How to Visualize Excel Online Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Microsoft Excel Online in Python.

• Sage 200 Reporting and Star Schemas in OBIEE

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

• How to connect to Odoo from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Odoo and work with Odoo ERP in Microsoft Excel on Mac OS X.

• Automated Continuous Raisers Edge NXT Replication to Databricks

  Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Databricks.

• Import Real-Time Azure Data Catalog in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Azure Data Catalog in ColdFusion.

• Import and Visualize GitHub in Power View

  Create data visualizations based on GitHub in Excel.

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

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

• Create Reports from Freshdesk in Looker Studio

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

• Automated Continuous Sage Cloud Accounting Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to PostgreSQL.

• Build Redis-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Redis.

• How to use SQLAlchemy ORM to access Highrise in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Highrise CRM.

• Build Visualizations of Live Dynamics GP in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Microsoft Dynamics GP and build custom reports in Power BI.

• Connect to Pipedrive as a Linked Server

  Use CData Connect to set up a linked server for Pipedrive.

• Replicate Epicor Kinetic to Multiple Databases

  Replicate Epicor Kinetic to disparate databases with a single configuration.

• Create Data Visualizations Based On Google Contacts in Mode

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

• Import Real-Time Zoho Creator in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Zoho Creator in ColdFusion.

• Automated Continuous QuickBooks Replication to Databricks

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

• How to connect PolyBase to Sage Intacct

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

• How to Work with JDBC-ODBC Bridge in AWS Glue Jobs Using JDBC

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

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

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

• Integrate with Google Data Catalog in JReport Designer

  Create charts and reports based on Google Data Catalog in JReport Designer.

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

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

• Connect to Airtable in HULFT Integrate

  Connect to Airtable as a JDBC data source in HULFT Integrate

• Integrate with Acumatica in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Acumatica ERP in SnapLogic.

• Automate Splunk Replication to SAP HANA

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

• Configure the CData JDBC Driver for Teradata in a Connection Pool in Tomcat

  Connect to Teradata from a connection pool in Tomcat.

• A PostgreSQL Interface for Clio

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

• Access Live SAP Concur in Excel (Desktop)

  Use CData Connect Cloud to gain access to live SAP Concur from your Excel spreadsheets.

• Automate Jira Service Management Replication to Azure Data Lake

  Use CData Sync to customize and automate Atlassian Jira Service Management replication to Azure Data Lake.

• Create Amazon S3 Reports on JasperReports Server

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

• Create Unbounce Dataflows on PowerBI.com

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

• Connect to MariaDB in SpagoBI

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

• Connect to Google Drive in the Denodo Platform

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

• Connect to Live Bing Ads in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Bing Ads in CData Connect Cloud and connect to your Bing Ads from PostgreSQL.

• Integrate Outreach.io in the Pentaho Report Designer

  Publish reports based on Outreach.io in the Pentaho BI tool.

• Query, Visualize, and Share live Twitter Ads in Redash

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

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

  Connect to SAP ERP/NetWeaver in MicroStrategy Web using the CData Software JDBC Driver for SAP.

• Query MYOB AccountRight in DataGrip

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

• Automate Sage 300 Replication to SAP HANA

  Use CData Sync to customize and automate Sage 300 replication to SAP HANA.

• Access Live Greenhouse in Coginiti Pro

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

• Automated Continuous YouTube Analytics Replication to Google BigQuery

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

• Excel Online Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Excel Online through CData Connect Cloud using different applications and tools.

• Connect to Dynamics 365 Business Central in RapidMiner

  Integrate Dynamics 365 Business Central with standard components and data source configuration wizards in RapidMiner Studio.

• Create Outreach.io-Connected Enterprise Applications in OutSystems

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

• Automated Continuous BigCommerce Replication to Local Delimited Files

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

• Connect to Live Presto in MicroStrategy through CData Connect Cloud

  Create a live connection to Presto in CData Connect Cloud and connect to your Presto from MicroStrategy.

• Publish Reports with Teradata in SAP Crystal Reports

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

• Create YouTube Analytics Dataflows on PowerBI.com

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

• Connect to Google Cloud Storage in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Google Cloud Storage as an External Source in Dremio.

• Visualize TigerGraph from Tableau

  Use the Tableau Desktop business intelligence tool to connect to TigerGraph.

• How to create Visio diagrams from Adobe Commerce

  Automatically update Adobe Commerce with the changes you make to Visio master shapes.

• Connect to Unbounce in Google Apps Script

  Use the ODBC Driver for Unbounce and the SQL Gateway to access Unbounce from Google Apps Script.

• Replicate Multiple Sybase Accounts

  Replicate multiple Sybase accounts to one or many databases.

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

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

• Integrate with live Oracle SCM in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Oracle SCM in Jitterbit.

• How to work with Zoho CRM in Apache Spark using SQL

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

• Access Live Google Calendar in AWS Lambda

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

• Connect to Greenhouse in Google Apps Script

  Use the ODBC Driver for Greenhouse and the SQL Gateway to access Greenhouse from Google Apps Script.

• How to pipe Active Directory to CSV in PowerShell

  Use standard PowerShell cmdlets to access Active Directory tables.

• Build Amazon S3-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Amazon S3 and build Amazon S3-connected web apps with Axios.

• How to create Salesforce Marketing federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce Marketing Cloud in MySQL .

• How to Access Aha Using Entity Framework

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

• Build Semantic Layer Views for Amazon S3 in APOS Live Data Gateway

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

• How to connect to Amazon DynamoDB from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Amazon DynamoDB and work with Amazon DynamoDB in Microsoft Excel on Mac OS X.

• Connect to Salesforce Pardot in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Salesforce Pardot in Airbyte.

• Connect to Snowflake in RazorSQL

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

• «
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• »