CData Software - Knowledge Base

Recent Articles

• «
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• »

• Automated Continuous Invoiced Replication to Apache Kafka

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

• Excel Spreadsheet Automation on Active Directory with the QUERY Formula

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

• Connect to Sugar CRM from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Sugar CRM from Crystal Reports.

• Connect to Google Drive in DBeaver

  Use the CData ODBC Driver to connect to Google Drive in DBeaver.

• Connect to Live Zoho Inventory in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Zoho Inventory in CData Connect Cloud and connect to your Zoho Inventory from PostgreSQL.

• Extract, Transform, and Load Microsoft OneDrive in Informatica PowerCenter

  Create a simple Workflow for Microsoft OneDrive in Informatica PowerCenter.

• Oracle Service Cloud Reporting in OBIEE with the Oracle Service Cloud JDBC Driver

  Deploy the Oracle Service Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Use JayDeBeApi to access Box in Python

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

• Analyze SAP Netweaver Gateway in R via JDBC

  Use standard R functions and the development environment of your choice to analyze SAP Netweaver Gateway with the CData JDBC Driver for SAP Netweaver Gateway.

• Use the CData Software JDBC Driver for Square in MicroStrategy Desktop

  Connect to Square in MicroStrategy Desktop using the CData Software JDBC Driver for Square.

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

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

• Query, Visualize, and Share live Zoho Books in Redash

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

• Create a Data Access Object for Marketo using JDBI

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

• MYOB AccountRight Reporting in OBIEE with the MYOB AccountRight JDBC Driver

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

• Integrate with live Reckon in Jitterbit

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

• Connect to and Visualize Live Clio in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Clio.

• Natively Connect to Sage Intacct in PHP via ODBC (Linux)

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

• Visualize SAP SuccessFactors in TIBCO Spotfire through ODBC

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

• Load Instagram to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Instagram to a database.

• How to publish and share CouchDB dashboards with Tableau Server

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

• Connect to MongoDB through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with MongoDB using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Create a Data Access Object for Amazon Marketplace using JDBI

  A brief overview of creating a SQL Object API for Amazon Marketplace in JDBI.

• Automated Continuous Confluence Replication to Apache Cassandra

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

• Extract, Transform, and Load Google Directory in Informatica PowerCenter

  Create a simple Workflow for Google Directory in Informatica PowerCenter.

• Automated Continuous Sybase IQ Replication to Google Cloud SQL

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

• Using the CData Software ODBC Driver for BambooHR in PyCharm

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

• Build Azure Analysis Services Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Azure Analysis Services and build visualizations in Tableau.

• Connect to Twitter in the Denodo Platform

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

• Build Automated Workflows with Live MYOB AccountRight in Workato

  Use CData Connect Cloud to connect to live MYOB AccountRight and build automated workflows in Workato.

• Connect to Zoho Inventory in Ruby

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

• How to Visualize Tally Data in Python with pandas

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

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

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

• Import YouTube Analytics Using Azure Data Factory

  Use CData Connect Cloud to connect to YouTube Analytics from Azure Data Factory and import live YouTube Analytics.

• Analyze XML in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of XML Files and visualize live XML Files in Ingragistics Reveal.

• Create Dynamic Azure Table Grids Using the Infragistics XamDataGrid

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

• ETL Zoho CRM in Oracle Data Integrator

  This article shows how to transfer Zoho CRM into a data warehouse using Oracle Data Integrator.

• Easily Integrate HBase in Lazarus Pascal IDE

  Learn how to easily integrate live Apache HBase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• 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.

• Connect to TigerGraph from a Connection Pool in Jetty

  The TigerGraph JDBC Driver supports connection pooling: This article shows how to connect faster to TigerGraph from Web apps in Jetty.

• How to create an RPA flow for SAP HANA XS Advanced in UiPath Studio

  Use the SAP HANA XS Advanced ODBC Driver to create workflows that access real-time SAP HANA XS Advanced without any coding.

• Automate Cvent Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Cvent from PowerShell? This article demonstrates how to utilize the Cvent Cmdlets for tasks like connecting to Cvent, automating operations, downloading data, and more.

• How to pipe SAS Data Sets to CSV in PowerShell

  Use standard PowerShell cmdlets to access SAS Data Sets tables.

• Viewing QuickBooks Online in RAD Studio Data Explorer

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

• Replicate Presto to Multiple Databases via the CData Sync CLI

  Replicate Presto to disparate databases with a single configuration.

• Use the CData SSIS Components to Insert New or Update Existing Dynamics CRM Records from SQL Server

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

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

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

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

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

• Use the CData ODBC Driver for Google Ads from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Google Ads to connect to Google Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Ads in Excel.

• Create Dashboards and Visualize Live Zoho CRM in Geckoboard

  Use CData Connect Cloud to connect to live Zoho CRM and create dashboards for real-time monitoring and visualization in Geckoboard.

• Automate Facebook Ads Replication to Azure Synapse

  Use CData Sync to customize and automate Facebook Ads replication to Azure Synapse.

• Import Real-Time eBay Analytics via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use eBay Analytics in ColdFusion.

• Natively Connect to BambooHR in PHP via ODBC (Linux)

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

• Connect to LinkedIn Ads in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for LinkedIn Ads in Airbyte.

• LINQ to Access

  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 Access Data Provider.

• Create Data Visualizations Based On Adobe Commerce in Mode

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

• Query Salesforce as a SQL Server Database in Node.js

  Execute SQL Server queries against Salesforce & Force.com from Node.js.

• Use the CData Software ODBC Driver for Google Data Catalog in MicroStrategy

  Connect to Google Data Catalog in MicroStrategy Developer using the CData Software ODBC Driver for Google Data Catalog.

• Connect to DocuSign from PowerBuilder via JDBC

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

• How to create Azure Data Lake Storage federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Data Lake Storage in MySQL .

• Integrate Live Dynamics 365 Business Central into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• »