Skip to Content
0

Changing data foundation to a business layer

Mar 06, 2017 at 02:16 PM

49

avatar image

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.

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

2 Answers

AMIT KUMAR
Mar 06, 2017 at 03:53 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Jyothirmayee A Mar 06, 2017 at 03:25 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded