Basic Databse with SOAP API

Proposed automated reporting LM

Please make sure to review our requirements and respond based on these requirements or other potential solutions you believe suitable.


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.


[url removed, login to view] near real time reports for LM on the Direct Track Platform

[url removed, login to view] the process of reporting

[url removed, login to view] human intervention

[url removed, login to view] to map Client fields to the required DT reporting fields

[url removed, login to view] a platform that can be used for all future clients of LM so as to avoid integration issues and overcome security concerns of merchants

[url removed, login to view] to write and extract more detailed reports than accessible from DT system


[url removed, login to view] emails LM reports in a excel format on predefined intervals, such as 4 hours

[url removed, login to view] arrives into a predefined mailbox at LM

[url removed, login to view] 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

[url removed, login to view] LM_SQL has the required SOAP commands for DT

[url removed, login to view] has access to call the data from LM_SQL

Results and Benefits

[url removed, login to view] 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

[url removed, login to view] integration issues with clients

[url removed, login to view] real time reporting

[url removed, login to view] prep the data exactly to DT requirements so when imported the fields match up

[url removed, login to view] entire process is automated which means no human intervention is required

[url removed, login to view] are able to write our own reports and automate these for ourselves.

Other criteria:

[url removed, login to view] entire solution must be documented

[url removed, login to view] require all source code

[url removed, login to view] will require some level of training

[url removed, login to view] to maintain

[url removed, login to view] to a GUI reports builder

For more detailed information, a diagram and sample of the SOAP commands for DT please review the attached file.

Kemahiran: .NET, Excel, Destop Windows, XML

Lihat lagi: directtrack soap, direct track soap, security benefit, reporting software review, real time data solutions, prep for prep, objective c programs, market net, internal mailbox, easy affiliates, easy affiliate programs, easy affiliate program, direct performance, design imports, data mining process, custom design benefits, correct email address, benefits of mysql, api design, access interface solutions, 1 hour email address, affiliate soap api, directtrack soap api usage examples, direct track soap api, directtrack api code samples

Tentang Majikan:
( 0 ulasan ) Johannesburg, South Africa

ID Projek: #291430