Skip to Content

Changing data foundation to a business layer

Hi all,

I have a business layer which is pointing to a multi-source data foundation. I want to point this business layer to a single-source data foundation.

It is easy to re-point a BL to a different data foundation but then the problem is the syntax of the select in the SQL definition. For a multi-source data foundation the syntax is: "schema"."table"."object". For a single-source data foundation the syntax is: table.object without schema and without inverted commas "".

Is there an easy way to change all the objects' SQL definition in the BL without going one by one?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 06, 2017 at 03:53 PM

    I haven't tried to replace multisource DF to single source but if you have concern on double quotes only then you can use Find/Replace function in Business layer to replace " with one blank space.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 03:25 PM

    Hi,

    I afraid there is no easy/automatic way to map existing BL objects to the new Data foundation

    Reference to the old connection does not get replaced with new one within existing BL.

    Try creating a new BL with in the same project and pull in objects from New DF or drag and drop new DF table columns into same BL class folder ( you should see "Name1" if there is a duplicate column names with in BL), Change the description accordingly.

    Just providing my view by experience. you can wait for others to reply.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded