Connecting Design Studio to non SAP DB

[Former Member]

Hi,

am trying to connect Design Studio to an Oracle DB. I am currently on DS version 1.6. I also need to perform some queries to this db, not only connect an load one specific table.

Any guidance on connecting to Oracle would be great.

Thanks!

[TammyPowlas]

You can use a universe to connect to an Oracle database, and then connect Design Studio to your database

Please confirm, are you using Design Studio or ByDesign - these are 2 completely different products

[Former Member]

Hi !

I am using Design Studio.

But creating an universe will I be able to perform queries to the database ? I am a bit disoriented. The fact is that one use case involves join queries to this Oracle non SAP DB according to user input, and the result data should be displayed in the DS dashboard app.

[TammyPowlas]

The universe is the semantic layer to the database

You can't connect directly to Oracle from Design Studio

[Former Member]

I know, but I don't think that creating an universe will do. The oracle db is relational. I have a table with requests and then request_type, request_place, states, countries. The app should query 'requests' joining the other tables, with filters ( dates, request_type, country ). These filters are selected in the design studio app.

I also have to query a single table and perform some things ( for example, load client data ).

And on another use case, I have to update that database.

Is this scenario achievable with a BI universe ?

[TammyPowlas]

Using the SAP Information Design Tool you can join/link tables to create a universe

[Former Member]

Hi thanks for your help ! I will try to see if I can make it work that way. I will have to load the whole db in a Universe so I can filter it from my dashboard ( I think that will excceed the results set limitations ).

And is it possible to append data to the universe ? I will have an textarea for user to include some comments, and this comments should be inserted to a table in my Oracle db.

[TammyPowlas]

That's a question to ask using the Semantic Layer tag - I don't know if it will do that.