Connecting Luminis to another database
Hi everyone!
Has anyone tried to connect to another database than the one configured?... ok.. I am asking to much in one question... let me explain the scenario here.
Our college is new to banner, we have implemented succesfully, finance, HR and Finantial Aid, we are trying here and there with student, no matter my Luminis Test environment is pointing to our PPDB (preprod) which is ok but someone had the fantastic idea (I don't know if this is done anywhare else) to have a PPDB for students (PPST) one for Finance (PPFI) and one for Financial Aid (PPFA) now... they are not using the PPDB for anything and that is not allowing me to really "test" anything... now... all the configuration for the middle tier is in our PPDB database, no matter, with the "guide" that SUNgard delivers I might be able to reproduce the middle tier config, now... how can I point the portal to either one of these DBs?... is this possible??
Any information will help TONS!!
Thanks!
- ma_isaura's blog
- Login or register to post comments
Hack Your Knowledge
Recent blog posts
- SCT Banner Administrator Needed
- Maintaining Subscriptions & Calendar Sets When Rebuilding Accounts in Luminis 3.3.3.142 on Win 2000
- Creating a New Fragment and Assigning a Layout Owner
- Compiling usage stats
- Mashup for Social Good
- Group Tools Version 2.0 (Contains Group Activity and Group Request channels)
- Luminis Platform 4.0.2.0 build 177 - Issue with early user timeouts
- Luminis IV and database restarts - The answer.
- https
- Custom Luminis API
Developer Links
Poll
Syndicate
Comments
instance soup
>a PPDB for students (PPST) one for Finance (PPFI) and one for Financial Aid (PPFA)
Good Lord. You mean a different Banner instance for each of those modules? How do they communicate so you can test financial aid info with student data and finance info ?? Wow, glad I'm not the DBA there.
So you have your luminis tables in PPDB and you want to change that to one of the other instances?
There's an article here I wrote a while back, its quite easy - Luminis Heart Transplant. That said you might have to export your luminis (and uPortal) schemas and import them into the other instance, depending on how the other instances are created / updated.
-Jon
Heart Transplant on Lum IV
Hi Jon!
I really think our DBA spoils the users but oh well... like you said, I am glad I am not the DBA; but because of this I can't have a true test environment.
Anyways thanks for your guidence, have you tested this "heart transplant" on Lum 4?, you know our SunGard folks adding extra issues as the releases "release"...
I am going to make an image of my test environment and try this settings on the weekend!
By the way, I would have also to do Middle Tier to this DB right?
Thanks Jon!
You can do a heart transplant on 4
Our TEST luminis instance, built after we killed our first test luminis instance, stored its schema in our DEVL Banner instance and had middle tier set up to connect to DEVL (SSB and banner channels) but SSB was served up through our DAD for PPRD because we had an SSL cert for that one and not DEVL...yeah it was a mess that we laughed at every time we tried to explain it.
Then our DBAs killed DEVL while working on the upgrade to Oracle 10g, so rather than reinstall, I decided to see if I could connect luminis TEST to Banner TEST. To change the database, I had to change a few configman values, I think I had to change something in a configuration file too, and then I had to redo parts of middle tier. I should have but didn't keep better notes.
Then I ended up deleting almost all the channels, since I was grafting Luminis TEST onto a clone of the PROD database, so a lot of channels were showing the wrong content. After I got all the channels (except the baseline ones still in sync) deleted, and after a couple restarts, the Banner channels automagically showed up again. I was deleting the channels in the GUI, in the DB, and in the LDAP until I got it to work; there's probably a smarter way to do it but it worked "good enough" for our test system.