posts - 88 , comments - 3 , trackbacks - 0

ODBC

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 ]

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 ]

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 ]

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 ]

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 ]

Powered by: