2012年5月3日 上午 12:42
Hi, I've installed BizTalk Server 2010 Developer Edition on a dev environment and I'm trying to run some samples for BAM. I can't see the Excel Add-in in the add-ins list if I try and enable it.
The document "Installing BizTalk Server 2010 on Windows Server 2008 R2 and 2008" says this
The following are the software requirements when using the BAM client:
- For the Web client, you need Internet Explorer 8.0 or later and Office Web Components 11 version 4.0 or later.
- If you are running the Web client and using SQL Server 2008 R2/2008 SP1 Analysis Services, you must install Microsoft SQL Server 2008 R2/2008 SP1 Analysis Services 10.0 OLE DB Provider.
- For the Excel client, you need Microsoft Excel® 2010/2007 and the BAM Excel Add-in provided with BizTalk Server 2010.
In my BizTalk config I've got all the BAM tools configured. Do I need to install the BAM Client separately? In the Pro BAM book it says
Do you see the BAM Add-In in Excel? If the BAM Add-In for Excel is missing, check to see whether you can find a file called C:\Program Files\Microsoft Office\Office12\Library\BAM.xla. If you have this file, you should be able to enable the BAM Add-In for Excel using the Add-In Management dialog box. If you don’t have it, the BAM tools are not installed. Use Add/Remove Programs to check the BizTalk Server installation and ensure the BAM client, which is found under Additional Software, is installed.
I can't see BAM client in the installed programs list. Where is the installer?
2012年5月3日 上午 02:19
Had to manually copy the file Bam.xla to C:\Program Files (x86)\Microsoft Office\Office14\Library. Also, when I installed office excel I just ignorantly didn't install anything other than Excel. So I needed to Add or Remove features on Office and add Office Shared Features -> Visual Basic for Applications.
- 已標示為解答 DukeDickinson 2012年5月3日 上午 02:19
2012年5月8日 上午 07:31版主
2012年5月16日 上午 09:02
If you have checked BAM client in the BizTalk installation but BAM is not listed under the Excel (File -> Option -> Addins) then you click Manage Excel Add-ins -> Browse. Browse to BAM.xla under C:\Program Files\Microsoft BizTalk Server 2010\ExcelDir.
You will see BAM is now listed under Add-ins.