x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 10 subscribers
  • Views 2134 views
  • Users 0 members are here
Browse Forums
Announcements
234
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
208
topics
406
replies
Sage Intelligence Reporting
121
topics
322
replies
Ricardo Silva

How to know the actual schema used for the SI?

Posted By

Hi all,

Anyone knows how I can determine which database schema It's a customer currently connected within SI?

I can easily know the database connection details but I would like to know which schema I'm connected too?

I can determine this from the prompt parameters when running a report from the report manager but I would like to know if there is another place to check it?

Thanks.

Ricardo Silva

Parents
  • 0

    In SI for X3, the X3 folder you connect to is determined by the default schema for the SQL login you enter when you launch SI.

    To change to a different schema, you need to logout of SI and reconnect using a login for the other schema.

    If a site has two X3 folders, then you will need to create separate SQL users for each folder, with the relevant default schema for each folder.

    This is done using the "SQL User Creation Tool" installed with SI or can be .done directy in SQL Server Management Studio.

Reply
  • 0

    In SI for X3, the X3 folder you connect to is determined by the default schema for the SQL login you enter when you launch SI.

    To change to a different schema, you need to logout of SI and reconnect using a login for the other schema.

    If a site has two X3 folders, then you will need to create separate SQL users for each folder, with the relevant default schema for each folder.

    This is done using the "SQL User Creation Tool" installed with SI or can be .done directy in SQL Server Management Studio.

Children
No Data

*Community Hub is the new name for Sage City