Skip to Content
0

Connecting Design Studio to non SAP DB

Feb 07, 2017 at 02:44 PM

152

avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Feb 07, 2017 at 03:40 PM
0

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

Show 6 Share
10 |10000 characters needed characters left characters exceeded

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.

0

The universe is the semantic layer to the database

You can't connect directly to Oracle from Design Studio

0

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 ?

0

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

0

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.

0

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

0