Extract data from some Microsoft Dynamics tables and then Insert a Sales Order - open to bidding

$250-750 USD

Closed

Posted

about 9 years ago

$250-750 USD

Paid on delivery

Hi, I have a mobile application that interacts with our SQL Server tables. I require to populate these tables (ie. Customers, Products, Price Lists, Inventory, Customer Invoices, etc) from a Microsoft Dynamics Database. So I need SQL Select´s to do this. I would also need to insert a Sales Order from our tables to Microsoft Dynamics. For example, Customer table structure on our database is the following: Field Name Data Type CustomerCode Character (20), PK CustomerName Character (60) CustomerInternalCode Character (20) CustomerCommercialName Character (60) CustomerTaxpayerId Character (20) CustomerTaxpayerIdType Character (20) CustomerStatus Character (1) CustomerOpenOn DateTime CustomerCreditStatus Character (1) CustomerCreditLimit Decimal (17,4) CustomerCreditUsed Decima (17,4) CustomerSalesPersonCode Character (20) TerritoryCode Character (20) CustomerCategoryCode Character (20) Currently our Data Dictionary is in spanish but we will provide a translated version. The tables to be extracted from Microsoft Dynamics are: • CustomerCategory • Manufacturer • PaymentTerm • PaymentType • PresentationType • ProductBrand • ProductGroup • ProductSubgroup • Store • Territory • Customer • CustomerAddress • CustomerPhone • CustomerContact • CustomerBalance • CustomerTransaction • CustomerPaymentType • CustomerPaymentTerm • CustomerInvoice • CustomerInvoiceDetail • PriceList • PriceListItem • CustomerPriceList • PriceListItemRange • Product • ProductInventory • ProductPaymentType • ProductPaymentTerm • ProductPresentation • SalesPersonStatistic • SalesPersonTerritory Could you provide a SQL Select for each of these tables ?

SQL

Project ID: 7215050

About the project

22 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

22 freelancers are bidding on average $550 USD for this job

@logicpowered

We are very interested in this project. We saw your project requirements. We believe that we will definitely meet your specification with our professional service. To top it off, we are verified & skilled tested. We will complete your project within the allocated time with the best of our efforts. We look forward to establishing a long-term relationship with you. Good or bad, we'd love to hear from you :) Let's build success…

$833 USD in 15 days

4.7

(9 reviews)

6.9

@anshulikabansal

Hello Sir, Sure sir. I can provide SELECT SQLs' for the mentioned tables Please start a PM on this. Thanks & Regards, Anshulika Bansal

$300 USD in 3 days

5.0

(33 reviews)

5.5

@sikandermandal

Dear Sir, This is Sikander. I am having 12+ years of experience in software development and I am ready to start this job. Please discuss with detail project specification, so, I can give you exact time frame and budget for this project. As, I do not believe in false commitment. I will provide you best services in development. Please have a look at my Profile, Ratings and feedback. I am working in Microsoft technologies and you can find the details below. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander

$750 USD in 15 days

4.7

(11 reviews)

5.9

@janmsidh

Hello Sir/Madam I have solid experience as Oracle, SQL Server and Sybase, PostgreSql DBA. I am SQL server certified DBA. I worked as DBA in USA for 13 years. I came back recently to start my own work. I have a number excellent reference as DBA. Please take a look at my resume and you will find that I am the best fit for this job. I have just completed a project on database and the client was from Australia. Please see the review. Plan of action: 1. select/export all the data from the table with a field terminator and save as flat file/text file 2. Import those flat file in the respective tables in a staging area. 3. Populate final table from the staging area with validation if required 4. Test the data like number of rows trasferred/mapping of the field and so on. Appreciate your kind attention in this regard, NOTE: I am SQL certified on freelancer.com Janmsidh Team

$250 USD in 3 days

4.8

(7 reviews)

3.2

@jasuarezh

