Đã Đóng

Build Excel integration to retrieve SQL Server data over the web

I need to have a tool developed that will give me the possibility to get any possible data from a MS SQL database (Event Management Software (EMS)) into MS Excel without having to open up the server security. It should be an actual tool that I can sell to my clients, although in most cases I’ll be the person developing their pivot tables and charts.

The EMS also has its own Excel integration that works through their API, but it has it’s limitations on what data you can download and also it’s not very user friendly. For example it forgets which table you have loaded on which sheet so you have to manually select it each time and also it doesn’t have an auto refresh option.

My idea is to have a separate API through which you can call any possible database view or stored procedure. This way I am completely free in which information I pull from the database for which client.

So I think the job consists of two parts:

- Separate API to call view/stored procedure

- Excel toolbar through which you can select the views/stored procedures you want to load in Excel

But if you have a better solution to fulfil my requirement, please let me know.

Side note: I am the distributor of the EMS in my local region and I host the software, but I don’t own the EMS nor do I have access to any source code. The only thing I have access to is the API and the database. When it comes to reporting in Excel for my clients I want to be very flexible and don’t want to depend on the EMS company.

Please respond with:

- Your suggested solution

- The expected time to completion

- Your experience and why you are capable of performing this job

If you have any questions, don’t hesitate to ask them.

Thanks!

Ronald

Kĩ năng: .NET, Microsoft SQL Server, PHP, RESTful API, SQL

Xem nhiều hơn: sql server data cleanup phone, sql server data import quickbook, sql server 2005 web scrape, excel connect to sql server vba, connect excel to sql server using odbc, how to import data from excel to sql server, import data from excel to sql server using query, how to connect excel to sql server 2012, excel connect to sql server query, create sql database from excel, excel data connection sql query with parameters, save image sql server data sql 2005, sql server 2005 web scraper, excel pivot table sql server, sql server data conversion, sql server 2005 web application, php mysql server data web page, excel macro update sql server, sql server 2005 web data entry, build bcp import script sql server 2000

Về Bên Thuê:
( 35 nhận xét ) faridabad, India

ID dự án: #18494167

8 freelancer đang chào giá trung bình $166 cho công việc này

logicalsoft

Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss

$155 AUD trong 3 ngày
(29 Nhận xét)
5.8
abhinovpankaj

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Thêm

$266 AUD trong 10 ngày
(16 Nhận xét)
4.2
cyash61

Hello, I am an analytics consultant with more than 6 years of expertise working with 2 major consulting firms. With over 50 projects delivered using SAS and SQL in the past, I have the depth of experience on the Thêm

$277 AUD trong 3 ngày
(1 Nhận xét)
3.0
vijay4upwork

Hi There, I've checked your requirements and I am much interested to assist you on the development of your website with fulfilling all of the required functioning very accurately and elegantly. Thanks for opportunity Thêm

$155 AUD trong 13 ngày
(7 Nhận xét)
2.0
HoneyApplePie

Hi There I've checked your requirements and I am much interested to assist you on the development of your website with fulfilling all of the required functioning very accurately and elegantly. I'll provide you with t Thêm

$155 AUD trong 13 ngày
(3 Nhận xét)
2.0
sticker94

suggested solution: There are a few routes that we can go. 1. We can use ADODB connection and assign it to a macro that pulls your required data whenever you need. We can create a form to select SQL queries and stor Thêm

$100 AUD trong 5 ngày
(2 Nhận xét)
0.6
samwag

If you agree, i work for you as you want Relevant Skills and Experience i am working for hawassa,Ethiopia university Virtual Queue Managemnet Sytem

$166 AUD trong 8 ngày
(0 Nhận xét)
0.0
shivamcogni

hey ronald I am mssql developer , i can provide you the solution with help of etl tool . and provide you the sheet as per your requirement . Thanks Shivam mathur Mobile no 8130210244

$55 AUD trong 2 ngày
(0 Nhận xét)
0.0