입찰 받는 중

Simple eCommerce integration in Talend (we also welcome other ETL/ESB tools): Odoo ERP + Digitland Enterprise ERP (Odoo eCommerce - new orders, new customers; Digitland - new products, stock availability, invoices...)

We want to launch the Odoo v13 eCommerce module and connect it to our existing ERP system which handles the stock, accounting, sales, statements, hr etc.

Odoo eCommerce will allow our business customers to place orders using their individual price lists. Data which need to be exchanged between the systems are mainly: new customers (Odoo -> Digitland), new orders (Odoo -> Digitland), new product (Digitland -> Odoo), stock availability (Digitland -> Odoo), invoices&wh/outs (Digitland -> Odoo).

We do not plan nor want to create the system-wide integration between those two. We want to transfer only the informations which are necessary and keep the things light and easy as possible.

What technology may we use for data exchange?

A. Digitland Enterprise is built upon Oracle 11g database.

It does not offer us any proper API interface, but it does have a module called DE-WWW.

This module is a set of tables and views which are separated from the tables/views the system uses normally. The content of DE-WWW is being checked periodically and if any changes are detected, the new records are being transferred to the main database. We can fetch all the needed informations from the system database, which we also already tested using Talend on Products, Customers, stock availability.

B. For Odoo we consider using CData JDBC Odoo driver. It uses Odoo External API (XML-RPC) and enables us to fetch / pull the data from / to Odoo like if it was a regular database using SQL queries. Additionally it allows us to RPC Odoo using another mechanism using nested JSON, so we gain all the possibilities which are available when using regular XML-RPC API/

REST API. We performed some tests of this driver using Talend with success. Otherwise we may use XML-RPC or REST-API.

When should be the data exchanged?

The amount of data to be exchanged will not exceed 100MBs/day before the end of 2022 (under 200 new orders / day + invoices + stock quantity updates).

New orders and customers from Odoo will be pushed to Digitland using object state change detection and the webhooks. We want so that Odoo used Talend endpoints to pass the order/customer data and to trigger the exchange process this way. Looking from the other side, DE-WWW may prepare the needed data for us using right tables and views. We can either use a Oracle Database Change Notification mechanism for the exchange processes to be triggered automatically (like from Odoo) or we can periodically check the number of rows to change and then fire the Talend job. I must say that the first solution with the Database Change Notification is being analyzed at the moment so that’s why we do have a backup option. In both systems we will store the external IDs of the objects (Orders, Customers, Products) and additionally we would also want to have some „object identifier" database in the middle (which could Talend use; contains: Odoo Object IDs, Digitland Object IDs) and the log which would contain all the exchanged information headers with the timestamps, flow direction. They both could be done using Redis or some other key=>value database.

Below I attach 2 simple diagrams which show the general idea for the project. One of them does concentrate on the types of data to be exchanged, and the other one shows also the intermediary part of the system - ETL/ESB tool.

We have the Odoo and Digitland partners ready for cooperation, they know the basic concept behind the project.

Please let us know:

- what do you think about the project, weak design elements, what should be done differently?

- what is your experience with Talend (and other ETL/ESB tools)?

- what is the right and most effective tool for the job in your opinion (Talend / NiFi / MuleSoft ... xxx) which could also be used in the future to build more complex integration?

- what would you be responsible for in the project?

- how long will it take you to finish the integration?

- when can you start the project and what informations do you need to start?

기술: Data Integration, Relational Databases, 자바

확대 보기: simple appointment availability php, checking stock products, simple order form multiple products joomla, sugar crm let customers past invoices, oscommerce stock products attributes, simple design image stock, magento change availability stock, oscommerce customers orders problem, oscommerce customers orders total showing, simple project php stock control, sql query selecting customers orders latest date, virtuemart set stock products, virtuemart orders stock products, magento hide stock products, magento remove availability stock, oscommerce products previos orders, oscommerce show stock products box, simple mysql stock products, hide stock products prestashop, scenario include web shop customers products orders invoices

고용주 소개:
( 0건의 리뷰 ) Krakow, Poland

프로젝트 ID: #21692925

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 22명, 평균 입찰가: $2330

SecureForYou

Hi,sir, Thanks for taking your valuable time for reviewing my proposal.I'm sure that I can be a excellent candidate for your project. Please contact me, so that we can discuss more over chat. I value my credits from cl 더 보기

$2500 USD (13일 이내)
(3 리뷰)
5.0
NataliaMartinez1

Hi, This is an energetic software developer. I have top skills in Web & Mobile app development. While reading your job description, I understood your main goal. As I am strong at this kind of project, I am pretty sure 더 보기

$2250 USD (7일 이내)
(3 리뷰)
3.9
jaydevbhagat

Hello I am Jaydev Bhagat from India. I am working with ODOO since it was TinyERP for more than 6 years. We have developed various opensource software's customized and implemented ODOO for Startup to large scale compa 더 보기