I'm a develop in a international company. I'm from Spain, I don't have problems with the language. I have 9 years old with experience in Dynamics AX, in differents version. I do the same job in one project, with a PDA program to synchonize data to AX.

$777 USD in 10 days

5.0

(1 review)

3.0

@abagunjal

I am experienced sql developer. I will deliver this as required.

$444 USD in 5 days

4.0

(1 review)

2.9

@RaghavendravDesh

I have worked on SQL server, SSIS and stored procedures in a software firm. I will deliver the product with desired speed and accuracy.

$555 USD in 10 days

5.0

(2 reviews)

2.4

@JanviIndia

A proposal has not yet been provided

$833 USD in 30 days

0.0

(0 reviews)

0.0

@bizank

Dear, Hope you doing well. We are personalized world class Web solutions for your business. I have gone through your requirement Extract data from some Microsoft Dynamics tables and then Insert a Sales Order and as per my previous work experience i am ready to start work immediately on your project. Agile software development process according to corporate standards. ISTQB certified in quality assurance. Advantages for you: • ease and comfort of communication • flexibility in managing your development team • new ideas generation regarding improvement of your Product • the reliable partner Use our expertise today!

$444 USD in 10 days

0.0

(0 reviews)

0.0

@cscinstructor

I have read and fully understood your requirements. Please open chat to discuss further….. =================+++++++++++++++++++++++++======================

$277 USD in 15 days

0.0

(0 reviews)

0.0

@sumesh0rcl

A proposal has not yet been provided

$555 USD in 5 days

0.0

(0 reviews)

0.0

@itaiseri

Hi, I am very skilled in SQL, especially SQL Sever which I plan to use for this project. I've wrote a lot of complex queries in previews project (not in Freelancer.com). Further more, I have experience in Business intelligence field. I have a lot of free time to invest in this project, and this project looks interusting:) I'll be very glad to hear from you. regards, Itai

$250 USD in 7 days

0.0

(0 reviews)

0.0

@sandeepdba2012

A proposal has not yet been provided

$555 USD in 10 days

0.0

(0 reviews)

0.0

@aljordan23

I'm IT professional with 12 years experience in implementing ERP projects. ERP: Dynamics, Infor, 1C. DB: SQL Server, Oracle. More than 10 projects performed as PM. Deep knowledges of Microsoft, Infor products. English: Upper Intermediate

$833 USD in 10 days

0.0

(0 reviews)

0.0

@mcoders

Dear sir, I am hand on experience of 4 years on AX and good functional knowledge. Imported Master data for inventory , Customer master , Vendor master, Product master and many more. I am ready to give 100% support and assistance on this. Can work on workflow, Data migration, Upgradation, Integration , SSRS reports or any kind of AX customization, X++ coding and Morphx development. Start further communication. Regards Rahul gupta

$250 USD in 0 day

0.0

(0 reviews)

0.0

@imukherjee03

You are looking to retrieve some data from dynamics db in a effective manner. I will try to provide a solution that will take less time to execute the query and have a good explain plan. I can look into the tables and see that proper indexing is done or not. I have a good working experience in sql and will achieve the above items. Can you provide me the database table details. Or is there any provision to log in to dynamics db remotely. You can share the details in my freelancer a/c.

$555 USD in 2 days

0.0

(0 reviews)

0.0

@sreeramdas

I am Amarnath, having good experience on database designing,testing, pl/sql and SQL tuning. I had developed databases for various domains like e-commerce and finance. I have strong skills in designing OLTPs and OLAPs also.

$250 USD in 1 day

0.0

(0 reviews)

0.0

@elkhal

A proposal has not yet been provided

$250 USD in 10 days

0.0

(0 reviews)

0.0

@saurabh1412

I have a rich experience in dealing with the data and looking at your requirement I am finding myself comfortable doing this.

$833 USD in 10 days

0.0

(0 reviews)

0.0

@zils

Around four years of experience in developing complex and advanced queries, also worked on enterprise level database software's that are being used in over five countries.

$555 USD in 10 days