posts - 88 , comments - 3 , trackbacks - 0

cdata

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 [ ado.net 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 [ ado.net 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 [ ado.net 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 ]

Use Crystal Reports to create reports with 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.Install the JDBC DriverInstall the CData JDBC Driver for Salesforce by including the driver JAR in the Crystal Reports classpath: Set the DataDriverCommon element in the CRConfig.xml file to the path to the JAR.The CRConfig.xml ......

Posted On Tuesday, June 16, 2015 2:09 AM | Filed Under [ salesforce cdata data reports Crystal Reports ]

LINQ to QuickBooks Data

LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData Data Providers for ADO.NET. This example uses LINQ to access information from the QuickBooks Data Provider.

Posted On Monday, June 15, 2015 2:16 AM | Filed Under [ .net quickbooks cdata LINQ .Net Framework ]

Access QuickBooks from PHP
This article will explain how to connect to any of the CData SQLBrokers from PHP. While the example will use the SQLBroker for QuickBooks.Step 1: Download and install the SQLBroker for QuickBooks from CData.Step 2: Next configure the SQLBroker for QuickBooks to connect to your QuickBooks company file or online account. If you browse to the Help file in the Windows start menu, there is a link to the Getting Started Guidewhich walks you through setting up the SQLBroker for QuickBooks. Once you have ......

Posted On Friday, May 31, 2013 8:11 AM | Comments (0) | Filed Under [ quickbooks php cdata ]

Using CData JDBC Drivers in ColdFusion
The CData JDBC Drivers can be used in any environment that supports loading a JDBC Driver. In this tutorial we will explore using the CData Salesforce JDBC Driver from within ColdFusion.To begin, this tutorial will assume that you have already installed the CData Salesforce JDBC Driver as well as Adobe ColdFusion v10, and that you already have a Salesforce account and access token (See our forum for more details about getting an access token).Add the CData JDBC Driver to ColdFusion's lib directory.Copy ......

Posted On Wednesday, February 13, 2013 9:40 AM | Comments (0) | Filed Under [ salesforce cdata jdbc cold fusion ]

Analyze Salesforce data with PowerPivot
The ODBC protocol is used by a wide variety of Business Intelligence (BI) and reporting tools to get access to data from different databases. The CData ODBC Drivers bring the same power and ease of use to nontraditional data sources such as Salesforce, Microsoft CRM, QuickBooks, etc. This article uses the CData Salesforce Driver to import data into PowerPivot.Connect to SalesforceFollow the steps below to connect to Salesforce in PowerPivot.If you have not already, configure an ODBC data source name ......

Posted On Wednesday, February 13, 2013 9:40 AM | Comments (0) | Filed Under [ salesforce cdata ODBC PowerPivot ]

Integrate Apps with Gmail (.NET or Java).
Use the CData Google ADO.NET Provider or JDBC Driver to read and search email messages on your Gmail accounts.The CData Google Data Provider for ADO.NET allows you to use the search capabilities in IMAP to query your Gmail account. This article will explore how to execute your own custom queries from your application. We will use the CData Google Data Provider along with the Google Email demo to execute custom queries on a Gmail account.Step 1: Navigate to the \demos - winform\googlemail\ folder ......

Posted On Thursday, December 20, 2012 2:08 AM | Comments (0) | Filed Under [ .net google cdata jdbc gmail google apps IMAP ]

Using SQL to Query Gmail
The Gmail Data Provider makes it easy to search email from a Gmail account. Instead of learning the details of the IMAP search command, you can simply use the simple SQL syntax. However, the full IMAP search specification is supported. You can also search based on multiple criteria at the same time. This article will demonstrate how to use SQL to execute simple and advanced IMAP searches. Message FieldsFor simple searches, such as searching for all emails from a particular person, you can use message ......

Posted On Thursday, December 20, 2012 1:56 AM | Comments (0) | Filed Under [ ado.net google cdata jdbc gmail data ssis excel add-in sql ]

Call Stored Procedures from Script Components
The source task and the destination task are the easiest ways to transfer data in SSIS. You can use source and script components to output data to the data flow.This article shows how to create a script component that functions as a source in the data flow: It passes data returned from Salesforce to downstream components. You will execute the CreateJob and CreateBatch stored procedures available in the Salesforce SSIS Component.Stored procedures can be used to search, update, and modify data. Stored ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ salesforce ado.net cdata ssis ]

Download files from a SharePoint site using the CData SSIS Components
The CData SSIS data flow components allow you to easily import and export data from various data sources. However, in some cases the type of operation you need does not fit the SSIS Source or the SSIS Destination model.This article shows how to use the DownloadDocument stored procedure included in the CData SSIS Components for SharePoint to download files from SharePoint. The CData SSIS Components surface additional functionality available in the underlying API as stored procedures. While this article ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ sharepoint cdata ssis sql ]

