Đã Đó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, connect excel to azure sql database, using data connections in excel, excel data connections tutorial, link excel to sql server, connect excel to odbc data source, how to connect excel to sql server 2012, excel connect to sql server query, 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: #18494209

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

umashankarpandey

Infinity Webinfo Private Limited Portfolio [login to view URL] Infinity Webinfo is my company name we are managing bellow websites Project #1 [login to view URL] Thêm

$155 AUD trong 3 ngày
(24 Nhận xét)
6.2
maverickindia

Dear Client, Before Awarding to Anyone give me a chance & kindly discuss your project in detail with me. I have read your requirement carefully and got total understanding of the project .No fake commitment,100% qual Thêm

$200 AUD trong 3 ngày
(39 Nhận xét)
5.0
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
mohamedmos97

Hi My name is Mohamed Mostafa I have a big team in almost anything you want, We deliver a good quality work within short time, We can offer - Web apps ( html, css, js, jquery, react.js, AngularJS, sass Thêm

$150 AUD trong 3 ngày
(2 Nhận xét)
2.7
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 st Thêm

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

Hi i can do this in excel, i can do a Menu sheeet when you enter the IP address of the server that MSQL Server is installed,and enter the Login and Psw. Then with a button inside this sheet,the program it will list to Thêm

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

Hello Ronald FYI i was recently in charge to produce security KPI for a big company. If used Ms SQL table and REstfull API to create dataset and dashboard with Excel and Power BI. It will be easier to unterstand y Thêm

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