Skip to Content
0
May 20, 2016 at 08:51 AM

Custom database funcion multisource universe

176 Views

Hi all,

I would like to call a custom db function in my IDT universe.

Basically what I found is that if I create a SINGLE SOURCE universe there are no problems, it works.

Is there a way to do the same thing in a MULTI SOURCE universe?

I understand I have one more "layer" between my db and the universe but I hope there is something that allows me to achieve my result.

Some details:

the universe is a UNX based on a SQL Server and an ORACLE 11g.

My custom function is saved under SQL Server and I want to create an object in the BLX that calls my custom function.

In a single source universe I have declared the object as:

dbo.FUNC_LOGBO(@Variable('BOUSER'), @Select(Tananarep\Nomefile), @Select(Tananarep\Idr), ISNULL(@Select(Tananarep\Progvers),0), getdate(), @Select(Tananarep\Reploc))

the same object in a multisouce universe returns this error:

Thanks in advice

Fulvio