Page 1 of 1

Understanding Datasources

Posted: Thu Aug 06, 2015 1:53 am
by stevesampang
hello there.

May i ask if the 3 datasources on BL is working the way this documentation said about the 3 datasources

"The first is the "webDS", or main data source containing most of the tables used by Broadleaf Commerce. The second is the "webSecureDS" which is meant to provide a secure data source for tables that contain things like payment information in a PCI compliant situation. The third data source, "webContentDS", is a data source to store content-managed data such as page snippets."

http://www.broadleafcommerce.com/docs/c ... figuration

I used different databases on each of the datasources but whenever i added content and customer account they all added to the webDS database not on the webContentDS and webSecureDS databases.

Thank you.

Re: Understanding Datasources

Posted: Thu Aug 13, 2015 11:58 pm
by phillipuniverse
it's actually content storage which is really for holding static file image blobs so the only thing that goes in that data source are StaticAssetStorageImpl.

The webSecureDS is only for PCI-secure info like CC number, bank account number etc.

Re: Understanding Datasources

Posted: Sun Aug 16, 2015 8:41 pm
by stevesampang
ah thank you @phillipuniverse for the reply.

do you mean content storage is webContentDS ? and what datasource are you saying on "so the only thing that goes in that data source are StaticAssetStorageImpl" ?

but can you please help me how i can enable to test those 3 datasources are working ? like when i add info like CC number it goes to webSecureDS and how about the webDS and webContentDS how can i test them?

thank you again.

Re: Understanding Datasources

Posted: Sun Aug 16, 2015 9:23 pm
by stevesampang
I tried to add StaticAssetStorageImpl but i goes to webDS database. and what are static file image blobs ? sorry for other questions.

Re: Understanding Datasources

Posted: Wed Aug 19, 2015 3:00 am
by stevesampang
About "The webSecureDS is only for PCI-secure info like CC number, bank account number etc." is those info goes into database? what about the payment gateways? sorry i don't have much idea for other BL configuration and service.

Thank you.

Re: Understanding Datasources

Posted: Tue Sep 15, 2015 8:00 am
by phillipuniverse
but can you please help me how i can enable to test those 3 datasources are working ? like when i add info like CC number it goes to webSecureDS and how about the webDS and webContentDS how can i test them?


Ok so to be clear, you should not store the CC number in your own database unless it's behind a firewall. Almost all payment gateways will take care of storing and tokenizing credit card numbers for you so that you can store them more securely. You will usually store the token in a CustomerPayment object that ties a token to a Customer.

webDS is 99% of the database objects in Broadleaf like Sku, Product, Category, Order, etc.

webContentDS is an option if you want to upload images and store the image data directly in the database. We usually recommend storing image data on the filesystem (this is the default).

Re: Understanding Datasources

Posted: Wed Sep 16, 2015 11:36 pm
by stevesampang
@phillip thank you for reply.

okay so it was like that. but i tried to point another database the webContentDS and upload images so that i can test it. I think it the same result. Is there a way to test that ?


thank you.