My Sharepoint challenge
We have been usng MS Access to to marry together an imported list of serial numbers (in excel) and bumping it against a SQL Server database in a query to find any matching transactions and then exporting those query results to a new excel.
So the existing steps are:
Import list of serial numbes into MS Access into a new table
Modify existing query in MS Access to bump this table against some ODBC connected tables in a SQL Server db to create an output query of matching data.
Exporting that query to excel.
What I have been tasked to do is remove MS Access from the mix and add a utility to out Sharepoint 2013 Foundation based intranet site. Conceptually, I know it can be done with a custom app... I need to learn how to do it. I made the MS Access db that does it now so I know how it needs to work, I just need some help on how to migrate it to a Sharepoint App.
I am not naive, I know there is a 'leap' in technology here... but I need to start somehwere. Can someone help me get started, give me some pointers on what to learn and become familiar with so I can build something like this? Thanks!
So the existing steps are:
Import list of serial numbes into MS Access into a new table
Modify existing query in MS Access to bump this table against some ODBC connected tables in a SQL Server db to create an output query of matching data.
Exporting that query to excel.
What I have been tasked to do is remove MS Access from the mix and add a utility to out Sharepoint 2013 Foundation based intranet site. Conceptually, I know it can be done with a custom app... I need to learn how to do it. I made the MS Access db that does it now so I know how it needs to work, I just need some help on how to migrate it to a Sharepoint App.
I am not naive, I know there is a 'leap' in technology here... but I need to start somehwere. Can someone help me get started, give me some pointers on what to learn and become familiar with so I can build something like this? Thanks!
ASKER
SQL 2012 (11.0.5343.0)
Standard Edition
Standard Edition
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It is more of an 'as needed' operation, not something that needs to be done on a schedule. We receive the excel file from the customer of numbers they would like checked...we run the query, export the matches to excel and then email it back to the customer.
I know nothing about SSIS, can you point me in the right directon on how to get started with it?
I know nothing about SSIS, can you point me in the right directon on how to get started with it?
hm, imho SharePoint does not sound well for this type of requirments.
What version and edition of SQL Server do you have?
Is this a repeatedly task (e.g. once per day) or on-demand?
Thanks and KR
Rainer