Hello Everyone,
One of my previous blogs, referred to the Issue of working with an Oracle DB Source,
Two major Issues are presented when facing an Oracle Data source:
1. How to handle a 64bit environment
2. The Lack of Support within the OLEDB Provider for the case of Oracle Numeric type,
When precision is undeclared.
While the first Issue, was addressed successfully (Setting up Both 32bit and 64bit Oracle ODP provider).
The Issue of the numeric type, was poorly solved using either Oracle 11g provider (which conflicts with WSS or MOSS),
Or by doing casting within the SQL Queries.The Following Provider offers better compatibility to the BIDev,
It solves the need to tackle the environment settings for running the 32bit provider using VS, while processing a x64 task.
The Provider Could be downloaded from the Following Link:
http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en
Pre-requests:
The following Microsoft SQL Server products are supported by the SSIS components for Oracle:
| • |
Microsoft SQL Server 2008 |
| • |
Microsoft Business Intelligence Development Studio for SQL Server 2008 |
These versions are supported on the following operating systems and platforms:
• |
Windows XP 32-bit (x86) and 64-bit (x64) |
| • |
Windows Vista 32-bit (x86) and 64-bit (x64) |
| • |
Windows Server 2003 32-bit (x86), 64-bit (x64), and 64-bit Itanium (IA64) |
| • |
Windows Server 2008 32-bit (x86), 64-bit (x64), and 64-bit Itanium (IA64) |
The Microsoft SSIS components for Oracle support the following Oracle database versions:
| • |
Oracle 9.2.0.4 and higher |
To work with the Microsoft Oracle Connector by Attunity you must install the Oracle client software version 10.x or 11.x, on the computer with SSIS. (On 64bit systems a 32bit + 64bit Oracle Connecters are needed). Have Fun,
Eran
Hi
I had a customer question few days ago how to display a KPI list with WSS solution?
Well, as you know KPI List is an object of MOSS and WSS doesn't have this functionality.
The customer doesn't use Performance Point Server of analysis services so we need a simple solution. How?
The solution is:
- 1. Create a standard List in WSS to host KPI values such as goal , actual value etc.
- 2. Create Reporting Services report which connects to WSS with XML data-source.
- 3. The query asks for List Items values from WSS web services.
- 4. Manipulate the data and show present it with icons within the Report.
Download the List Template here.
Download the Reporting Services Project here.
ScreenShots of steps:
- 1. Change the XML connection in the project.
- 2. Make sure you have access permissions for the web site.
Enjoy and good luck.
Hello everyone,
The long awaited SQL Server 2005 SP3 is here!
Download from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
Important Remark:
Keep in mind that SP3 includes CU9 (SP2 Accumulative hotfix 9).
To solve this issue Microsoft will realse SP3 CU1 which will include both SP2 CU10 and CP2 CU11.
The scheduled release date is next week.
Have Fun,
Eran & Yossi
Hi,
6 Minutes and 33 seconds of magnificent BI Application Roadmap
http://www.youtube.com/watch?v=MAbtc_PZOjs
No more tools :)
Enjoy.