Build an MVC Application with Connectivity to QuickBooks
This article shows how to use wizards in Visual Studio to create a simple MVC (model, view, controller) project and execute CRUD (create, read, update, and delete) commands to QuickBooks using the Entity Framework methods.Establish a ConnectionBefore getting started, you will need to establish a connection to QuickBooks.To connect to QuickBooks Desktop, use the Remote Connector application included with the installation. The Remote Connector is a lightweight, stand-alone server that enables you to ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ ado.net quickbooks cdata MVC ]

Working with QuickBooks using LINQPad
The CData ADO.NET Providers can be used from many applications and development environments. This article shows how to use LINQPad to connect to QuickBooks using the CData ADO.NET Provider for QuickBooks. Although this example uses the QuickBooks Data Provider, the same process applies to any CData ADO.NET Providers.Create the Data ModelIn a new console project in Visual Studio, create a data model using the ADO.NET Entity Data Model wizard.Select an existing connection or click New Connection to ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ ado.net quickbooks cdata linqpad ]

Sync Google Calendar with SharePoint Calendar
The CData Data Providers make it easy to build applications that need to move data from one source to another. The simple, uniform SQL syntax makes it easy to retrieve and update data in Google and SharePoint.This article shows how to use the demo Windows application to sync Google and SharePoint calendars.Connect to Google and SharePointTo connect to Google, specify the User and Password connection properties. Alternatively, you can use OAuth.To connect to SharePoint On-Premise, specify the User ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ sharepoint google cdata calendar ]

Sync Google Contacts with QuickBooks
The CData ADO.NET Providers offer an easy way to integrate with different data sources. This article walks through the included, fully functional application that can be used to synchronize contacts between Google and desktop editions of QuickBooks. The application can easily be modified to synchronize contacts with QuickBooks Online and QuickBooks POS.Connecting to QuickBooks and GoogleTo connect to Google, specify the User and Password connection properties. The provider also supports the OAuth ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ quickbooks cdata contacts QuickBooksPOS QuickBooksOnline ]

Databind Wijmo Grid to Salesforce.com Data
The Salesforce Cloud Driver provides Salesforce data as Web services, which enable connectivity to the live data. This article shows how to consume JSONP-formatted Salesforce data from a Wijmo Grid.If you have not already connected successfully in the cloud driver administration console, see the "Getting Started" chapter in the help documentation for a guide.Load the required Wijmo, jQuery, and Knockout libraries:http://code.jquer... ......

Posted On Thursday, September 27, 2012 3:38 AM | Comments (0) | Filed Under [ salesforce cdata databind Wijmo Grid cloud drivers ]

Access Salesforce Data as OData Feeds in Tableau
This article will explain how to use the Salesforce Cloud Driver to provide the underlying connectivity to Salesforce data in Tableau's business intelligence tool.If you have not already connected successfully in the cloud driver administration console, see the "Getting Started" chapter in the help documentation for a guide.In Tableau, select 'Connect to data'. In the 'On a server' section, click OData.In the resulting wizard, enter the OData URL of the cloud driver's endpoint. Append the name of ......

Posted On Wednesday, September 26, 2012 5:32 AM | Comments (0) | Filed Under [ salesforce odata cdata tableau ]

Design a Custom SAP Function Module to Circumvent RFC_READ_TABLE Limitations

While the SAP SDK provides the RFC_READ_TABLE for accessing data from SAP tables, using it to select data is limited to 512 bytes at a time so you may not be able to retrieve all columns. You can resolve this limitation by defining a custom function module that will allow you to select any result set you need.

Posted On Monday, June 15, 2015 2:01 AM | Filed Under [ cdata jdbc ODBC ssis SAP netweaver ]

Access QuickBooks Online Data in SharePoint External Lists
Provide your QuickBooks Online data to SharePoint users as an external list.You can use the CData Cloud Driver for QuickBooks Online to give your users the capabilities to access and update QuickBooks Online data in SharePoint. This article shows how to create an external list of QuickBooks Online data that is always up to date. You will use an external content type as a template to create the external list. The external content type enables connectivity over Web services, the protocol that the cloud ......

Posted On Friday, June 12, 2015 7:03 AM | Comments (0) | Filed Under [ sharepoint cdata quickbooks online ]

Lightning Connect to SQLite External Objects
Use the CData Cloud Driver for SQLite to securely provide OData feeds of SQLite data to smart devices and cloud-based applications. Use the cloud driver with Salesforce Lightning Connect to create SQLite objects that you can access from apps and the dashboard.The CData Cloud Driver for SQLite enables you to access SQLite data from cloud-based applications like the Salesforce console and mobile applications like the Salesforce1 Mobile App. In this article, you will use the cloud driver and Salesforce ......

Posted On Friday, June 12, 2015 6:47 AM | Comments (0) | Filed Under [ salesforce odata cdata SQLite Cloud Driver ]

Tutorial: Access Salesforce Leads in SharePoint through an External List
You can use the CData Cloud Driver for Salesforce to give your users the capabilities to access and update Salesforce data in SharePoint. This article shows how to create an external list of Salesforce data that is always up to date. You will use an external content type as a template for the external list. The external content type enables connectivity over Web services, the protocol that cloud driver uses to provide access to live Salesforce data.Note that this tutorial applies to any of our data ......

Posted On Monday, February 3, 2014 5:44 AM | Comments (0) | Filed Under [ salesforce .net sharepoint cdata ]

Import Salesforce Data into Google Spreadsheets
The Salesforce Cloud Driver enables applications to connect to Salesforce data via Web services. In Google Spreadsheets, you can consume Web services in the CSV format by calling the ImportData function. You can follow the three steps below to use the ImportData function to consume Salesforce data in Google Spreadsheets.If you have not already connected successfully in the cloud driver administration console, see the "Getting Started" chapter in the help documentation for a guide.Authenticate your ......

Posted On Monday, February 3, 2014 5:44 AM | Comments (1) | Filed Under [ salesforce odata google google docs integration cdata ]

Use the Cloud Driver to Access SQLite Data in Microsoft PowerPivot
Use the CData SQLite Cloud Driver to connect to live SQLite data in the PowerPivot business intelligence tool.This article will explain how to use the cloud driver to provide SQLite data as OData services and then consume the data in Microsoft Excel's PowerPivot business intelligence tool. Follow the steps below to retrieve and edit SQLite data in Power Pivot. While the example will use the Salesforce Connector, the same process can be followed for any of the CData Cloud Drivers.If you have not already ......

Posted On Friday, September 21, 2012 3:04 AM | Comments (0) | Filed Under [ salesforce odata cdata PowerPivot SQLite Microsoft ]

Extending QuickBooks Reporting with the QuickBooks ADO.NET Data Provider
The ADO.NET Provider for QuickBooks enables you to request almost any report available in QuickBooks Desktop and QuickBooks Online. The ADO.NET Provider for QuickBooks enables you to access reports as views, or read-only tables. This article shows how to customize the included reports and create new reports.Many QuickBooks Desktop reports are already included as views. However, you may want to extend a report view. For example, if you do not see a column you need in one of the included reports, you ......

