Does anybody know if it is possible (and how) to connect to BO repository from an "Microsoft tool"?
I need to query the CI_INFOOBJECTS catalog. Ideally I would like to connect using linked servers or SSIS packages.
Asked
Active
Viewed 324 times
0
Diego
- 34,802
- 21
- 91
- 134
2 Answers
2
It would probably help to know which version of BO you have, however a fairly recent article basically says that a) it's a binary format so there's no 'direct' way to query it; b) but you can query it from BO itself; and c) the BO Enterprise SDK provides documentation on how to get the information from .NET.
Pondlife
- 15,992
- 6
- 37
- 51
-1
I took a different approach by building a assembly to get the info I need and access it from my SSIS package
Diego
- 34,802
- 21
- 91
- 134