How to connect?
First create a new ODBC Data Source, you can find that in Control Panel --> Administrative Tools
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbkRhBwEs-IxWq6GEwlHlmG8NUfHku-uDF5x_5HOo5x3BugLLJWRF6wmE_dkxCamTLolVhgKB8N_c1vdZKufmDuWRwY-br1731VOfdgcfrsENLcHEmBvKBezon6GIGNdFV-OHAOSDfCXsE/s800/01_odbc.png)
Choose the System DSN tab
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX6-An4_n4da6d6xVomZ9KB_cMqZuoxcjxRBrqOytdikeph1l6RNsDrG1YC3yqbH29kjYrMArVobd9QNcBAhVMLXn3OrmOZ4jvaCekMmoShu4xzTW8Kbp6ArVKaHgLfFVKqwNjeoeqD-Ro/s800/02_odbc_system_dsn.png)
Click on Add
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0HN29ysBYK9H-nsO6Xs4H9wu2_kVrEJ2nbC9LdpBXOaUajD1MEZsLFtIcxq__m-zOYGvyhrOaX9uJ5dC67orzFBoZLF73iFWo7I1CsAQ9-YW_rjps-a7hYuF0rgpmj-zIwZrm_ZT8CVKq/s800/03_odbc_add.jpg)
Then select the BI Server driver
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHfYPR6FOGDSJOUxwqHks4_R16ay-DC2V4ew9eZYKqcfMTQel2eMs_nXt-gQpQHnm7nsJ1Z9mA6lFs1-HWjjD1cEUP0_c0q97sfqkf6wmtn6e3P93L6RYXn4wKW_iokjJoTfU_AjfGrK8/s800/04_odbc_bi_driver.jpg)
You'll be prompted with this:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLEp44ag31C1xRiwHxxX1Wdy_EH770xuZCCzh1ybsjKYBYGLSXqFo-xp4QgmnuNBn4thmXJZe1xiq4SdwKh9pHp7G4Qd2bWRuTI5oZwhKXdym59rJ86wwBK1h3Avv4x4Fmx-0cS25Ezoc9/s800/06_odbc_bi_server_config_01.png)
For name enter "remote_rpd", for server, select the location of your other server, in my case, it's XP
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVU1ieLAVac3xixo8UWplVw8Pemek4fo80OKrRTts4hXqQXtmm5EprUAHPUbhl7OgDGkQiqhL5qxZtSVpbeDfWyvzqASbSepNYxETceg9tbojVDrnVGMz4L3_KSrQAKIqImQ_m0r08Oe4M/s800/07_odbc_bi_server_config_02.png)
Enter the username and password to the remote RPD (if you haven't changed anything, it's Administrator/Administrator)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE5J4IjrK8tEnYn2xTpSRdiWmt0Y6wfQJs1nQy3zvDEYMSu7PwwusrBzKLUVvCdCEGyoXHLn_UZroaTpM1Mme_HLbSKtTbWcimOKRSNxFlhExyiBzMePCVsXgasKH8HyylUqT6xSPNLj0/s800/09_odbc_driver_03.png)
Go ahead and accept the defaults
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIBFdR8wIJPYQQW7RTANGfGAGy-dQkXAp6QohwYwZ6VSZLSUvEfFhcoMocHnswpQKFzQKEyquP4FAwY32wdnf5qDZ6-GQCLcX_-s3jAp8Vejh4eOXuQwmgkLmy6QxiOiP2edz_0LCaZSw/s800/10_odbc_bi_server_04.png)
You should now see "remote_rpd" in your list of data sources
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWo2K3N0Mkm4dEWzKwZx8S38FjjBfYh1fuz2cYPiE0j2PVpV2_ewgzaOgNaDSY4DSPcc7p5f5Y12kWoWPmXDRuqno-SpKzUZv6cBbJYcXY1mKITIiitfsLHseRfoS5TkhLb3-LtmdA91c/s800/11.png)
Finally, open up your BI Administration tool and you should see "remote_rpd" in your list
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5SVYlU4g7iqAynrO-4en-VQ7yVJa4jEYLEKCKMeB7NlDBML-5vuMypUlmU_05pC8-Flwg-EmOuAdskmrBF25FU_kozWQYGtwtt1v0Y3f2fHxMyLZ2d0OAtMW8CONFUIx9KJN6Ar_suCJJ/s800/11.jpg)
Enter the password and voila! You are in.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVC6-0K-TzreX_CfjBTb-QwA2sBT8ps1rRrC4XgHLV1efbX5uRX5NwvYoiRBQGJFEIXPubWeP6TXi7-czI5bS4VNNUg-BLi-I3iG9l16ocDUqpIn6ljw6xILdVAzrHIjUwuz3-7MiSzPtl/s800/Screenshot-2.jpg)
5 comments:
Good post :)... I remember when I started at my new company as an Oracle DBA, I was told, besides Oracle, you are the OBIEE admin... I was thinking huh? So I set it up, and this is where I hit a snag. I finally figured it out and was able to connect to clear things like cache. I go to OBIEE training next week (woot!).
It's good to learn new stuff. Besides that I am the Informatica, OC4J, Tomcat, WebSphere, Weblogic, Oracle App Server admin. Talk about lots of junk.
jack of all trades
admittedly, it's kind of fun knowing a bit about everything and it doesn't hurt the career much either.
once you complete the dataguard post...you can do another one on OBIEE. :)
Good day, sun shines!
There have were times of hardship when I felt unhappy missing knowledge about opportunities of getting high yields on investments. I was a dump and downright stupid person.
I have never thought that there weren't any need in large starting capital.
Nowadays, I feel good, I started take up real income.
It's all about how to select a correct companion who utilizes your funds in a right way - that is incorporate it in real business, and shares the income with me.
You may get interested, if there are such firms? I have to answer the truth, YES, there are. Please be informed of one of them:
http://theinvestblog.com [url=http://theinvestblog.com]Online Investment Blog[/url]
intersting post. I just tried to repeat these steps, but I struggle at the point where you select your server "xp". I have only "local" available. Any idea how I can edit this menu and define a server host name?
Gracias, Merci, DANKE, Thanks
Post a Comment