CData Software - Knowledge Base

Recent Articles

• «
• 215
• 216
• 217
• 218
• 219
• 220
• 221
• 222
• 223
• 224
• »

• PowerShell Scripting to Replicate SAS xpt to MySQL

  Write a simple PowerShell script to replicate SAS XPORT to a MySQL database.

• Publish Reports with Snapchat Ads in SAP Crystal Reports

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

• Stream Microsoft Exchange into Apache Kafka Topics

  Access and stream Microsoft Exchange in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• How to integrate Metabase with Databricks

  Use CData Connect Cloud to connect to live Databricks and create an interactive dashboard in Metabase from Databricks.

• Work with Live MongoDB in Power Query

  Use CData Connect Cloud to connect to MongoDB and work with live MongoDB in Microsoft Power Query.

• How to Connect the Power BI Service to Acumatica: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• How to create an RPA flow for Amazon DynamoDB in UiPath Studio

  Use the Amazon DynamoDB ODBC Driver to create workflows that access real-time Amazon DynamoDB without any coding.

• Connect to SuiteCRM in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to load HubSpot data into Elasticsearch via Logstash

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

• Create Informatica Mappings From/To an ODBC Data Source for ServiceNow

  Create an ODBC connection to ServiceNow in Informatica and browse and transfer ServiceNow.

• How to connect to Elasticsearch in DBVisualizer

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

• Automated Continuous LDAP Replication to Apache Kafka

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

• How to use SQLAlchemy ORM to access Power BI XMLA in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Power BI XMLA.

• Model Oracle HCM Cloud Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Oracle HCM Cloud, enabling the direct import of real-time Oracle HCM Cloud.

• Build Adobe Commerce-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Adobe Commerce and create custom apps in Mendix.

• Query Dynamics 365 in DataGrip

  Create a Data Source for Dynamics 365 in DataGrip and use SQL to query live Microsoft Dynamics 365.

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

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

• Query Xero in ColdFusion

  Write standard ColdFusion data access code to connect to Xero Accounting.

• Automated Continuous Sage 50 UK Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to SQL Server.

• Validate eBay Analytics with QuerySurge

  Access and validate eBay Analytics in QuerySurge using the CData JDBC Driver.

• Connect to DB2 in DBArtisan

  Use wizards in DBArtisan to configure IBM DB2 as a data source.

• Neo4J Reporting and Star Schemas in OBIEE

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

• Integrate with SAP Ariba Source using Apache Camel2

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

• Build an OLAP Cube in SSAS from HubDB

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

• Integrate with Freshdesk in JReport Designer

  Create charts and reports based on Freshdesk in JReport Designer.

• Connect to HDFS in Ruby

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

• Automated Continuous Google Ads Replication to Microsoft Access

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

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

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

• Connect to Google Cloud Storage from Asprova with CData Software ODBC Driver for Google Cloud Storage

  This article shows how to connect faster to Google Cloud Storage data from Asprova.

• Create Dynamic Procore Grids Using the Infragistics XamDataGrid

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

• Connect to MongoDB from Filemaker Pro (Mac)

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

• Working with Oracle Financials Cloud in LINQPad

  Execute LINQ queries to Oracle Financials Cloud in LINQPad.

• Integrate with BambooHR using Apache Camel2

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

• Using CData JDBC Drivers in ColdFusion

  This article will demonstrate how to use the CData JDBC Drivers with ColdFusion. Included are steps for adding the CData JDBC Driver as a data source, as well as basic ColdFusion code to query the data source and display results.

• Connect to BigQuery in Google Apps Script

  Use CData Connect Cloud to access Google BigQuery in Google Apps Script.

• How to use SQLAlchemy ORM to access Tally in Python

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

• Access MailChimp in PHP through Connect Server

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

• Connect to Google Ads from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Google Ads from Crystal Reports.

• Establish a Live Connection with Power BI XMLA using Tableau Bridge

  The CData ODBC Driver for Power BI XMLA enables you to integrate live Power BI XMLA into Tableau Cloud dashboards using the Tableau Bridge.

• Connect to SAS Data Sets in CloverDX (formerly CloverETL)

  Transfer SAS Data Sets using the visual workflow in the CloverDX data integration tool.

• Access EnterpriseDB from MySQL in Amazon QuickSight

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

• Integrate Real-Time Access to Kintone in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Kintone in real time.

• DataBind Controls to SharePoint in C++Builder

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

• DataBind Charts to Trello

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

• Connect to Oracle Service Cloud from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Oracle Service Cloud from Filemaker Pro on Mac.

• Write a Simple Go Application to work with SAP Ariba Source on Linux

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

• Automate Quickbase Replication to Couchbase

  Use CData Sync to Customize and automate Quickbase replication to Couchbase.

• Integrate SAP ByDesign with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate SAP ByDesign with External Services.

• Model Google Calendar Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Google Calendar, enabling the direct import of real-time Google Calendar.

• How to Work with Google Search Results in AWS Glue Jobs Using JDBC

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

• A PostgreSQL Interface for Xero

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

• HubSpot Reporting in OBIEE with the HubSpot JDBC Driver

  Deploy the HubSpot JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Creating SQL Server-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Microsoft SQL Server to Unqork and build custom business apps.

• How to connect to Zoho Creator from Spring Boot

  Connect to Zoho Creator in a Spring Boot Application using CData JDBC Zoho Creator Driver

• Add SharePoint to Informatica Enterprise Data Catalog

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

• Connect to Square in Jaspersoft Studio

  Execute SQL to remote Square in Jaspersoft Studio.

• How to integrate Metabase with Paylocity

  Use CData Connect Cloud to connect to live Paylocity and create an interactive dashboard in Metabase from Paylocity.

• Work with Live Amazon DynamoDB in Power Query

  Use CData Connect Cloud to connect to Amazon DynamoDB and work with live Amazon DynamoDB in Microsoft Power Query.

• Access SAS xpt from MySQL in PHP

  Connect to SAS xpt through the standard MySQL libraries in PHP.

• Analyze Stripe in R

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

• Build Apps with Live Microsoft Dataverse (CDS) in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Microsoft Dataverse (CDS) into the Adalo platform and build custom mobile and web applications with real-time Microsoft Dataverse (CDS).

• Use the Connect Server to Access SAS xpt in Microsoft Power Pivot

  Use the Connect Server to connect to live SAS XPORT in the Power Pivot business intelligence tool.

• Automated Continuous EventBrite Replication to Vertica

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

• Bridge Couchbase Connectivity with Apache NiFi

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

• Automated Continuous ShipStation Replication to IBM DB2

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

• Integrate Aha in the Pentaho Report Designer

  Publish reports based on Aha! in the Pentaho BI tool.

• Create Apps from Google Contacts in Qlik Sense Cloud

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

• Use JayDeBeApi to access MarkLogic in Python

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

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

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

• Connect to Live Workday in MicroStrategy through CData Connect Cloud

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

• How to connect and process AlloyDB from Azure Databricks

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

• Connect to Unbounce in RapidMiner

  Integrate Unbounce with standard components and data source configuration wizards in RapidMiner Studio.

• Manage SQL Analysis Services in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SQL Analysis Services.

• Connect to Cloudant in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for IBM Cloudant in Airbyte.

• How to connect to Azure Table with Squirrel SQL client

  Connect to Azure Table Storage and execute queries in the Squirrel SQL Client.

• Create SAP Fieldglass-Connected Visualizations in Klipfolio

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

• Access Reporting and Star Schemas in OBIEE

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

• Connect to Avalara AvaTax in as an External Source in Dremio

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

• Use the CData SSIS Components to Insert New or Update Existing Sage Cloud Accounting Records from SQL Server

  Easily push SQL Server data to Sage Cloud Accounting using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sage Cloud Accounting or update existing records with data from a SQL Server database.

• Automated Continuous Tally Replication to Vertica

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

• Connect to Epicor Kinetic in Ruby

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

• Use Biml to Build SSIS Tasks to Replicate Microsoft Exchange to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Exchange to SQL Server.

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

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

• DataBind Controls to SAP Ariba Source in Delphi

  DataBind to SAP Ariba Source in Delphi with standard data access components and controls.

• Import Real-Time Aha in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Aha! in ColdFusion.

• Build Apps with Live Zoho Projects Using the Low-Code Development Platform of Mendix

• «
• 215
• 216
• 217
• 218
• 219
• 220
• 221
• 222
• 223
• 224
• »