3 Replies Latest reply on Jul 12, 2017 1:32 AM by laura.gough

    DB-Link between SBS and EAE

    gzsakai

      As I've seen, no DB-Link exists between SBS and EAE Dbs in our Jive8 On-Premise environment.

      Is it allowed to create one or it would have disadvantages or performance consequences?

      THX

        • Re: DB-Link between SBS and EAE

          Hi,

           

          Sorry no one has answered this question, I am a little confused, please can you explain how you were going to create a link between the 2 DB and I can investigate further?

           

          Kind Regards

           

          Laura

            • Re: DB-Link between SBS and EAE
              gzsakai

              Hi Laura,

              sometimes I'm asked to provide custom 'reports'. I'm usually in trouble, because I can not JOIN tables. For example: I need the JIVEUSER from SBS and the JIVESTREAMASSOCIATION from EAE. These tables both have USERID, so I could JOIN them, but the are on two separate DBs.

              I would like to use the following Oracle Standard object:

              CREATE DATABASE LINK

              But I would like to ask Jive experts first, before I ruin something. :-)

              THX

              Gyula

            • Re: DB-Link between SBS and EAE

              Hi,

               

              This should be fine and not cause a problem however is unsupported by Jive in that if it causes an issue we may ask you to remove the DB Link. Please ensure you do not alter or add constraints to tables or remove permissions.

               

              Please let me know if you have any issues,

               

              Laura

              1 person found this helpful