CData Software - Knowledge Base

Recent Articles

• «
• 220
• 221
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• »

• Build Semantic Layer Views for Office 365 in APOS Live Data Gateway

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

• Replicate Smartsheet to Multiple Databases

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

• Replicate Azure Active Directory to Multiple Databases

  Replicate Azure Active Directory to disparate databases with a single configuration.

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

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

• PowerShell Scripting to Replicate QuickBooks Online to MySQL

  Write a simple PowerShell script to replicate QuickBooks Online to a MySQL database.

• Build an OLAP Cube in SSAS from Greenplum

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

• Replicate Multiple Zendesk Accounts

  Replicate multiple Zendesk accounts to one or many databases.

• Validate OData Services with QuerySurge

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

• Access Amazon DynamoDB from MySQL in PHP

  Connect to Amazon DynamoDB through the standard MySQL libraries in PHP.

• Connect to Cloudant in DBeaver

  Use the CData ODBC Driver to connect to IBM Cloudant in DBeaver.

• Access Live Greenplum in Coginiti Pro

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

• Configure the CData JDBC Driver for Google Campaign Manager 360 in a Connection Pool in Tomcat

  Connect to Google Campaign Manager 360 from a connection pool in Tomcat.

• How to load Exact Online data into Elasticsearch via Logstash

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

• How to import Dynamics CRM into Apache Solr

  Use the CData Software JDBC Driver for Dynamics CRM in Data Import Handler and create an automated import of Microsoft Dynamics CRM to Apache Solr Enterprise Search platform.

• Visualize Excel Online in TIBCO Spotfire through ADO.NET

  Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.

• Connect to Facebook Ads in Jaspersoft Studio

  Execute SQL to remote Facebook Ads in Jaspersoft Studio.

• Natively Connect to MailChimp in PHP

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

• How to Build Dynamic React Apps with Zendesk

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

• Automate Stripe Replication to SAP HANA

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

• Provide OData Services of Sage 50 UK from a WCF Application

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

• PowerShell Scripting to Replicate Gmail to MySQL

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

• Integrate Oracle Financials Cloud with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Oracle Financials Cloud with External Services.

• Import SAP Hybris C4C into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to SAP Hybris C4C and provide access to live SAP Hybris C4C for custom reports in the Power BI Service.

• Replicate Salesforce Marketing to Multiple Databases

  Replicate Salesforce Marketing Cloud to disparate databases with a point-and-click configuration.

• Import Real-Time IBM Informix in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use IBM Informix in ColdFusion.

• Automated Continuous IBM Cloud Data Engine Replication to SQLite

  Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to SQLite.

• Process & Analyze SAP Netweaver Gateway in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Netweaver Gateway .

• Prepare, Blend, and Analyze Amazon S3 in Alteryx Designer

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

• Import and Visualize SAP Netweaver Gateway in Power View

  Create data visualizations based on SAP Netweaver Gateway in Excel.

• Create Reports from Azure Analysis Services in Looker Studio

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

• DataBind Charts to SAP BusinessObjects BI

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP BusinessObjects BI 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.

• Automate JSON Services Replication to Azure Synapse

  Use CData Sync to customize and automate JSON replication to Azure Synapse.

• Bridge HDFS Connectivity with Apache NiFi

  Access and process Apache HDFS in Apache NiFi using the CData JDBC Driver.

• Connect to Basecamp in as an External Source in Dremio

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

• Viewing Gmail in RAD Studio Data Explorer

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

• DataBind Charts to Google Data Catalog

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Data Catalog 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 Zoho Creator

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

• How to Import MYOB AccountRight into SQL Server using SSIS

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

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

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

• Connect to Act CRM in NetBeans

  Connect to Act CRM in NetBeans with the data source configuration wizard.

• How to Import Marketo into SQL Server using SSIS

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

• How to connect to Presto in DBVisualizer

  Integrate Presto with visual data analysis tools and data connection wizards in DBVisualizer

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

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

• Use the CData ODBC Driver for HDFS in SAS JMP

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

• Build Google Spanner-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Google Spanner from Choreo and build custom apps using live Google Spanner.

• Connect to Amazon Athena as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Amazon Athena.

• Automated Continuous Google Campaign Manager 360 Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Snowflake.

