SSIS connector for JDE

[ncaldwell]

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#.

 

[Cool Calico]

We have an SSIS script component that lets you submit XML through our web service.

 

[ncaldwell]

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?

 

[Cool Calico]

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 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>

 

[ncaldwell]

Thanks. This helps.