Dear all,

I need to create automatic interface from external systems to import data in Odoo (products, prices, specifics tables in my own module...). I use Talend as ETL to transfer data from systems. I have several options :

1- Insert data with SQL request create in Talend. I need to create lines in table and external id's linked to keys.

2- Create flats file with Talend and automatize the import in odoo. 

3 - Use web service (if they exist) to create data in Odoo (call them with Talend).

What is the best option ? And have you some examples ?

Thanks in advance.

Regards

Marc