Stambia MDM Integration Guide

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:int="http://www.semarchy.com/xml/ws/1.3/platform/IntegrationLoadService">
   <soapenv:Header/>
   <soapenv:Body>
      <int:persistRowsInLoad>
         <loadId><!-- load_id --></loadId>
         <payload>
            <defaultPublisherId><!-- publisher_code --></defaultPublisherId>
            <!--1 or more repetitions:-->
            <entityRows>
               <entityName><!-- entity_name --></entityName>
               <!--1 or more repetitions:-->
               <dataRowsToPersist>
                  <!--Zero or more repetitions:-->
                  <Value name="?">
                     <!-- Select and fill one of the datatype tag -->
                     <binary>cid:88734163910</binary>
                     <boolean>?</boolean>
                     ...
                     <!-- All model datatypes are supported here -->
                     ...
                     <string>?</string>
                     <uuid>?</uuid>
                  </Value>
               </dataRowsToPersist>
            </entityRows>
         </payload>
         <generateIds>true</generateIds>
      </int:persistRowsInLoad>
   </soapenv:Body>
</soapenv:Envelope>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:int="http://www.semarchy.com/xml/ws/1.3/platform/IntegrationLoadService">
   <soapenv:Header/>
   <soapenv:Body>
      <int:persistRowsInLoad>
         <loadId>550</loadId>
         <payload>
            <defaultPublisherId>CRM</defaultPublisherId>
            <entityRows>
               <entityName>Customer</entityName>
               <dataRowsToPersist>
                 <Value name="SourceID"><string>1260</string></Value>
                 <Value name="CustomerName"><string>Sambalele</string></Value>
               </dataRowsToPersist>
            </entityRows>
            <entityRows>
               <entityName>Customer</entityName>
               <dataRowsToPersist>
                 <Value name="SourceID"><string>1261</string></Value>
                 <Value name="CustomerName"><string>ACME Corp.</string></Value>
               </dataRowsToPersist>
            </entityRows>
            <entityRows>
               <entityName>Contact</entityName>
               <dataRowsToPersist>
                 <Value name="SourceID"><string>1261.1</string></Value>
                 <Value name="FirstName"><string>Bugs</string></Value>
                 <Value name="LastName"><string>Bunny</string></Value>
                 <Value name="SourceID_Customer"><string>1261</string></Value>
                 <Value name="PublisherID_Customer"><string>CRM</string></Value>
               </dataRowsToPersist>
            </entityRows>
         </payload>
         <generateIds>false</generateIds>
      </int:persistRowsInLoad>
   </soapenv:Body>
</soapenv:Envelope>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"/>
   <soap:Body>
      <ns2:persistRowsInLoadResponse xmlns:ns2="http://www.semarchy.com/xml/ws/1.3/platform/IntegrationLoadService">
         <rows>
            <rowId>
               <string>1260</string>
            </rowId>
            <rowId>
               <string>1261</string>
            </rowId>
            <rowId>
               <string>1261.1</string>
            </rowId>
         </rows>
      </ns2:persistRowsInLoadResponse>
   </soap:Body>
</soap:Envelope>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.semarchy.com/xml/ws/1.0/data/CustomerAndFinancialMDM/0.0">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:persistRecordsInLoad>
         <loadId>?</loadId>
         <payload>
            <defaultPublisherId>?</defaultPublisherId>
            <!-- You have a CHOICE of the next 4 items at this level-->
            <!-- Repeat to create more than one record -->
            <Contact>
               <PublisherID>?</PublisherID>
               <SourceID>?</SourceID>
               <FirstName>?</FirstName>
               <LastName>?</LastName>
               ...
               <!-- Other attributes for Contact here -->
               ...
               <PublisherID_Customer>?</PublisherID_Customer>
               <SourceID_Customer>?</SourceID_Customer>
            </Contact>
            <CostCenter>
               ....
               <!-- Other attributes for CostCenter here -->
               ...
            </CostCenter>
            <Customer>
               <PublisherID>?</PublisherID>
               <SourceID>?</SourceID>
               <CustomerName>?</CustomerName>
               <TotalRevenue>?</TotalRevenue>
               <InputAddress>
                  <Address>?</Address>
                  <PostalCode>?</PostalCode>
                  <City>?</City>
                  <Country>?</Country>
               </InputAddress>
               <GeocodedAddress>
                  <StreetNum>?</StreetNum>
                  <Street>?</Street>
                  <!-- Other fields from the GeocodedAddress complex type below -->
                  ...
                  <Quality>?</Quality>
               </GeocodedAddress>
               <FID_AccountManager>?</FID_AccountManager>
            </Customer>
            <Employee>
               ...
               <!-- Other attributes for Employee here -->
               ...
            </Employee>
         </payload>
      </ns:persistRecordsInLoad>
   </soapenv:Body>
</soapenv:Envelope>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:int="http://www.semarchy.com/xml/ws/1.3/platform/IntegrationLoadService">
   <soapenv:Header/>
   <soapenv:Body>
      <int:persistRowsInLoad>
         <loadId>550</loadId>
         <payload>
            <defaultPublisherId>CRM</defaultPublisherId>
            <entityRows>
               <!-- No ID provided here ... -->
               <entityName>Customer</entityName>
               <dataRowsToPersist>
                  <Value name="CustomerName"><string>Goliath Corp</string></Value>
               </dataRowsToPersist>
            </entityRows>
         </payload>
         <!-- ... but IDs will be generated -->
         <generateIds>true</generateIds>
      </int:persistRowsInLoad>
   </soapenv:Body>
</soapenv:Envelope>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"/>
   <soap:Body>
      <ns2:persistRowsInLoadResponse xmlns:ns2="http://www.semarchy.com/xml/ws/1.3/platform/IntegrationLoadService">
         <rows>
            <rowId>
               <string>c09bea6e-f16f-4e62-b69f-aea31bcfa5b6</string>
            </rowId>
         </rows>
      </ns2:persistRowsInLoadResponse>
   </soap:Body>
</soap:Envelope>

  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

  
select M.B_SOURCEID, G.*
from MD_<Physical_Table_Name> M
inner join GD_<Physical_Table_Name> G on
  (        G. <primary_key_column> = M. <primary_key_column>
  and        G.B_BRANCHID = <branch_id>
  and        G.B_CLASSNAME in ( <classname_list> )
  and        G.B_FROMEDITION <= <edition>
  and (        G.B_TOEDITION is null or
        G.B_TOEDITION > <edition> )
  )
where
        M.B_BRANCHID = <branch_id>
  and        M.B_CLASSNAME in ( <classname_list> )
  and        M.B_FROMEDITION <= <edition>
  and (        M.B_TOEDITION is null or
        M.B_TOEDITION > <edition> )
  and         M.B_PUBID = '<publisher_code>'
  and         M.<primary_key_column> = '<searched_source_id>'

select         M.EMPLOYEE_NUMBER, G.FIRST_NAME, G.LAST_NAME
from         MD_EMPLOYEE M
inner join GD_EMPLOYEE G on
 (        G.EMPLOYEE_NUMBER = M.EMPLOYEE_NUMBER
  and        G.B_BRANCHID = 0
  and        G.B_CLASSNAME = 'Employee'
  and        G.B_FROMEDITION <= 1
  and (        G.B_TOEDITION is null or G.B_TOEDITION > 1 )
  )
where
        M.B_BRANCHID = 0
  and        M.B_CLASSNAME = 'Employee'
  and        M.B_FROMEDITION <= 1
  and (        M.B_TOEDITION is null or M.B_TOEDITION > 1 )
  and         M.B_PUBID = 'HR'
  and         M.EMPLOYEE_NUMBER = '100'

  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

  
select M.B_SOURCEID, G.*
from MD_<entity> M
inner join GD_<entity> G on
  (        G. <primary_key_column> = M. <primary_key_column>
  and        G.B_BRANCHID = <branch_id>
  and        G.B_CLASSNAME in ( <classname_list> )
  and        G.B_FROMEDITION <= <edition>
  and (        G.B_TOEDITION is null or
        G.B_TOEDITION > <edition> )
  )
where
        M.B_BRANCHID = <branch_id>
  and        M.B_CLASSNAME in ( <classname_list> )
  and        M.B_FROMEDITION <= <edition>
  and (        M.B_TOEDITION is null or
        M.B_TOEDITION > <edition> )
  and         M.B_PUBID = '<publisher_code>'
  and         M.B_SOURCEID = '<searched_source_id>'

  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

  
select M.B_SOURCEID, G.FIRST_NAME, G.LAST_NAME
from         MD_CONTACT M
inner join GD_CONTACT G on
 (        G.CONTACT_ID = M.CONTACT_ID
  and        G.B_BRANCHID = 0
  and        G.B_CLASSNAME = 'Contact'
  and        G.B_FROMEDITION <= 1
  and (        G.B_TOEDITION is null or G.B_TOEDITION > 1 )
  )
where
        M.B_BRANCHID = 0
  and        M.B_CLASSNAME = 'Contact'
  and        M.B_FROMEDITION <= 1
  and (        M.B_TOEDITION is null or M.B_TOEDITION > 1 )
  and         M.B_PUBID = 'CRM'
  and         M.B_SOURCEID = '27030'

select
  M.B_PUBID DUP1_PUBLISHER, M.B_SOURCEID DUP1_ID, M.FIRST_NAME DUP1_FIRST_NAME, M.LAST_NAME DUP1_LAST_NAME,
  MM.B_PUBID DUP2_PUBLISHER, MM.B_SOURCEID DUP2_ID, MM.FIRST_NAME DUP2_FIRST_NAME, MM.LAST_NAME DUP2_LAST_NAME,
  G.CONTACT_ID GOLD_ID, G.FIRST_NAME GOLD_FIST_NAME, G.LAST_NAME GOLD_LAST_NAME
from         MD_CONTACT M
inner join GD_CONTACT G on
 (        G.CONTACT_ID = M.CONTACT_ID
  and        G.B_BRANCHID = 0
  and        G.B_CLASSNAME = 'Contact'
  and        G.B_FROMEDITION <= 1
  and (        G.B_TOEDITION is null or G.B_TOEDITION > 1 )  )
inner join MD_CONTACT MM on
 (        MM.CONTACT_ID = M.CONTACT_ID
  and        MM.B_BRANCHID = 0
  and        MM.B_CLASSNAME = 'Contact'
  and        MM.B_FROMEDITION <= 1
  and (        MM.B_TOEDITION is null or MM.B_TOEDITION > 1 )  )
where
        M.B_BRANCHID = 0
  and        M.B_CLASSNAME = 'Contact'
  and        M.B_FROMEDITION <= 1
  and (        M.B_TOEDITION is null or M.B_TOEDITION > 1 )
  and         M.B_PUBID = 'CRM'       /* Publisher ID */
  and         M.B_SOURCEID = '27030'  /* Source ID */
  /* and M.B_PUBID = MM.B_PUBID */
  /* Uncomment the previous line to restrict the duplicates
     to those within the CRM application */

select SE.B_BATCHID,
  SE.B_CONSTRAINTNAME, SE.B_CONSTRAINTTYPE,
  SE.B_PUBID, SE.B_SOURCEID, SE.FIRST_NAME, SE.LAST_NAME,
  SE.FP_CUSTOMER, SE.FS_CUSTOMER
from SE_CONTACT SE
where
  SE.B_BRANCHID = 0
  and SE.B_CLASSNAME = 'Contact'
  and SE.B_BATCHID = ( select max(B_BATCHID)
                       from SE_CONTACT
                       where SE.B_BRANCHID = 0 )

select GE.B_BATCHID,
  GE.B_CONSTRAINTNAME, GE.B_CONSTRAINTTYPE,
  GE.EMPLOYEE_NUMBER, GE.FIRST_NAME, GE.LAST_NAME,
  GE.F_COST_CENTER, GE.F_MANAGER
from GE_EMPLOYEE GE
where
  GE.B_BRANCHID = 0
  and GE.B_CLASSNAME = 'Employee'
  and GE.B_BATCHID = ( select max(B_BATCHID)
                       from GE_EMPLOYEE
                       where GE.B_BRANCHID = 0 );

<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
 xmlns:ns="http://www.semarchy.com/xml/ws/1.0/data/CustomerAndFinancialMDM/0.0">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:getCustomer_GoldenData_List>
         <query>
                 <SemQLCondition>CustomerName LIKE 'G%'</SemQLCondition>
                 <StartIndex>0</StartIndex>
                 <PageSize>20</PageSize>
         </query>
      </ns:getCustomer_GoldenData_List>
   </soapenv:Body>
</soapenv:Envelope>

<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
 xmlns:ns="http://www.semarchy.com/xml/ws/1.0/data/CustomerAndFinancialMDM/0.0">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:getCustomer_GoldenData_Record>
         <recordKey>
            <CustomerID>20</CustomerID>
         </recordKey>
      </ns:getCustomer_GoldenData_Record>
   </soapenv:Body>
</soapenv:Envelope>

  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

  
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns1:getCustomer_GoldenData_RecordResponse ... >
         <return>
            <BatchID>41</BatchID>
            <BranchID>0</BranchID>
            <FromEdition>1</FromEdition>
            <ClassName>Customer</ClassName>
            <CreationDate>2011-09-21T09:37:42.738+02:00</CreationDate>
            <Creator>joeletaxi</Creator>
            <CustomerID>20</CustomerID>
            <CustomerName>GENERAL SERVICES CORPORATION</CustomerName>
            <TotalRevenue>9111</TotalRevenue>
            <InputAddress>
               <Address>1 TERRITORIAL DRIVE</Address>
               <City>BOLINGBROOK</City>
               <Country>USA</Country>
            </InputAddress>
            <GeocodedAddress/>
            <FDN_Employee>Adam FRIPP</FDN_Employee>
            <FID_Employee>121</FID_Employee>
         </return>
      </ns1:getCustomer_GoldenData_RecordResponse>
   </soap:Body>

