Provide mechanism to upload data sourced from a specified SQL query string in SAP Business One to a specified server as a csv file format via SFTP using WinSCP. The interface should allow the user to define multiple export instances, each containing the pre-defined SQL query, the frequency (in minutes) to routinely perform the CSV export, the server to export the data to & the credentials to be used.
Hello, I'm a SAP Bussine One Developer, i have a large experience with. and I can easily create your project, in fact we together will solve this very fast. I've already have more than 30 Addons created to SAP B1. i know all about that database.
Hello.
I can create and an application, which will upload data.
Before being awarded for the project I would like to discuss details how to obtain source data.
Dear Sir,
Greetings of the day!.....
I have 5+ years of experience insap b1 as techno-functional person.
As per your requirements I can give you your add on in 10 days for more details like which document and fileds you want to upload in sap b1 kindly arrenge one e-meeting so i can give you sample in your formate.
Kindly give chance to work with you on your project.
Definitely you will get best work from me.
Thanks & Regards,
Viral Prajapati
Hi,
This is Vipin. I have 6+ years of experience in customized software development and has expertise in Python, Java, Angular and Ionic framework. I have gone through your project details and would like to work on your project and looking for long term work. Kindly connect to discuss in detail and check my recent work in portfolio section as well.
Hope to talk more soon
Thanks
as per our requirement, The source should be in the form of SQL queries and and we need to send it to a SFTP receiver. where we can access the SFTP receiver using WINSCP tool to read th files. this can be done only through a middlewear in SAP which is PI. so we have to develop an JDBC to SFTP interface.
Also you mentioned that multiple instances, can you please eloberate your requirement? Also about the frequency that we can set in the communication channel in PI. Can we have a quick discussion on this and develop the same in short span of time.
feel free to ask me if you need anything, kindly ignore if I'm not suitable for this requirement... have a great day!
I have successfully delivered a project of SAP Business One integration with SFTP using WinSCP. The project was to upload query details in CSV, XML format to SFTP and download files from SFTP to create SAP B1 Documents.
Please allow me to demonstrate my project.
I assure you, I can develop this functionality within the timeline.
Regards,
Zuber Kazi
SAP Business One Technical Consultant (8 yrs Exp)
We already have custom solution which converts Sql server query/ Stored Procedure to csv and upload to SFTP/ FTP /Dropbox ,it has customization of job schedules also we can extend this solution if needed to work with hana , it also has history tracking of jobs and also it can start / stop jobs, we can schedule a demo to discuss further
My skill set is a perfect match for the project requirements. In particular, my SAP skills and managerial experience make me an ideal company for the project.