Open topic with navigation

ibi™ MDM Add-on for Global Data Synchronization 4.0.0

# Configuring Database Changes

Procedure
1. Navigate to the database.
2. Run the following scripts from the database.

Result
Note: Use the OrgID of your organization and replace it in the SQL below where it displays <Org ID Here>.

- Bottler Subscription Rulebase

      insert into ConfigurationDefinition (ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION, ACTIVE, MODMEMBERID, MODDATE, MODVERSION)
      VALUES (Mq_Sequence_1.nextval, 'Rulebase', <Brandowner's Org ID Here>, 'N', 'Bottler Subscription', ‘SUBSCRIPTION’, 'Select Subscription.', 'File', 'bottler/rulebase/rbsynchtradingpartner.xml', 'Y', 1, SYSDATE, 1);
      COMMIT;

- BrandOwner Translation Map

      insert into ConfigurationDefinition
      (ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION,
       ACTIVE, MODMEMBERID, MODDATE, MODVERSION)
      VALUES (Mq_Sequence_1.nextval, 'XSLT', <Brandowner's Org ID Here>, 'N', 'Custom Map', 'CONNECTOR',
      'Message Translation.', 'File', 'standard/maps/mpfromcatact26toveloselcinv1.xsl', 'Y', 1, SYSDATE, 1);
      COMMIT;

- VeloselMarketplace Translation Map

      insert into ConfigurationDefinition
      (ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION,
      ACTIVE, MODMEMBERID, MODDATE, MODVERSION)
      VALUES (Mq_Sequence_1.nextval, 'XSLT', <VeloselMarketplace's Org ID Here>, 'N', 'Custom Map', 'CONNECTOR', 'Message Translation.', 'File', 'standard/maps/mpfromcatact26toveloselcinv1.xsl', 'Y', 1, SYSDATE, 1);
      COMMIT;
      insert into ConfigurationDefinition
      (ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION,
       ACTIVE, MODMEMBERID, MODDATE, MODVERSION)
      VALUES (Mq_Sequence_1.nextval, 'XSLT', <VeloselMarketplace's Org ID Here>, 'N', 'Custom Map', 'CONNECTOR',
      'Message Translation to create Response.', 'File', 'standard/maps/mpfromveloselcintoveloselcinrv1.xsl', 'Y', 1, SYSDATE, 1);
      COMMIT;

- VeloselMarketplace Subscription Rulebase

      insert into ConfigurationDefinition (ID, TYPE, OWNERID, GLOBAL, NAME, SELECTOR, DESCRIPTION, DEFINITIONTYPE, DEFINITION, ACTIVE, MODMEMBERID, MODDATE, MODVERSION) VALUES (mq_sequence_1. nextval, 'Rulebase', <VeloselMarketplace's Org ID Here>, 'N', 'Bottler Subscription', 'SUBSCRIPTION', 'Select Subscription.', 'File', 'bottler/rulebase/rbsynchveloselmarketplace.xml', 'Y', 1, SYSDATE, 1)
      COMMIT;

- VeloselMarketplace Translation Maps (Instance 2)
  - XSL Map for translating CIM CIN to mlXML:  mpfromveloseltomlxml26v1.xsl
  - XSL Map for translating CIM CIN to CIM CIN Response: mpfromveloselcintoveloselcinrv1.xsl

Note: For simplicity, you can make all the above Subscription Rulebase and Translation Map files globally available as follows:

- Enter a value '1' instead of <Brandowner's OR VeloselMarketplace's Org ID Here> for column OWNERID
- Enter a value 'Y' instead of 'N' for column GLOBAL.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

ibi™ MDM Add-on for Global Data Synchronization

Copyright © 1999-2023. Cloud Software Group, Inc. All Rights Reserved.