In Progress

SQL Analysis / SQL Server Automation

Project Description: We need an expert in SQL Server 2005 and Analysis Services to help us solve the problems described below. We do not know the technology required to solve these issues ( assuming they are solvable), so it is anticipated that the coder will give us the proper technology choice based on the requirements. We must use all native SQL Server / .NET platform capabalities. No 3rd party tools unless approved by us before-hand. 1. We need a SQL Job that updates existing cubes in a SQL Analysis Services instance at prescribed intervals. We would prefer if the SQL job were configurable such that we can refresh different cubes at different intervals. For instance, refresh (process) cube 1 every 5 minutes, and refresh (process) cube 2 every 15 minutes. 2. We would like a C# class that allows us to create new cube definitions by calling the SQL API. We anticipate that we would give a table name, dimensions and measures as parameters to the method calls. Deliverables: For requirement 1, a working SQL job and all instructions to make it work in our environment. It is anticipated that the coder will need to be online to support getting this working. For requirement 2, a working C# console application written for .NET 3.5 in Visual Studio 2008. Anticipate minor changes as we work thru the requirements in more detail. Only experts in this technology should bid. We need this work done quickly with little supervision. We will provide sample DBs to work from.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

SQL Server 2005 / Analysis Services .NET 3.5 VS 2008 C#

Skills: C# Programming, MySQL, SQL

See more: web programming technology, web programming online job, web analysis services, sql server web, sql experts for hire, solve programming problems online, solve c programming problems online, programming sql server online, programming sql, programming in sql, programming experts, programming definitions, problems to solve with programming, online sites for programming help, online programming services, online programming problems, online programming class, online legal support, job that hire at 15, hire a sql coder, getting a job in programming, expert in sql programming, desktop support job description, dbs programming, c sharp programming online

About the Employer:
( 25 reviews ) India

Project ID: #3951854

Awarded to:


See private message.

$255 USD in 3 days
(125 Reviews)

5 freelancers are bidding on average $205 for this job


See private message.

$131.75 USD in 3 days
(12 Reviews)

See private message.

$255 USD in 3 days
(2 Reviews)

See private message.

$297.5 USD in 3 days
(7 Reviews)

See private message.

$85 USD in 3 days
(0 Reviews)