SSIS connector for JDE

ncaldwell

New member
Does your product have SSIS component to upload data to JDE? We use SSIS extensively for workflow and mapping and don't want to rewrite everything in C#.
 
Last edited:

Cool Calico

Administrator
Staff member
We have an SSIS script component that lets you submit XML through our web service.
 
Last edited:

ncaldwell

New member
Generating XML is not an issue for us. Our workflow may have to make multiple web service calls (create a supplier if it does not exist and then an A/P invoice). When we looked in to BSSV, our tech consultant told us that we have to generate WSDLs for each call.

How is this handled in your component? Can you give us a sample of how this XML will look like?
 
Last edited:

Cool Calico

Administrator
Staff member
LynX has one WSDL for all web service calls. The XML determines the business process (A/P, A/R etc.) that is executed. This architecture allows you to reuse the same component for different purposes by just changing the XML.

Here a sample XML to create an address book record:

XML:
<?xml version="1.0" encoding="unicode" ?>
<aelliusconnector>   
  <processsettings
        aelliusrequestid="ERP.EOne.AddressBook"
        />
      <document>
        <input>
      <FinalMode>true</FinalMode>
      <TransactionMode>Add</TransactionMode>
      <AddressBook>
        <CreateSupplier>true</CreateSupplier>
        <AddressMaster>
          <AddressNumber>0</AddressNumber>
          <AlphaName>Testing1</AlphaName>
          <LongAddressNumber></LongAddressNumber>
          <SecondaryAlphaName></SecondaryAlphaName>
          <TaxId></TaxId>
          <SearchType>V</SearchType>
      </AddressBook>
        </input>
    </document>
</aelliusconnector>
 
Last edited:
Top