<soapenv:Envelope>
   <soapenv:Header/>
   <soapenv:Body>
      <gen:RowQuery>
         <QuerySource>
            <!-- Golden Data view for the Customer entity -->
            <gen:EntityName>Customer</gen:EntityName>
            <ViewType>GD</ViewType>
         </QuerySource>

         <!-- Select Expressions, incl. an aggregate (SUM) -->
         <SelectExpression>AccountManager.FirstName || ' ' || AccountManager.LastName
           </SelectExpression>
         <SelectExpression>InputAddress.Country</SelectExpression>
         <SelectExpression>SUM(TotalRevenue)</SelectExpression>

         <!-- Filter applied on the data, using the EMP biding. -->
         <WhereCondition>AccountManager.FirstName||' '||AccountManager.LastName LIKE :EMP
           </WhereCondition>

         <!-- The SUM calls for a group by on the other expressions -->
         <GroupByExpression>InputAddress.Country</GroupByExpression>
         <GroupByExpression>AccountManager.FirstName || ' ' || AccountManager.LastName
           </GroupByExpression>

         <!-- Ordering the results -->
         <OrderByCriteria descending="true">SUM(TotalRevenue)
           </OrderByCriteria>

         <!-- Definition for the EMP biding with the value -->
         <Binding name="EMP">
            <String>S%</String>
         </Binding>

         <!-- Result pagination -->
         <PageCriteria>
            <StartIndex>0</StartIndex>
            <PageSize>10</PageSize>
         </PageCriteria>
      </gen:RowQuery>
   </soapenv:Body>
</soapenv:Envelope>

<soap:Envelope>
   <soap:Header/>
   <soap:Body>
      <ns2:RowQueryResponse>
         <Row>
            <Value name="AccountManager.FirstName || ' ' || AccountManager.LastName">
               <String>Steven King</String>
            </Value>
            <Value name="InputAddress.Country">
               <String>FRANCE</String>
            </Value>
            <Value name="SUM(TotalRevenue)">
               <Decimal>62904</Decimal>
            </Value>
         </Row>
         <Row>
            <Value name="AccountManager.FirstName || ' ' || AccountManager.LastName">
               <String>Shanta Vollman</String>
            </Value>
            <Value name="InputAddress.Country">
               <String>USA</String>
            </Value>
            <Value name="SUM(TotalRevenue)">
               <Decimal>52978</Decimal>
            </Value>
         </Row>
         ...
         ...
      </ns2:RowQueryResponse>
   </soap:Body>
</soap:Envelope>

<soapenv:Envelope>
   <soapenv:Header/>
   <soapenv:Body>
      <gen:CheckoutRows>
         <!-- Task UUID -->
         <DETaskUUID>c2c3e188-650e-4608-b501-d7df832f9ca0</DETaskUUID>
         <CheckoutQuery>
            <QuerySource>
               <gen:EntityName>Customer</gen:EntityName>
               <ViewType>MD</ViewType>
            </QuerySource>
            <WhereCondition>CustomerName like 'S%'</WhereCondition>
         </CheckoutQuery>
         <Target>
            <BusinessObject>CustomerBO</BusinessObject>
         </Target>
      </gen:CheckoutRows>
   </soapenv:Body>
</soapenv:Envelope>

<soapenv:Envelope>
   <soapenv:Header/>
   <soapenv:Body>
      <gen:PersistRow>
         <!-- Task UUID -->
         <DETaskUUID>c2c3e188-650e-4608-b501-d7df832f9ca0</DETaskUUID>
         <!-- Datarow to insert -->
         <DataRow>
            <!-- Target entity -->
            <gen:EntityName>Customer</gen:EntityName>
            <!-- Identifies an insert (new record) -->
            <New>true</New>
            <!-- Content of the data row -->
            <DataRow>
               <Value name="SourceID">
                  <String>654564</String>
               </Value>
               <Value name="CustomerName">
                  <String>SAMBALELE</String>
               </Value>
               <Value name="TotalRevenue">
                  <Integer>200020</Integer>
               </Value>
            </DataRow>
         </DataRow>
      </gen:PersistRow>
   </soapenv:Body>
</soapenv:Envelope>