cancel
Showing results for 
Search instead for 
Did you mean: 

DBMS Independent universe

0 Kudos

Is it possible to create a universe (and a corresponding set of standard reports) that is not dependent on the DBMS used for storing the data - obviously ensuring that the structure of the tables are the same?

Are there any best practices to follow in this case?

The moment one starts using certain database functions (e.g. sysdate vs getdate()) in report definitions, it ties the definition to the specific database type

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Henk,

Yes there is a way. You can do a lot of off-line development whilst not connected to the RDMS.

One way of doing this is to create you tables structures by means of rows and columns in MS Access or even Excel. Create an ODBC connection to either of these.

Create a connection in the universe using Generic - Generic ODBC. Import the tables or sheets and the SQL generated is much the same... with exception of the RDMS specific functions you mentioned.

And you should be able to have a univerise and a set of reports.

Hope this helps

Jacques

Answers (1)

Answers (1)

amrsalem1983
Active Contributor
0 Kudos

for WebIntelligence, i dont think you can do such thing, coz to create a Webi Report you have to have a query of data, and to ba able to have a query you have to have a datasource, and there is many things depend on the vendor of the datasource as your examle getdate() , its not the same in the same DBMS.

you can create the universe based on some Datasource, and create all your reports based on this universe,

but once you want to change the datasource vendor, you have to change the connection of the universe

and in turn you have to revise back all the harded coded functions or any extra SQL statements has been written in the universe, and modify it back,

you can use the option of "Refresh stuructre" or you can you can use the option of checking the universe.

good luck

Amr