CData Software - Knowledge Base

Recent Articles

• «
• 423
• 424
• 425
• 426
• 427
• 428
• 429
• 430
• 431
• 432
• »

• Replicate Outreach.io to Multiple Databases via the CData Sync CLI

  Replicate Outreach.io to disparate databases with a single configuration.

• Viewing xBase in RAD Studio Data Explorer

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

• Connect to Sage 50 UK from a Connection Pool in JBoss

  Integrate Sage 50 UK into Java servlets: Use the Management Console in JBoss to install the Sage 50 UK JDBC Driver.

• Access Live Veeva Vault in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Veeva Vault & Vault CRM from your Excel spreadsheets.

• How to Create Power BI Visual Reports with Real-Time Google Cloud Storage

  Use CData Power BI Connectors to visualize Google Cloud Storage in Power BI.

• How to connect to Azure Table from IntelliJ

  Integrate connectivity to Azure Table Storage with wizards in IntelliJ.

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

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

• Automated Continuous GitHub Replication to AlloyDB

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

• Build PCA Sales-Connected Apps in Choreo

  Use CData Connect Cloud to connect to PCA Sales from Choreo and build custom apps using live PCA Sales.

• Build Workday-Connected Apps in Choreo

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

• Automated Continuous SAP SuccessFactors Replication to Databricks

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

• Connect to and Visualize Live Google Search Results in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Search.

• Automated Continuous SQL Server Replication to MongoDB

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

• Build a PostgreSQL Interface for WordPress using the CData JDBC Driver

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

• Analyze Microsoft OneDrive with Power Pivot

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

• Access Live Square in SAS JMP via ODBC

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

• Automated Continuous Smartsheet Replication to MySQL

  Use CData Sync for automated, continuous, customizable Smartsheet replication to MySQL.

• Connect to Veeva Vault as an External Source in Dremio

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

• Connect to Raisers Edge NXT from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Raisers Edge NXT, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Automated Continuous Oracle Financials Cloud Replication to Oracle

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

• Build a PostgreSQL Interface for LinkedIn using the CData JDBC Driver

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

• Integrate with live Dynamics 365 Business Central in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Dynamics 365 Business Central in Jitterbit.

• PowerShell Scripting to Replicate Sybase IQ to MySQL

  Write a simple PowerShell script to replicate Sybase IQ to a MySQL database.

• Build Semantic Layer Views for Google Analytics in APOS Live Data Gateway

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

• Using the CData Software ODBC Driver for Avro in PyCharm

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

• Replicate LinkedIn Ads to Multiple Databases via the CData Sync CLI

  Replicate LinkedIn Ads to disparate databases with a single configuration.

• Edit and Search External PayPal Objects in Salesforce Connect

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

• How to Connect to & Open Oracle Eloqua in Microsoft Excel

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

• Automated Continuous Teradata Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Teradata replication to OneLake in Microsoft Fabric.

• DataBind Controls to Okta in C++Builder

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

• Visualize Clio in Sisense

  Create an ElastiCube in Sisense app with access to Clio.

• Automated Continuous XML Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable XML replication to PostgreSQL.

• How to connect SharePoint with Asana through external lists

  Provide Asana to SharePoint users as an external list.

• Use the CData Software ODBC Driver for Bing Search in MicroStrategy Desktop

  Connect to Bing Search in MicroStrategy Desktop using the CData Software ODBC Driver for Bing Search.

• Create Apps from SAP BusinessObjects BI in Qlik Sense Cloud

  Use CData Connect Cloud to connect to SAP BusinessObjects BI and build apps from live SAP BusinessObjects BI in Qlik Sense Cloud.

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

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

• How to Use a Microsoft Access Database to Update Oracle Sales in Real Time

  Update Oracle Sales data by creating a linked table in Microsoft Access with the CData Oracle Sales ODBC Driver.

• Connect to Square in Aqua Data Studio

  Access Square from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Connect to Slack from a Connection Pool in WebLogic

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

• Replicate Multiple Google Contacts Accounts

  Replicate multiple Google Contacts accounts to one or many databases.

• Publish Coinbase-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Coinbase.

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

  Connect to Redis 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.

• Automate Oracle SCM Replication to SAP HANA

  Use CData Sync to customize and automate Oracle SCM replication to SAP HANA.

• Access MariaDB as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MariaDB from your Oracle system.

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

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

• Slowly Changing Dimensions (SCD): A No-Code Approach

  This article introduces SCD and demonstrates implementing SCDs using CData Sync with CDC, dbt, and ELT.

• Access Live MariaDB in SAS JMP via ODBC

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

• Create DocuSign-Connected Nintex Workflows

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

• Connect to Amazon Marketplace from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Amazon Marketplace to connect to Amazon Marketplace from Web applications running on WebLogic.

• Create Salesforce Data Cloud Dataflows on PowerBI.com

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