Posted On Friday, September 21, 2012 3:04 AM | Comments (0) | Filed Under [ quickbooks cdata quickbooks online ]

A Developers Guide to Creating OData Services with the Salesforce Data Provider
The CData ADO.NET Provider for Salesforce enables you to use the Windows Communication Foundation (WCF) framework to rapidly develop service-oriented applications that provide Salesforce data to OData consumers. This article shows how to create an entity data model to provide the underlying connectivity to Salesforce, as well as how to create a WCF Data Service to expose the OData service. You can then consume the feed with any OData client, for example, Power Pivot or an application that uses the ......

Posted On Friday, September 21, 2012 3:04 AM | Comments (0) | Filed Under [ salesforce odata cdata PowerPivot Excel ]

Executing Stored Procedures in Visual Studio LightSwitch.
The CData ADO.NET Data Providers enable you to visualize and manipulate information from disparate data sources in LightSwitch applications. This entry demonstrates how to execute stored procedures in LightSwitch. This article uses the CData Email Data Provider, but the same process will work with any CData ADO.NET Data Provider.Create the RIA ServiceOpen Visual Studio 2010 and create a new WCF Service Library Project.Add a new Domain Service Class to the .Web project.In the new Domain Service Class, ......

Posted On Friday, September 21, 2012 3:04 AM | Comments (0) | Filed Under [ ado.net lightswitch cdata email ]

Connect to QuickBooks Data from PowerBuilder using CData ADO.NET Data Provider
The CData ADO.NET providers are easy-to-use, standards-based controls that can be used from any platform or development technology that supports Microsoft .NET, including Sybase PowerBuilder. This article shows how to use the CData ADO.NET Provider for QuickBooks in PowerBuilder.This article shows how to use the CData ADO.NET Provider for QuickBooks to create a basic PowerBuilder application that performs CRUD operations (create, read, update, and delete).In a new WPF Window Application solution, ......

Posted On Monday, July 9, 2012 4:06 AM | Comments (2) | Filed Under [ .net quickbooks cdata powerbuilder ]

Accessing QuickBooks with Entity Framework 6
Entity Framework is an object-relational mapping framework that can be used to work with data as objects. While you can run the ADO.NET Entity Data Model wizard in Visual Studio to handle generating the Entity Model, this approach, the model-first approach, can put you at a disadvantage if there are changes in your data source or if you want more control over how the entities operate. In this article you will complete the code-first approach to accessing QuickBooks data using the CData ADO.NET Provider.The ......

Posted On Friday, May 18, 2012 2:02 AM | Comments (0) | Filed Under [ quickbooks cdata framework 6 Entity Framework ]

Using Object-relational mapping (ORM) with Salesforce Entities
Object-relational mapping (ORM) technique can bridge your logical business model with your physical storage model.Hibernate is a popular object-relational mapping library for Java, providing a framework for mapping object-oriented domain models to a traditional relational database.Note: Please see the article Using LINQ with QuickBooks to see the ORM approach using Microsoft .NET.The CData Salesforce JDBC Driver supports full integration with Hibernate.In this tutorial, we will generate an object-relational ......

Posted On Friday, April 27, 2012 6:11 AM | Comments (0) | Filed Under [ salesforce cdata ORM ]

Connect QuickBooks 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 QuickBooks ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from desktop editions of QuickBooks into a Microsoft SQL Server database. The same procedure outlined ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ quickbooks cdata ssis sql ]

Connect SalesForce 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 Salesforce ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from Salesforce and/or Salesforce Online into a Microsoft SQL Server database. The exact same ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ salesforce cdata ssis sql ]

Using Cookie-Based Authentication with the CData SharePoint Data Provider.
This article walks through the process of using the SharePoint Data Provider and authenticating with SharePoint Online / Office 365. This tutorial covers how to perform authentication programmatically and with the Visual Studio Server Explorer.In addition to accessing lists from local installations of SharePoint server, the SharePoint Data Provider also supports accessing lists from SharePoint Online. SharePoint Online and Office 365 authentication requires a cookie based authentication. To connect ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ sharepoint cdata ]

LINQ to QuickBooks
This article demonstrates how to use LINQ to access tables in QuickBooks through the QuickBooks ADO.NET Data Provider. To do this you will LINQ to Entity Framework, which is used to generate the connection and can be used with any CData ADO.NET Data Providers to access data via LINQ.In a new project in Visual Studio, right-click on the project and choose to add a new item. Add an ADO.NET Entity Data Model.Choose to generate from database and click next.Add a new Data Connection, and change your data ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ ado.net quickbooks cdata Entity Framework LINQ ]

Connect to QuickBooks From LightSwitch Applications
The CData Data Providers for ADO.NET enable you to integrate disparate data sources into LightSwitch applications. In this demo, you will create a LightSwitch application that connects with QuickBooks Desktop and displays account data in an editable grid. Any changes will be immediately reflected in QuickBooks. The procedure outlined below can be used with any CData ADO.NET Data Providers.Connect to QuickBooksTo connect to Desktop editions of QuickBooks, use the included Remote Connector application ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ lightswitch quickbooks cdata ]

Hooking into Google Apps With CData Google Data Provider
By Mike Gold, November 30, 2010 This article was originally written and hosted on c-sharp cornerIntroductionThe world is full of information and there are all kinds of ways to access it. The Microsoft .NET framework provides several convenient ways to access data from different data sources, whether it's an XML file, a web stream, or a database. For databases, Microsoft offers several techniques for retrieving the data. One of the simplest forms is through an ADO.NET Data Provider. The Data Provider ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ quickbooks google cdata ]

Query Google Calendars, Contacts, and Documents from PowerShell
Are you looking for a quick and easy way to access Google Drive from PowerShell? The CData Google Apps Data Provider provides an easy-to-use ADO.NET interface that you can take advantage of from PowerShell scripts. Simply use the included .NET objects in your PowerShell scripts to connect to Google Apps and synchronize, automate, download, and more!Connect to Google AppsTo connect to any CData ADO.NET Provider from Powershell, first load the provider assembly, located in the lib subfolder in the ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ google google docs cdata powershell ]

Accessing website data using ADO.NET
Accessing Website Data Using ADO.NETBy i-programmer, January 24, 2011 This article was originally written and hosted on i-programmerIntroductionInt... with websites via the wide range of APIs that are on offer is attractive because it provides new possibilities but is slightly depressing because you have to find out how to do the job all over again for each API.Now there is a better way. CData has implemented a range of common APIs as ADO.NET data providers - Google, QuickBooks, Salesforce and ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ ado.net cdata ]

Databind Charts to Salesforce Data
Databinding enables bidirectional access to data from UI controls. You can use the CData ADO.NET Provider for Salesforce to easily databind Salesforce data to Windows Forms and Web controls in Visual Studio. This article shows how to use wizards to databind Salesforce data to a chart that reflects any changes. The code walk-through section shows how to create the same chart in 10 lines of code.Databind to a ChartDatabinding consists of three steps: Instantiate the control, configure the data source, ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ salesforce .net cdata databind chart ]

OLAP Reporting Directly from QuickBooks using ComponentOne OLAP for WinForms
By Rich Dudley, ComponentOne, December 6, 2010 This article was originally written and hosted on the ComponentOne Community SiteThe CData QuickBooks Driver abstracts the QuickBooks API into a familiar, database-like programming model. After installation, the QuickBooks connector is added as an ADO.NET Data Source, and QB now operates as a database of sorts. We can query "tables" containing customer, sales orders, invoice data and more. Since the data connection is two-way, we can also update data ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ quickbooks cdata olap WinForms ]

Powered by: