posts - 88 , comments - 3 , trackbacks - 0


Use the CData ODBC Driver for NetSuite in SAS JMP
You can use the CData ODBC Driver to integrate NetSuite data into the statistical analysis tools available in SAS JMP. This article shows how to use NetSuite data in the Graph Builder and Query Builder.You can use the CData ODBC Driver for NetSuite to integrate live data into your statistical analysis with SAS JMP. The driver proxies your queries directly to the NetSuite API, ensuring that your analysis reflects any changes to the data. The CData ODBC Driver supports the standard SQL used by JMP ......

Posted On Tuesday, July 7, 2015 3:47 AM | Filed Under [ cdata ODBC data netsuite SAS JMP ]

Publish Reports with Salesforce Data in Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce data.Crystal Reports provides built-in support for the JDBC standard. The CData JDBC Driver for Salesforce enables you to use the Report Wizard and other tools to access Salesforce data in Crystal Reports. This article shows how to create a simple report that features Salesforce data.Connect To Salesforce DataFollow the procedure below to use the Report Wizard to create the Salesforce connection.If you have not already done so, ......

Posted On Tuesday, July 7, 2015 3:36 AM | Filed Under [ salesforce cdata jdbc reports Crystal Reports ]

Connect to Dynamics CRM Data in Jaspersoft Studio
Create reports based on live data in Jaspersoft Studio.This article shows how to use the CData JDBC Driver for Dynamics CRM to create a basic Jaspersoft Studio report that features Dynamics CRM data in a table and a chart. Each time you run the report, the chart and table will display the live data. You will use wizards in JasperSoft to build several SQL queries that will populate the report elements. The driver enables you to use standard SQL while skipping the process of copying the data into a ......

Posted On Tuesday, July 7, 2015 3:30 AM | Comments (0) | Filed Under [ dynamicscrm cdata jdbc dynamics Jaspersoft ]

Connect to Salesforce Data as a Linked Server
Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.You can use the TDS Remoting feature to set up a linked server for Salesforce data. After you have started the daemon, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with Salesforce data just as you would a a linked SQL Server instance.Configure the DSNIf you have not already done so, specify connection properties in a DSN (data ......

Posted On Tuesday, June 30, 2015 2:15 AM | Comments (0) | Filed Under [ salesforce cdata ODBC Linked Server ]

How to Access Data from a SharePoint List Based on a Custom View
The CData ADO.NET Providers for SharePoint you to integrate live SharePoint data with other applications. For example, Visual Studio provides built-in support for ADO.NET data sources. This article shows how to use Server Explorer in Visual Studio to access the data screened by a SharePoint custom view.Implementing Access Control with a Database QueryThe CData ADO.NET provider's data model exposes each SharePoint list as a separate table; all custom views are available by querying the Views table. ......

Posted On Friday, June 26, 2015 3:21 AM | Comments (0) | Filed Under [ sharepoint cdata ]

Connect to Nonstandard OData Services
The CData ADO.NET Provider for OData enables you to expose Web services as a fully managed ADO.NET data source. It allows you to access almost any OData service from native ADO.NET tools. You can follow the procedure below to access OData sources that do not conform exactly to the OData protocol. This article will add support for the Microsoft Research service, which does not implement some common functionality, including support for retrieving metadata.Define a Custom Schema FileThe CData providers ......

Posted On Friday, June 26, 2015 3:18 AM | Comments (0) | Filed Under [ odata cdata OData Services ]

Lightning Connect to NetSuite External Objects
Salesforce Lightning Connect enables Salesforce users to connect to data from OData sources from Salesforce in the same way that users interact with standard Salesforce objects. Through Lightning Connect, Salesforce customers can build real-time analysis from within their Salesforce dashboard and other Salesforce1 apps. In this article we are going to show you how you can enable bi-directional connectivity between NetSuite CRM and ERP data from Salesforce using the Cloud Drivers from CData Software ......

Posted On Wednesday, June 17, 2015 1:16 AM | Filed Under [ salesforce odata cdata cloud drivers Lightning Connect ]

Connect SharePoint to SQL Server through SSIS
Using SQL Server as a backup for critical business data provides an essential safety net against loss. In addition, backing up data to SQL Server enables business users to more easily connect that data with features like reporting, full-text search, analytics, and more.This example demonstrates how to use the SharePoint ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from SharePoint and/or SharePoint Online into a Microsoft SQL Server database. The exact same ......

Posted On Tuesday, June 16, 2015 4:10 AM | Filed Under [ sharepoint cdata ssis SQL server ]

Replicate PreEmptive Analytics Data from PowerShell
Write a quick PowerShell script to query PreEmptive Analytics data. Use connectivity to the live data to replicate PreEmptive Analytics data to SQL Server.The CData ODBC Driver for PreEmptive Analytics enables out-of-the-box integration with Microsoft's built-in support for ODBC. The ODBC driver instantly integrates connectivity to the real PreEmptive Analytics data with PowerShell.You can use the .NET Framework Provider for ODBC built into PowerShell to quickly automate integration tasks like replicating ......

Posted On Tuesday, June 16, 2015 4:02 AM | Filed Under [ cdata ODBC powershell PreEmptive Analytics ]

Connect to and Query Eloqua Data in QlikView over ODBC
Create data visualizations with Eloqua data in QlikView.The CData ODBC drivers expand your ability to work with data from a wide variety of data sources. This article outlines simple steps to connect to Eloqua data and create data visualizations in QlikView.Populate a Chart with Eloqua DataThe steps below supply the results of an SQL query to a visualization in QlikView. In this article, you will create a bar chart with the query below:view sourceSELECT Name, ActualCost FROM CampaignIf you have not ......

Posted On Tuesday, June 16, 2015 3:52 AM | Filed Under [ cdata ODBC Eloqua QlikView ]

Full cdata Archive

Powered by: