Kapalı

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

Beceriler: .NET, Microsoft SQL Server, PHP, RESTful API, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 35 değerlendirme ) faridabad, India

Proje NO: #18494167

Bu iş için 8 freelancer ortalamada $166 teklif veriyor

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 in 3 gün içinde
(29 Değerlendirme)
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 Daha Fazla

$266 AUD in 10 gün içinde
(16 Değerlendirme)
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 Daha Fazla

$277 AUD in 3 gün içinde
(1 Yorum)
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 Daha Fazla

$155 AUD in 13 gün içinde
(7 Değerlendirme)
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 Daha Fazla

$155 AUD in 13 gün içinde
(3 Değerlendirme)
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 Daha Fazla

$100 AUD in 5 gün içinde
(2 Değerlendirme)
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 in 8 gün içinde
(0 Değerlendirme)
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 in 2 gün içinde
(0 Değerlendirme)
0.0