So I have been rockin mapforce like its 2008. I finally got around to getting updated and on 2014. My favorite additions so far are the dynamic file paths. I used to have to edit the generated code but now I think I can do it all from within the mapforce studio! I used a simple wildcard path for the input path, and then used a get-folder + concat + ‘xml\’ + remove-folder and a replace-fileext and plugged it into the outbound file and wala there ya go!
I have been dealing with this same issue > SQL Svr 2008, and using temp tables. Works fine over ODBC, but nothing is returned over OLEDB. I was able to get around this by adding set nocount on to the proc, e.g.:
SET NOCOUNT ON
or you can use ODBC
Now we need some AS2 action. So I went to Parties (who doesn’t like parties??)
Since I already have an AS2 server I figured I would use it for testing against. So I grabbed its address and public cert, next I ran the AS2 Setup Quick Start Wizard that is on the welcome page.
This configured my local AS2 server I named it NFFCTEST and set the AS2 URL to reflect the ip of the system, I’m assuming I will set it to an external IP when I go into production.
It auto generated a cert for AS2 which was nice of it.
So now I needed to add an External Trading Partner
I gave it a name, typed in the AS2 Identifier and the AS2 URL. Originally I forgot to include the port (which made it not work of course)
I set a Customize Subject Header, and use EDI Message (I don’t know if this is correct, but it matches my other server settings)
I set the S/MIME Signed/Encrypted for the format type. For the Encryption Algo I set to DES3 168 (it defaults to AES 128) and signing algo to SHA1 160
I added the public cert that came from my other AS2 box.
I enabled Retry, 3 times, every 300 seconds.
I enabled Resend, 3 times, 1 every hour.
– Ok so that’s all fine and good. Now I need to get a file into this thing.
I went to Server, services. And then clicked add. Then added Directory Monitor Inbound. I created a folder and used an Include Mask of *.edi
I just specified the Originator / Recipient because I thought that was easiest!
I set the scan frequency for every 10 seconds, from 00:00 to 12:59 PM
Ok, now let’s drop a file in and see what happens.
If everything works you should see the file, and you should be able to click on it and get to this message tracking screen
No matter what you do, this setting will not stick. To get it to stick
Windows Registry Editor Version 5.00
So it’s impossible to compare EDI platforms since no one wants to give me a trial copy to test. When we were evaluating SANS the Equallogic folks dropped one off and said here yeah go, take it for a spin. Those were people that were proud of their software. We bought an Equallogic. Why are they so ashamed? Anyways, we ended up going with Bizlink for the moment. So far the install process was straightforward, it took less than an hour. I’m working on configuring some trading partners. We will see how it ends up.
Always wanting to monitor more and more the things, I finally decided to get some sort of flow monitoring thingy going. The SolarWinds Real-time NetFlow Analyzer looked cool, and was pretty easy to get up and running. For our Juniper I followed these instructions
Basically I used putty to SSH into the switch.
set sflow collector 10.204.32.46 udp-port 5600
set sflow interfaces ge-0/0/0
set sflow polling-interval 20
set sflow sample-rate egress 1000