B1if: B1 to DB questions

[Former Member]

I'm trying to build an update based on if an item exists on a separate SQL database. I went through all of the webinars, and there's nothing about B1 to DB. There's a DB to B1, which is helpful, but I didn't know if I could just reverse the process and use that, or take an already existing package step and modify it to do the query/update to the SQL table. Again, I need to update/insert to a non SAP B1 table with B1 data based on that non SAP B1 table already having the information. If anyone could help, or point me in the right direction, that would be helpful. Thank you.

[former_member217514]

Yes.

First you want to create the external database in the SLD.

Then in your SQL Call step, select the system you set up in the SLD for SysID

Finally, in SQL Call step, set your SQL Statement as an Update or Insert.

I had created a Scenario step that updated a MySQL database, but I didn't back it up before I reinstalled.

[Former Member]

I have the system in the SLD, and tested connections and it's OK. I created a new package and a new step. the inbound of the step is asynchronus with the DI-API object of item(code). For the outbound, it would be the database/jdbc channels, right?

[former_member217514]

I am not a big fan of the outbound.  I am sure there are scenarios in which it would be usefull. I usually do every thing in steps and leve the outbound as void.  Reason for this is to handle errors.  For example, if an error occurs on an outbound step, you have no ways of checking for errors.  If you do it in your step, then you have the ablilty to either write an alert to B1 or send an email notifying a user that an error occured.  This is particularly true when doing asynchronous step design.

[Former Member]

Thank you for that bit of info. It really helps. I've done the b1tofile xml's no problem, but this is the first time I'm trying to actually write to a DB, so it's just a little confusing. I just don't know where to add the atoms, and what order they go in.

[former_member217514]

If you are performing a complex scenario, it is always a good idea to create a business analysis or flow chart.  This analysis will help you in creating the scenario step atoms.  Practice makes perfect.

[Former Member]

Thank you again for the info, but I really needed help on where the atoms go. I have the flow down, just don't know how to apply it.