CData Software - Knowledge Base

Recent Articles

• «
• 337
• 338
• 339
• 340
• 341
• 342
• 343
• 344
• 345
• 346
• »

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

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

• DataBind Controls to eBay in Delphi

  DataBind to eBay in Delphi with standard data access components and controls.

• Access Live SAP ByDesign in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live SAP Business ByDesign from your Google Sheets.

• Use Biml to Build SSIS Tasks to Replicate Zoho Inventory to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Inventory to SQL Server.

• Shopify Reporting and Star Schemas in OBIEE

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

• Edit and Search External HCL Domino Objects in Salesforce Connect

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

• Access Live Microsoft Teams in Coginiti Pro

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

• Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy Web

  Connect to Dynamics 365 Business Central in MicroStrategy Web using the CData Software ODBC Driver for Dynamics 365 Business Central.

• Automated Continuous Sage 200 Replication to Amazon S3

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

• Connect to SAP Concur in Google Apps Script via SQL Gateway

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

• Access Live Salesforce in Coginiti Pro

  Connect to and query live Salesforce & Force.com from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Automated Continuous Coinbase Replication to IBM DB2

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

• Connect to Marketo as an External Source in Dremio

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

• Use Biml to Build SSIS Tasks to Replicate SAP HANA to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP HANA to SQL Server.

• Connect to Blackbaud FE NXT in RapidMiner

  Integrate Blackbaud FE NXT with standard components and data source configuration wizards in RapidMiner Studio.

• Seamlessly Bring Adobe Analytics into Retool Using CData Connect Cloud

  Integrate Adobe Analytics data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Integrate with LinkedIn in SnapLogic

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

• Build Data Flows from Certinia to SQL Server using SSIS

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

• Access REST from MySQL in PHP

  Connect to REST through the standard MySQL libraries in PHP.

• Integrate Live Google Analytics into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Google Analytics and integrate live Google Analytics into apps built in Microsoft Power Apps.

• Connect to Google Ads from Filemaker Pro (Mac)

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

• Create SSAS Tabular Models from Microsoft Project

  How to build a SQL Server Analysis Service Tabular Model from Microsoft Project using CData drivers.

• Use the CData Software ODBC Driver for NetSuite in MicroStrategy Desktop

  Connect to NetSuite CRM & ERP in MicroStrategy Desktop using the CData Software ODBC Driver for NetSuite.

• How to connect to Zoho Creator from MS Excel on Mac OS X

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

• Excel Spreadsheet Automation on Sybase with the QUERY Formula

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

• Use the CData ODBC Driver for SAP Fieldglass in Microsoft Power Query

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

• How to connect to Zoom with Squirrel SQL client

  Connect to Zoom and execute queries in the Squirrel SQL Client.

• Integrate with Smaregi in SnapLogic

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

• Automated Continuous Bing Search Replication to MySQL

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

• Easily Integrate Sybase IQ in Lazarus Pascal IDE

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

• How to create Visio diagrams from Google Spanner

  Automatically update Google Spanner with the changes you make to Visio master shapes.

• Connect to Dynamics NAV as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics NAV.

• Use JayDeBeApi to access Marketo in Python

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

• Build SurveyMonkey-Connected ETL Processes in Google Data Fusion

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

• Build Okta-Connected ETL Processes in Google Data Fusion

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

• Object-Relational Mapping (ORM) with Drift Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Drift into a Java-based ORM framework, Hibernate.

• Automated Continuous Sybase IQ Replication to PostgreSQL

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

• How to create Visio diagrams from Reckon

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

• Integrate with live Slack in Jitterbit

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

• Automated Continuous Sage 50 UK Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Google BigQuery.

• Integrate Box in Your Informatica Cloud Instance

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

• Connect to and Query Microsoft Planner in QlikView over ODBC

  Create data visualizations with Microsoft Planner in QlikView.

• Create Calendly-Connected Visualizations in Klipfolio

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

• Excel Spreadsheet Automation on Dynamics 365 Business Central with the QUERY Formula

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

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

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

• How to connect to Adobe Analytics from MS Excel on Mac OS X

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

• Enable the IBM Cloud Object Storage JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with IBM Cloud Object Storage.

• Access Live Trello in Google Sheets via Connect Cloud

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

• Create Slack-Connected Dashboards in Grafana

  Connect to Slack via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Slack.

• Connect to Jira Assets in RapidMiner

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

• Automate IBM Cloud Object Storage Replication to SAP HANA

  Use CData Sync to customize and automate IBM Cloud Object Storage replication to SAP HANA.

• Build Google Sheets-Connected Web Apps with Axios and CData Connect Cloud

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

• Automated Continuous Invoiced Replication to Apache Cassandra

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