• How to load Oracle HCM Cloud data into Elasticsearch via Logstash

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

• Visualize Google Data Catalog in TIBCO Spotfire through OData

  Integrate Google Data Catalog into dashboards in TIBCO Spotfire.

• Connect to BigQuery from AWS Glue

  Use CData Connect Cloud to gain access to live Google BigQuery from your AWS Glue jobs.

• Create Reports with Power BI XMLA in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Power BI XMLA.

• How to publish and share EnterpriseDB dashboards with Tableau Server

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

• Create a Data Access Object for Salesforce Marketing using JDBI

  A brief overview of creating a SQL Object API for Salesforce Marketing Cloud in JDBI.

• Visualize SQL Analysis Services in TIBCO Spotfire through ADO.NET

  Integrate SQL Analysis Services into dashboards in TIBCO Spotfire.

• Connect to AlloyDB in RazorSQL

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

• Access Bing Search Results in PHP through Connect Server

  Connect to Bing Search through the standard SQL Server libraries in PHP.

• Natively Connect to Oracle Service Cloud in PHP

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

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

  Use LlamaIndex to query live Twitter Ads data in natural language using Python.

• Visualize Sage 300 from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Sage 300.

• Jira Assets Reporting and Star Schemas in OBIEE

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• How to use SQLAlchemy ORM to access Klaviyo in Python

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

• Automated Continuous Excel Online Replication to Microsoft Access

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

• Connect to Sybase IQ in DBArtisan

  Use wizards in DBArtisan to configure Sybase IQ as a data source.

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

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

• Rapidly Develop Wave Financial-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.

• Query Active Directory in DataGrip

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

• Query Typeform in DataGrip

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

• Automated Continuous Harvest Replication to Microsoft Access

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

• Replicate Pinterest to Multiple Databases

  Replicate Pinterest to disparate databases with a single configuration.

• How to pipe Tableau CRM Analytics to CSV in PowerShell

  Use standard PowerShell cmdlets to access Tableau CRM Analytics tables.

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

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

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

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

• Visualize Live ConstantContact in Tableau

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

• Automated Continuous SAS xpt Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAS xpt replication to IBM DB2.

• Automated Continuous DB2 Replication to Local Delimited Files

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

• Connect to Wave Financial in CloverDX (formerly CloverETL)

  Transfer Wave Financial using the visual workflow in the CloverDX data integration tool.

• Add YouTube Analytics to Informatica Enterprise Data Catalog

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

• How to connect and process HCL Domino from Azure Databricks

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

• How to connect and process Sage 50 UK from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Sage 50 UK

• Create Reports from Greenplum in Looker Studio

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

• Query BigCommerce in MySQL Workbench

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

• How to connect to Adobe Analytics from Spring Boot

  Connect to Adobe Analytics in a Spring Boot Application using CData JDBC Adobe Analytics Driver

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

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

• How to Visualize Twilio Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Twilio in Python.

• How to Connect to & Open SAP Business One in Microsoft Excel

  This article uses the CData ODBC driver for SAP Business One to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Access Live MySQL in Coginiti Pro

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

• Integrate Live Snowflake into Amazon SageMaker Canvas with RDS

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

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

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

• Publish Reports with SAP Netweaver Gateway in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Netweaver Gateway.

• DataBind Wijmo Grid to SAP SuccessFactors

  Provide real-time SAP SuccessFactors to interactive controls.

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

  Use LlamaIndex to query live Bing Ads data in natural language using Python.

• Connect to SAP Ariba Procurement from Asprova with CData Software ODBC Driver for SAP Ariba Procurement

  This article shows how to connect faster to SAP Ariba Procurement data from Asprova.

• Manage Amazon Marketplace in DBArtisan as a JDBC Source

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

• Connect to SurveyMonkey in NetBeans

  Connect to SurveyMonkey in NetBeans with the data source configuration wizard.

• Integrate CouchDB in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache CouchDB from Informatica Cloud.

• Connect to Bing Ads from a Connection Pool in WebLogic

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

• How to Query SAP Fieldglass in MySQL Workbench

  Execute MySQL queries against live SAP Fieldglass from MySQL Workbench.

• Access Live Email in AWS Lambda

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

• Automated Continuous CockroachDB Replication to Apache Cassandra

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

• «
• 220
• 221
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• »