Question

5
Replies
918
Views
SonalVasisth06 Member since 2016 10 posts
JP Morgan Chase & Co.
Posted: 4 years ago
Last activity: 4 years ago
Closed

BIX Configuration

Problem: XXX_BIX_APP user is unable to insert records into BIX database from PEGA database.

Error: ABC table doesn't exist in target Database: bix.  ---- Here, bix is the DB instance name in PEGA and ABC table is given in extract t

Explanation:

  • We have a DB instance name called "BIX" and it's schema owner user 'XXX_BIX'.
  • Using this user we have created tables in BIX database like XXX_BIX.ABC.
  • In extract rule, output database name is given as 'BIX' and To table name is mapped as 'ABC'
  • In webconsole, if we configure BIX datasource user as XXX_BIX, it is able to insert records into ABC table. - WORKING FINE
  • BUT, we didn't want to use a schema owner just to write instances to BIX tables so, we created another user 'XXX_BIX_APP' with CONNECT and READ WRITE role to BIX database.
  • If we connect to BIX database using this user in sql developer studio, tables are accessible under XXX_BIX schema like.... XXX_BIX.ABC
  • Now, since XXX_BIX_APP user has write role to BIX database, we updated webconsole databsource to connect to BIX database using XXX_BIX_APP but when agent runs the extract rule, it's throwing error 'ABC table doesn't exist in target Database: bix".
  • This could be because XXX_BIX_APP user is looking for first schema name XXX_BIX to write instances to ABC table

Please advise how and where we can configure default schema name for XXX_BIX_APP user to write instances to ABC table under XXX_BIX schema in BIX database from PEGA.

System Administration
Moderation Team has archived post
Share this page LinkedIn