• View Reports on Real-Time SAP Business One in Power BI Report Server

  Use the CData ODBC Driver for SAP Business One to visualize SAP Business One in Power BI Desktop and then publish them to Power BI Report Server.

• Automate ActiveCampaign Integration Tasks from PowerShell

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

• Use Biml to Build SSIS Tasks to Replicate Zoho CRM to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho CRM to SQL Server.

• Write a Simple Go Application to work with Exact Online on Linux

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

• How to connect to Slack from Spring Boot

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

• Build Google Ads-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Google Ads.

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

  Connect to Azure Cosmos DB from a connection pool in Tomcat.

• Build Smartsheet Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Smartsheet and build visualizations in Tableau Cloud.

• Create Azure Table-Connected Nintex Workflows

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

• Access Live Zoho Inventory in TIBCO Data Virtualization

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

• Connect to Oracle SCM in DBArtisan

  Use wizards in DBArtisan to configure Oracle SCM as a data source.

• Replicate Multiple Marketo Accounts

  Replicate multiple Marketo accounts to one or many databases.

• Work with Slack in FoxPro

  Load Slack into a FoxPro database. This article includes full code and a walk-through of the process.

• Connect to MongoDB from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for MongoDB to connect to MongoDB and execute queries in PowerBuilder.

• Create Oracle HCM Cloud Reports on JasperReports Server

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

• Connect to Zenefits in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for Zenefits and connect to Zenefits in Akorbi Digital RunMyProcess.

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

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

• Creating Presto-Connected Applications in Unqork

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

• Create Data Visualizations in Cognos BI with Jira Assets

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

• Snowflake Drivers: How to Setup and Use OAuth Authentication

  A guide on configuring OAuth authentication in Snowflake and using OAuth authentication with CData Snowflake solutions.

• A PostgreSQL Interface for LinkedIn using the CData ODBC Driver

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

• How to connect PolyBase to Zoho CRM

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

• Analyze Sage 200 in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Sage 200 with the CData JDBC Driver for Sage 200.

• Connect to ServiceNow from Asprova with CData Software ODBC Driver for ServiceNow

  This article shows how to connect faster to ServiceNow data from Asprova.

• View Reports on Real-Time Oracle Service Cloud in Power BI Report Server

  Use the CData ODBC Driver for Oracle Service Cloud to visualize Oracle Service Cloud in Power BI Desktop and then publish them to Power BI Report Server.

• Analyze IBM Informix in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of IBM Informix and visualize IBM Informix in SAP Analytics Cloud.

• Query Wave Financial in MySQL Workbench

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

• Create SAS xpt-Connected Nintex Workflows

  Use CData Software Connect Server to connect to SAS xpt from Nintex Workflow Cloud and build custom workflows using live SAS XPORT.

• Visualize Live Oracle Sales in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Oracle Sales into custom reports in Power BI.

• Feed Reckon Accounts Hosted into FineReport

  How to set Reckon Accounts Hosted as a JDBC data source in FineReport.

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

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

• Connect to and Query LinkedIn Ads in QlikView over ODBC

  Create data visualizations with LinkedIn Ads in QlikView.

• Import Google Directory Using Azure Data Factory

  Use CData Connect Cloud to connect to Google Directory from Azure Data Factory and import live Google Directory.

• Connect to and Visualize Live Pipedrive in Tableau Prep

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

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

  Connect to ClickUp from a connection pool in Tomcat.

• How to Connect DBeaver to Google Ads via a JDBC Driver

  Manage Google Ads with visual tools in DBeaver like the query browser.

• Visualize Sybase IQ in Sisense

  Create an ElastiCube in Sisense app with access to Sybase IQ.

• Connect to Live Parquet in MicroStrategy through CData Software Connect Server

  Create a virtual database for Parquet in CData Software Connect Server and connect to it from MicroStrategy.

• Visualize QuickBooks Online from Tableau

  Use the Tableau Desktop business intelligence tool to connect to QuickBooks Online.

• Connect to and Query Google Cloud Storage in QlikView over ODBC

  Create data visualizations with Google Cloud Storage in QlikView.

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

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

• Use JayDeBeApi to access Microsoft Project in Python

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

• Build Charts with Power BI XMLA in Clear Analytics

  Create dynamic charts and perform analytics based on Power BI XMLA in Clear Analytics.

• Visualize Raisers Edge NXT in TIBCO Spotfire through ADO.NET

  Integrate Raisers Edge NXT into dashboards in TIBCO Spotfire.

• Bridge Salesforce Pardot Connectivity with Apache NiFi

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

• Query eBay Analytics in ColdFusion

  Write standard ColdFusion data access code to connect to eBay Analytics.

• Build MVC Applications with Connectivity to Azure Active Directory

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Active Directory from an ASP.NET MVC application.

• «
• 337
• 338
• 339
• 340
• 341
• 342
• 343
• 344
• 345
• 346
• »