• A PostgreSQL Interface for Confluence using the CData ODBC Driver

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

• How to update MySQL from Excel

  This article explains how to transfer data from Excel to MySQL using the Excel Add-In for MySQL.

• Importing Google BigQuery Data into H2O

  Use the CData JDBC Driver for Google BigQuery in R and Python to import BigQuery data into H2O for machine learning and AI.

• How to connect to Highrise from Spring Boot

  Connect to Highrise in a Spring Boot Application using CData JDBC Highrise Driver

• Access Azure Active Directory from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Azure Active Directory from HeidiSQL.

• Use the CData Software ODBC Driver for Google Ads in MicroStrategy Desktop

  Connect to Google Ads in MicroStrategy Desktop using the CData Software ODBC Driver for Google Ads.

• Automated Continuous Freshdesk Replication to Oracle

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

• How to connect to SFTP in DBVisualizer

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

• Use JayDeBeApi to access Reckon Accounts Hosted in Python

  Use standard Python scripting and the development environment of your choice to access live Reckon Accounts Hosted.

• Automated Continuous Confluence Replication to Snowflake

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

• Automated Continuous Calendly Replication to SQL Server

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

• Create SSAS Tabular Models from Google Calendar

  How to build a SQL Server Analysis Service Tabular Model from Google Calendar using CData drivers.

• Visualize PayPal in TIBCO Spotfire through ODBC

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

• Integrate Sage Intacct with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Sage Intacct with External Services.

• Extend Google Sheets with Unbounce

  Make calls to the API Server from Google Apps Script.

• Use the CData ODBC Driver for Oracle Sales from SharePoint Excel Services

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

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

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

• Automated Continuous Sybase Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Sybase replication to Amazon S3.

• Feed Exact Online into FineReport

  How to set Exact Online as a JDBC data source in FineReport.

• View Reports on Real-Time Exact Online in Power BI Report Server

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

• Publish Microsoft Teams-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Teams.

• Integrate with Azure Active Directory in JReport Designer

  Create charts and reports based on Azure Active Directory in JReport Designer.

• How to connect PolyBase to SAP Netweaver Gateway

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Netweaver Gateway.

• Bidirectional Access to Excel from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Excel in Filemaker Pro for Mac or Windows.

• Create Twitter-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Twitter from Klipfolio and build custom visualizations using live Twitter.

• Use the CData ODBC Driver for FTP from SharePoint Excel Services

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

• Access Live Zenefits in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Zenefits to create a Zenefits source in TIBCO Data Virtualization Studio and gain access to live Zenefits from your TDV Server.

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

  Connect to Shopify from a connection pool in Tomcat.

• Access Live Tableau CRM Analytics in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Tableau CRM Analytics to create a Tableau CRM Analytics source in TIBCO Data Virtualization Studio and gain access to live Tableau CRM Analytics from your TDV Server.

• Build Semantic Layer Views for Google Drive in APOS Live Data Gateway

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

• How to connect to Jira Service Management with Squirrel SQL client

  Connect to Atlassian Jira Service Management and execute queries in the Squirrel SQL Client.

• Visualize Live ADP in the Power BI Service

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

• Connect to Drip from PowerBuilder via ADO.NET

  This article demonstrates how to access Drip from Appeon PowerBuilder using the CData ADO.NET Provider for Drip.

• Connect to MailChimp in Jaspersoft Studio

  Execute SQL to remote MailChimp in Jaspersoft Studio.

• DataBind Controls to Sage 50 UK in Delphi

  DataBind to Sage 50 UK in Delphi with standard data access components and controls.

• Create Salesforce Pardot-Connected Enterprise Applications in OutSystems

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

• How to publish and share HCL Domino dashboards with Tableau Server

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

• Connect Odoo to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Odoo ERP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Replicate SAP from PowerShell

  Write a quick PowerShell script to query SAP ERP/NetWeaver. Use connectivity to the live data to replicate SAP ERP/NetWeaver to SQL Server.

• Active Directory Reporting in OBIEE with the Active Directory JDBC Driver

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

• How to create an RPA flow for GraphQL in UiPath Studio

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

• Creating PayPal-Connected Applications in Unqork

  You can use CData Connect Cloud to feed PayPal to Unqork and build custom business apps.

• Create Bing Search Dataflows on PowerBI.com

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

• A PostgreSQL Interface for Acumatica (MySQL Remoting via JDBC)

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

• Stream Shippo into Apache Kafka Topics

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

• Connect to HarperDB as a Linked Server via SQL Gateway

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

• Automated Continuous Azure Blob Storage Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to IBM DB2.

• Automated Continuous REST Replication to SQL Server

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

• Integrate GitHub in Your Informatica Cloud Instance

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

• Visualize Live Access in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Access.

• «
• 423
• 424
• 425
• 426
• 427
• 428
• 429
• 430
• 431
• 432
• »