Find Jobs
Hire Freelancers

Basic Databse with SOAP API

$250-750 USD

Closed
Posted over 15 years ago

$250-750 USD

Paid on delivery
Proposed automated reporting LM Please make sure to review our requirements and respond based on these requirements or other potential solutions you believe suitable. Overview: LM is a third party affiliate program. We have agreements with other affiliate programs and are sourcing traffic from affiliates which will be tracked through our hosted affiliate tracking software called Direct Track (DT). In order for us to track the performance of our affiliates on our campaigns with our Merchants we receive data from the merchant in excel format. The files we receive need to be imported via a manual process into DT, this process is labour intensive and requires manual human intervention. Direct Track does support SOAP commands however the merchants will not let DT directly interface into their data. We therefore have envisaged an intermediary solution whereby we will automatically import the received excel files into our own separate database (LM_SQL) which is separate to DT and the merchants. The excel data will be mailed to us on a 4 hour interval. The idea is then to implement SOAP between LM_SQL Db and DT. The benefit of this is that we have all our data consolidated into our own Db which gives us the ability to design our own custom reports for internal purposes, reconciliation, data mining etc as well as, and most importantly it automates the process of importing the data into DT which our affiliates will then be able to view through the DT frontend. Objective: [login to view URL] near real time reports for LM on the Direct Track Platform [login to view URL] the process of reporting [login to view URL] human intervention [login to view URL] to map Client fields to the required DT reporting fields [login to view URL] a platform that can be used for all future clients of LM so as to avoid integration issues and overcome security concerns of merchants [login to view URL] to write and extract more detailed reports than accessible from DT system Process: [login to view URL] emails LM reports in a excel format on predefined intervals, such as 4 hours [login to view URL] arrives into a predefined mailbox at LM [login to view URL] Outlook “Add-On” strips the excel attachment and stores it in a Windows directory on the SQL server. LM has a hosted Windows 2003 server onto which we can install, Outlook and SQL or MySQL 4.A script on LM_ SQL automatically opens the excel file and imports the data into the correct fields [login to view URL] LM_SQL has the required SOAP commands for DT [login to view URL] has access to call the data from LM_SQL Results and Benefits [login to view URL] solution is clean and allows us to sign up any Merchants without them having to allow us access to their databases, all they have to do is email the reports in excel format to the reports email address. This means much faster setup and go to market [login to view URL] integration issues with clients [login to view URL] real time reporting [login to view URL] prep the data exactly to DT requirements so when imported the fields match up [login to view URL] entire process is automated which means no human intervention is required [login to view URL] are able to write our own reports and automate these for ourselves. Other criteria: [login to view URL] entire solution must be documented [login to view URL] require all source code [login to view URL] will require some level of training [login to view URL] to maintain [login to view URL] to a GUI reports builder For more detailed information, a diagram and sample of the SOAP commands for DT please review the attached file.
Project ID: 291430

About the project

7 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

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

About the client

Flag of SOUTH AFRICA
Johannesburg, South Africa
0.0
0
Member since Jul 24, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.