$3000 USD (45일 이내)
(2 리뷰)
4.0
george19921014

Hello! Nice to meet you! I have read your project carefully.I am very interested in your project. I have a lot of experience on data processing. I have used the Talend DI, MDM and BD before. I hope to cooperate with 더 보기

$2000 USD (10일 이내)
(2 리뷰)
3.4
abdulmohsin

Happy to work on this assignment. I have gone through your integration requirement between Postgres and Oracle and I believe it can be done easily. I've good experience on the integration technologies like Oracle servi 더 보기

$1500 USD (7일 이내)
(6 리뷰)
3.4
yongan20151117

Hello How are you. I am dataprocessing expert for cloud service system. ETL is my top skill. i can help you with talend. Thank you.

$1500 USD (1일 이내)
(3 리뷰)
3.0
pinesucceed01

Hi there, I am JAVA developer, please check my skills below: 7+ Years experience in design and development of Enterprise Software Systems built on Java and J2EE technologies. Expert in Rich Internet Applications (R 더 보기

$2250 USD (7일 이내)
(1 리뷰)
2.5
EricMtpixels

We have been working on such functionalities and have extensive knowledge of what you’re looking for. We're an American Company, based in Flower Mound, TX, with a phenomenally talented team of designers and developers 더 보기

$2000 USD (10일 이내)
(1 리뷰)
2.5
athminteam

Hi, This is Vipin, an alumnus of IIT Kanpur. I have 6+ years of experience in customized software, web and mobile app development and has expertise in Android, iOS, Python, Magento, PHP, HTML, Java, Angular and Ioni 더 보기

$2250 USD (7일 이내)
(6 리뷰)
2.9
soniasappal

Hi, My name is Sonia, I am Solution Architect with 8 years of IT experience in App and Web development, my core area of programming is the JAVA SCRIPT and I can also help you with framework like Express. I can provid 더 보기

$2250 USD (7일 이내)
(1 리뷰)
2.3
AcaIli

Hello Very interested in your project. Have done similar project before. You can rest assured that get a good deal. Hire me, then you will succeed with my brilliant product. Best Regards.

$2250 USD (7일 이내)
(2 리뷰)
1.3
Vitspl

Hello, We have reviewed your requirement and we have the right skills to make your project successful. You have explained the requirement pretty well and have covered the aspects of functionalities in a sophisticated 더 보기

$3000 USD (21일 이내)
(0 리뷰)
0.0
songhwa2019

Hi there. Thank you for your posting. I have a lot of experiences in SOA and data integration, and I can help you. I have worked in several big soa projects and I got familiar with esb(wso2 esb, jboss fuse) and etl(tal 더 보기

$2250 USD (7일 이내)
(0 리뷰)
0.0
GlobtierUSA

Hi, Greeting from Globtier! We have gone through your job posting and found our skills best suited for the project scope. We would be glad to mention here that we are having a professional & experienced team of ODOO D 더 보기

$3000 USD (15일 이내)
(0 리뷰)
0.0
PeterLi0529

Hello I'm peter. I am a ODOO EXPERT who has expertise in cloud environment development such as k8s,openshift,openstack for business platform. So i have good experiences in bigdata (Talend),ElasticSearch technology and 더 보기

$3000 USD (30일 이내)
(0 리뷰)
0.0
ayesha0124

Hi there,. I have checked the details, I have rich experience with Data Integration, Java, Relational Databases. Please initiate the chat so that we can discuss in detail.I am new to freelancer.com but I assure you th 더 보기

$2500 USD (6일 이내)
(0 리뷰)
0.0
conceptzs

I have a huge experience to take up challenge in the vertual World of internet l offer solutions from Development to testing . we use all Latest Technologies .Like Full-PHP/Codeignitor/Laravel/Cake PHP / Symp 더 보기

$1500 USD (5일 이내)
(0 리뷰)
0.0
zorioninfotech

hi dear sir/mam after reviewing your job requirement carefully We Are100% sure that i can help u to achieve your goal in your time frame with over all 5+year hand of experience in java,php,android,laravel,bootstrap,cod 더 보기

$2250 USD (7일 이내)
(0 리뷰)
0.0
Tikhonovich

Software Engineering Guru, Mobile App Development Guru, Web site Development Guru, awarded Bachelor's Degree at University of Texas at Brownville, US, I am. Having checked the requirement of this project, I can notice 더 보기

$2250 USD (7일 이내)
(0 리뷰)
0.0
naishodayo

How are you, sir. I have checked your post. And I just have known that you want a developer to work for your job - 'Simple eCommerce integration in Talend (we also welcome other ETL/ESB tools): Odoo ERP + Digitland Ent 더 보기

$2500 USD (13일 이내)
(0 리뷰)
0.0