CData Software - Knowledge Base

Recent Articles

• «
• 210
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• »

• Back Up Apache Cassandra to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cassandra. In this article, we will employ an SSIS workflow to populate a database with Apache Cassandra data.

• Create Cosmos DB-Connected Business Apps in AppSheet

  Connect to Cosmos DB via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Azure Cosmos DB.

• Access GraphQL from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live GraphQL from HeidiSQL.

• Replicate Epicor Kinetic to Multiple Databases

  Replicate Epicor Kinetic to disparate databases with a point-and-click configuration.

• Connect to JSON Services in the Denodo Platform

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

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

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

• Use CData Connect Cloud to Access Oracle Financials Cloud in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Oracle Financials Cloud in the Power Pivot business intelligence tool.

• Create Dynamic Sage 300 Grids Using the Infragistics XamDataGrid

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

• Connect to SAP SuccessFactors in NetBeans

  Connect to SAP SuccessFactors in NetBeans with the data source configuration wizard.

• How to use SQLAlchemy ORM to access Facebook Ads in Python

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

• Connect to Act CRM from PowerBuilder

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

• ETL DB2 in Oracle Data Integrator

  This article shows how to transfer IBM DB2 into a data warehouse using Oracle Data Integrator.

• Connect to SAP SuccessFactors through External Services in Salesforce

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

• Automated Continuous Vertica Replication to MySQL

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

• Configure the CData JDBC Driver for SAP Business One in a Connection Pool in Tomcat

  Connect to SAP Business One from a connection pool in Tomcat.

• How to Work with EnterpriseDB in AWS Glue Jobs Using JDBC

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

• Query Pinterest in DataGrip

  Create a Data Source for Pinterest in DataGrip and use SQL to query live Pinterest.

• Using AngularJS to Build Dynamic Web Pages with Bullhorn CRM

  Use the CData Connect Server to create Bullhorn CRM OData feeds and build single-page applications with live Bullhorn CRM.

• Prepare, Blend, and Analyze Reckon in Alteryx Designer

  Build workflows to access live Reckon for self-service data analytics.

• Automated Continuous Square Replication to Databricks

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

• Automated Continuous Dynamics GP Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Dynamics GP replication to Amazon Redshift.

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

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

• Connect to and Query Azure Data Catalog in QlikView over ODBC

  Create data visualizations with Azure Data Catalog in QlikView.

• Connect to SAP Ariba Procurement in DBeaver

  Use the CData ODBC Driver to connect to SAP Ariba Procurement in DBeaver.

• Natively Connect to Google Ads in PHP

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

• Access MYOB AccountRight as a Remote Oracle Database

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

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

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

• Replicate Hive to Multiple Databases

  Replicate Apache Hive to disparate databases with a single configuration.

• Publish Shippo-Connected Dashboards in Tableau Server

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

• Connect to Avalara AvaTax as a Linked Server

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

• Create Zuora-Connected Nintex Workflows

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

• How to publish and share HubSpot dashboards with Tableau Server

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

• Automated Continuous Confluence Replication to Amazon S3

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

• Use the CData Software JDBC Driver for Oracle Service Cloud in MicroStrategy Web

  Connect to Oracle Service Cloud in MicroStrategy Web using the CData Software JDBC Driver for Oracle Service Cloud.

• Design BIRT Reports on Shopify

  Provide current Shopify to your embedded analytics.

• Create Hive-Connected Enterprise Applications in OutSystems

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

• Automated Continuous Excel Replication to Vertica

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

• Connect to SAP Concur from PowerBuilder

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

• Work with Live SharePoint in Power Query

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

• Create Reports from SingleStore in Looker Studio

  Use CData Connect Cloud to gain access to live SingleStore and create custom reports in Looker Studio.

• Publish Dynamics 365-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dynamics 365.

• Analyze OData Services in R

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

• Automated Continuous Tally Replication to Databricks

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

• Build Google Search-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Google Search Results from Zoho Analytics and import live Google Search.

• How to integrate Exact Online with Apache Airflow

  Access and process Exact Online in Apache Airflow using the CData JDBC Driver.

• Replicate Sage 300 for Use in Salesforce Connect

  Replicate Sage 300 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Prepare, Blend, and Analyze SAP Business One in Alteryx Designer

  Build workflows to access live SAP Business One for self-service data analytics.

• Use the CData Software JDBC Driver for Drift in MicroStrategy

  Connect to Drift in MicroStrategy Developer using the CData Software JDBC Driver for Drift.

• Replicate Multiple Google Campaign Manager 360 Accounts

  Replicate multiple Google Campaign Manager 360 accounts to one or many databases.

• Integrate JDBC-ODBC Bridge in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live JDBC-ODBC Bridge from Informatica Cloud.

• Use the CData ODBC Driver for Jira Service Management in SAS JMP

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

• Import Active Directory Using Azure Data Factory

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

• Add FTP to Informatica Enterprise Data Catalog

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

• Export Data from SQL Server to Cvent through SSIS

  Easily push SQL Server data to Cvent using the CData SSIS Tasks for Cvent.

• How to Access SQL Analysis Services Using Entity Framework

  This article shows how to access SQL Analysis Services using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Use the CData Software JDBC Driver for DB2 in MicroStrategy Web

  Connect to IBM DB2 in MicroStrategy Web using the CData Software JDBC Driver for DB2.

• How to Connect DBeaver to Trello via a JDBC Driver

  Manage Trello with visual tools in DBeaver like the query browser.

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

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

• Build Visualizations of Highrise in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Highrise CRM in Birst.

• Build SingleStore-Connected ETL Processes in Google Data Fusion

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

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

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

• Load Twilio to a Database Using Embulk

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

• How to connect and process ShipStation from Azure Databricks

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

• How to work with Salesforce Marketing in Apache Spark using SQL

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

• Choosing the Best Method to Connect SFTP to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use SFTP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Create xBase-Connected Nintex Workflows

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

• Automated Continuous Google Spanner Replication to Apache Cassandra

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

• Query Google Ads as a SQL Server Database in Node.js

  Execute SQL Server queries against Google Ads from Node.js.

• Working with Azure Analysis Services in LINQPad

  Execute LINQ queries to Azure Analysis Services in LINQPad.

• Access Live Blackbaud FE NXT in AWS Lambda (with IntelliJ IDEA)

  Connect to live Blackbaud FE NXT in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Build Visualizations of TaxJar in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of TaxJar in Birst.

• Using the CData Software ODBC Driver for Excel in PyCharm

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

• Connect to LinkedIn in DBeaver

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

• Visualize Reckon in TIBCO Spotfire through OData

  Integrate Reckon into dashboards in TIBCO Spotfire.

• Automated Continuous SAP SuccessFactors Replication to MySQL

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

• Automated CSV Replication to Teradata

  Use CData Sync to Customize and automate CSV/TSV Files replication to Teradata.

• Create Reports with RSS Feeds in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date RSS Feeds.

• Build a Simple VCL Application for eBay

  How to build a simple VCL Application to view eBay in RAD Studio using the CData ODBC Driver for eBay.

• Connect to Box in HULFT Integrate

  Connect to Box as a JDBC data source in HULFT Integrate

• Analyze Oracle Service Cloud in Cognos Analytics

  Use CData Connect Cloud to connect to Oracle Service Cloud from Cognos Analytics and analyze live Oracle Service Cloud.

• Visualize Sybase IQ in TIBCO Spotfire through ADO.NET

  Integrate Sybase IQ into dashboards in TIBCO Spotfire.

• Analyze EnterpriseDB with Power Pivot

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

• Create PayPal Dataflows on PowerBI.com

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

• Connect to Adobe Analytics from a Connection Pool in WebLogic

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

• Object-Relational Mapping (ORM) with Cosmos DB 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 Azure Cosmos DB into a Java-based ORM framework, Hibernate.

• Automated Continuous Splunk Replication to Amazon Redshift

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

• How to use SQLAlchemy ORM to access Oracle Service Cloud in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Service Cloud.

• Automated Continuous Sage Intacct Replication to Oracle

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

• Integrate Real-Time Access to QuickBooks Online in SAPUI5 MVC Apps

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

• Connect to Bing Ads in DBArtisan

  Use wizards in DBArtisan to configure Bing Ads as a data source.

• Prepare, Blend, and Analyze MYOB AccountRight in Alteryx Designer

  Build workflows to access live MYOB AccountRight for self-service data analytics.

• Create MYOB AccountRight-Connected Business Apps in AppSheet

  Connect to MYOB AccountRight via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to MYOB AccountRight.

• Connect to Zendesk as a Linked Server

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

• Use the CData ODBC Driver for SAP Ariba Procurement in SAS JMP

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

• Use the CData ODBC Driver for Aha in SAS JMP

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

• Build Teradata-Connected ETL Processes in Google Data Fusion

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

• Connect to Highrise as a Linked Server

  Use CData Connect to set up a linked server for Highrise CRM.

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

  Create an ODBC connection to Impala in Informatica and browse and transfer Apache Impala.

• Working with MySQL in LINQPad

  Execute LINQ queries to MySQL in LINQPad.

• How to Work with Salesforce Pardot in ETL Validator JDBC

  Connect to Salesforce Pardot from ETL Validator jobs using the CData Software JDBC Driver.

• «
• 210
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• »