CData Software - Knowledge Base

Recent Articles

• «
• 181
• 182
• 183
• 184
• 185
• 186
• 187
• 188
• 189
• 190
• »

• Create Informatica Mappings From/To a JDBC Data Source for SharePoint Excel Services

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

• Build Dashboards with Aha in DBxtra

  Create dynamic dashboards and perform analytics based on Aha! in DBxtra.

• Access Live Amazon Athena in TIBCO Data Virtualization

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

• Replicate Bing Ads to Multiple Databases

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

• A PostgreSQL Interface for Blackbaud FE NXT

  Use the Remoting features of the Blackbaud FE NXT ODBC Driver to create a PostgreSQL entry-point for data access.

• Analyze Invoiced in R

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

• Import DB2 into FileMaker Pro

  Create reports that integrate IBM DB2 in Filemaker Pro.

• Work with Epicor Kinetic in FoxPro

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

• How to Connect the Power BI Service to Act-On: Complete Guide

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

• How to connect to IBM Cloud Object Storage with Squirrel SQL client

  Connect to IBM Cloud Object Storage and execute queries in the Squirrel SQL Client.

• How to Query RSS Feeds in MySQL Workbench

  Execute MySQL queries against live RSS Feeds from MySQL Workbench.

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

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

• Use the CData Software JDBC Driver for SAS xpt in MicroStrategy

  Connect to SAS XPORT in MicroStrategy Developer using the CData Software JDBC Driver for SAS xpt.

• Automated Continuous SuiteCRM Replication to AlloyDB

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

• Oracle Service Cloud Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Service Cloud through CData Connect Cloud using different applications and tools.

• Automate Zendesk Replication to Azure Data Lake

  Use CData Sync to customize and automate Zendesk replication to Azure Data Lake.

• Replicate Dynamics NAV to Multiple Databases

  Replicate Microsoft Dynamics NAV to disparate databases with a point-and-click configuration.

• How to work with HubSpot in Apache Spark using SQL

  Access and process HubSpot in Apache Spark using the CData Software JDBC Driver.

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

  Connect to Microsoft SharePoint in MicroStrategy Desktop using the CData Software ODBC Driver for SharePoint.

• Access LinkedIn in PHP through Connect Server

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

• Working with Klipfolio in LINQPad

  Execute LINQ queries to Klipfolio in LINQPad.

• Using the CData Software ODBC Driver for Google Spanner in PyCharm

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

• Design a Custom SAP Function Module to Circumvent RFC_READ_TABLE Limitations

  The RFC_READ_TABLE function enables you to get data from SAP tables, but limits retrieving transaction records to 512 bytes. You can use the CData ADO.NET Provider for SAP to circumvent this by defining a custom SAP function module that will allow to retrieve data as you would with any ADO.NET data source.

• Model, Search, and Visualize Live Salesforce Marketing in ThoughtSpot

  Use CData Connect Cloud to connect to live Salesforce Marketing Cloud for modeling, searching, and visualizing.

• Connect to Bitbucket in DBeaver

  Use the CData ODBC Driver to connect to Bitbucket in DBeaver.

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

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

• Access Cvent as a Remote Oracle Database

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

• Use the CData ODBC Driver for SQL Analysis Services from SharePoint Excel Services

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

• Connect to and Query Zendesk in QlikView over ODBC

  Create data visualizations with Zendesk in QlikView.

• Visualize Live Oracle HCM Cloud of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Oracle HCM Cloud using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Active Directory as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Active Directory.

• Publish Twilio-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Twilio.

• Analyze Epicor Kinetic in R

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

• LINQ to ShipStation

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

• How to use SQLAlchemy ORM to access Drip in Python

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

• Create Google Directory-Connected Visualizations in Klipfolio

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

• Integrate Live Bing Ads into Amazon SageMaker Canvas with RDS

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

• Automated Continuous Klaviyo Replication to SQLite

  Use CData Sync for automated, continuous, customizable Klaviyo replication to SQLite.

• Use Dash to Build to Web Apps on CockroachDB

  Create Python applications that use pandas and Dash to build CockroachDB-connected web apps.

• Import Gmail into the Power BI Service for Visualizations

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

• Connect to MariaDB in Google Apps Script

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

• Access Live SendGrid in Excel (Desktop)

  Use CData Connect Cloud to gain access to live SendGrid from your Excel spreadsheets.

• Natively Connect to Pinterest in PHP

  The CData ODBC driver for Pinterest enables you to create PHP applications with connectivity to Pinterest. Leverage the native support for ODBC in PHP.

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

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

• Integrate with Google Cloud Storage using Apache Camel2

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

• Create SSAS Tabular Models from Databricks

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

• Creating SAP Hybris C4C-Connected Applications in Unqork

  You can use CData Connect Cloud to feed SAP Hybris C4C to Unqork and build custom business apps.

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

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

• Edit and Search External Google Calendar Objects in Salesforce Connect

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

• Connect to SFTP in NetBeans

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

• How to Connect DBeaver to SAP Ariba Procurement via a JDBC Driver

  Manage SAP Ariba Procurement with visual tools in DBeaver like the query browser.

• Connect to Dynamics 365 Business Central from PowerBuilder

  This article demonstrates how to access Dynamics 365 Business Central from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics 365 Business Central.

• Integrate with GraphQL using Apache Camel2

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

• Automated Continuous xBase Replication to Amazon S3

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

• Connect to Dynamics NAV in HULFT Integrate

  Connect to Dynamics NAV as a JDBC data source in HULFT Integrate

• Automated Continuous SAP Fieldglass Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Amazon Redshift.

• Connect to BigCommerce in JRuby

  Create a simple JRuby app with access to live BigCommerce.

• Build Printify-Connected ETL Processes in Google Data Fusion

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

• Replicate Multiple QuickBooks Time Accounts

  Replicate multiple QuickBooks Time accounts to one or many databases.

• Creating Twilio-Connected Applications in Unqork

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

• Validate Google Directory with QuerySurge

  Access and validate Google Directory in QuerySurge using the CData JDBC Driver.

• Integrating Elasticsearch in Talend Cloud Data Management Platform

• «
• 181
• 182
• 183
• 184
• 185
• 186
• 187
• 188
• 189
• 190
• »