We help IT Professionals succeed at work.
Get Started

Connect to MAS200 via ODBC and transfer data to hosted server

Last Modified: 2013-12-11

I wrote a hosted web application (ASP.NET) for a customer who now would like to use/display some information from their MAS200 on the web application.

I have done a bit of research and found that I can access the MAS200 data read-only via an ODBC driver on the MAS200 server. I am still working with their IT person to get remote access to the MAS200 server - but I want to be ready to roll once granted access.

I think these are the steps I need to take. Can you please let me know if I am on the right track, am I missing something, is there a better way, etc..?

1) Identify which tables and specific data my users want to extract from MAS200 (is there a data dictionary of some sort to map the user data to the tables/fields I will need to extract?)
2) I am thinking I will need SQL Express or some sort of simple DB tool installed on the MAS200 server to query and temporarily hold the extracted data.
3) Create ODBC Data Connection to the MAS200.
4) Query and store data on MAS200 server.
5) Determine best way to transfer data from internal MAS200 server to hosted server - any suggestions? I was thinking a scheduled console program that ran the query and ftp a file...but maybe SQL has some tools that can do all this directly from db to db?

Any help or suggestions on any part of this process would be helpful. This is the first time I have attempted to access MAS200 as well as transfer data between an internal server to a hosted server.

Thank you in advance...
Watch Question
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE