Web leads imported in my Sugar DB

[woodrow]

I'd like to have leads inputed from my website show up in the sugar DB. I imagine there is a write up some where that someone could point me at.

I basically want to do a cron job that takes anything from my website SQL server and inputs it into my sugar DB so that it show in the web interface as a lead to be followed up with.

Thanks in advance

[roblaus]

Check here for the keyword web2lead or similar. You can create a basic webform in Sugar (which you ca enrich with any html editor) that will insert leads directly into your Sugar database, no need for a second db.

If you want to keep your existing one than you must use an ETL tool that transfers your data, probably condtionally.