The vendor keeps lots of good data regarding these activities in their own DB. We keep a smaller integration DB on our side, allowing synching of account generation and enrollments - but the rest of the data about the process is kept in a different DB that is owned by the vendor - behind their firewall.
Last week my customer said to me, "Mike and I are going for SQL training". Then she said "Beny at Genius said you need to learn SQL so you can create your own reports." This is funny, because part of the reason my customer switched to this vendor was to have these reports created for them.
To my point again. We need to install MS studio express (free version) and connect it to the MS SQL DB that is hosting our information. Beny, our contact at Genius told Mike my customer here, that he needed ip addresses. Mike could not remember why, so I guessed correctly that he was looking for machine ips that would need to pass through their firewall to connect to the DB. I was correct.
I assumed we would use the IPv4 addess. I obtained mine on my Windows 8 OS by clicking the start button and then run... I type in cmd and press enter - bringing up the command prompt and type ipconfig - this produces the IPv4 adress
The interesting thing I found out was that our ip addresses, even though I have not seen them change before are not static, but dynamic. Which means they could change. Providing the IPv4 address would not suffice. It may work for a few weeks or months, but eventually, it would change and the connection that we are to make using that address would fail. When we try to connect to the Genius DB, the ip would be different causing the connection to fail. No go.
After consulting with our network guys about this, they reported that we have worked around this in other similar situations by providing a static ip range. Ok. I provided my Genius contact that range that looked like this xxx.xx.xx.x to xxx.xx.xxx.xxx.
Lets hope this works.
No comments:
Post a Comment