Solved how to set multiple dataschema configuration as source

Hi,

It seems there is no schema name in the executed query.
For the schema provided in the configuration to be properly used in query you should do the following:

1. Create a metadata link to the default shema by sliding it from object explorer to the query in metadata explorer:

2. In the query in place of schema name use the following syntax:
{$HOTEL_MANAGEMENT/tech:physicalName()}
In my example it looks like this:

Of course you should change the HOTEL_MANAGEMENT part to reflect the name of the metadata link that you created.
After this is done the schema in the query should be properly substituted by the schema name defined in the configuration.
Please let me know if it worked for you.
If you still experience problems do not hesitate to contact Stambia Support.

Kind regards,
Adrian

Hi,

What is the name of the metadata link in your query?
Can you try using it instead of "." like explained in my previous message?
For example:
select top 10 * from
{$MetadataLinkName/tech:physicalName()}.C_INVEST_ANA_FAIL


Best regards,
Adrian

Hi,

I have tried this and it returns nested query if you use the "." but it works fine with the metadata link name as suggested above.

Have you saved the metadata after you changed the expression in the query and before trying the reverse?
If not, the designer takes the last saved expression (so the one with ".") and therefore would give you the same error.
Also, please make sure that the metadata link you are using is a link to a schema and not to the table.
The one you used on Sql operation is a link to a specific table not a schema.
If you want to use this link you need to use the following expression:
select top 10 * from
{$C_INVEST_ANA_FAIL/tech:physicalPath()}

If you still cannot make it work I suggest you make an export of your metadata and send it to Stambia Support so they can have a look.

Best regards,
Adrian