BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Is it possible to update the database using DTS or SSIS?
Rank: Member
Joined: 3/26/2008(UTC)
Posts: 7
|
Hi everyone,
I'm currently evaluating BV5. A lot of it looks really great, with a lot of functionality that will save me a lot of time upgrading our classic ASP site to .NET.
I do have a concern, however. At the moment, we have a website as well as a physical store. It's very important for us to keep stock levels in sync between the store's point-of-sale database and the website's database.
Currently I'm using DTS in Enterprise Manager to perform hourly automatic updates, and it works brilliantly.
We definitely can't use the admin pages in BV5 to do these updates, as we're talking about hundreds of new products added to our catalog each week, all of which need to both be inserted into as well as updated in the db.
I've seen that there's an import tool, but even this seems that it will require a bit of manual work which we don't want to have to do. Much better for it to be automated for us.
Is anyone using DTS or SSIS in SQL Server 205 to perform automatic updates? I've a feeling that this won't be possible as it seems that the id's for products are autogenerated somewhere (in a class or dll?) - is there a way to call the methods required to properly insert & update products?
If this isn't possible then any other ideas would be appreciated, as this could be a dealbreaker for us.
Many thanks!
Chris
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Chris, 1) Yes you can update the inventory columns directly in the database if you wish 2) We have XML Web services that can be used to update inventory via SOAP/XML calls 3) The source code to the flat file import tool is available at http://www.codeplex.com/bvc5importtool/ if you want to write your own utility to automate the process
|
|
|
|
|
|
Rank: Member
Joined: 3/26/2008(UTC)
Posts: 7
|
Hi Marcus,
Thanks very much for the prompt reply - this is a good sign from a support perspective.
I've downloaded the source code so I'll look at that, this may be the easiest way.
Many thanks,
Chris
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Chris,
The IDs are just simple GUIDs that you can generate in SQL using the NEWID() function.
All you have to make sure is that you match products betwen your store and retail using the SKU and inside BV using the GUID and you should be good to go with DTS.
Regards,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 7/14/2004(UTC)
Posts: 254
|
Given that its a SQL server 2005 backend, not 2000, you should develop all new packages in SSIS. If you have existing DTS packages that you don't expect will need any future updates, you can run them from within SSIS but its not really recommended unless you have a significant investment in known stable packages and don't want to spend the time rebuilding them from scratch. Anything complex is much easier to build in SSIS despite the learning curve from DTS.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.