I agree that using JMS to make a loosely coupled architecture will make
a very robust ERP solution that will be successful in situations where
consistent connectivity is a problem. I tested Red1's original JMS ERP
solution and found it very nice. I've just downloaded the demo version
of SmartPOS and have a basic question about the architecture.
It appears that the Windows Client of SmartPOS uses the Postgres
database on the server in real time. Is that the case or am I
confused? If this is so, then it looks like the Windows Client cannot
operate in a disconnected mode and always needs to be connected to the
Postgres database on the server. I found that Red1's utilization of a
local Derby Database for the remote client a breakthrough architecture.
Is it possible to use that approach?
Thanks!
Sean O'Neil
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
SmartPOS database usually will use a local (or LAN) postgres (just postgres is supported by now) ...different from the server side ERP postgres database .. you are confused. If you want to have many POS stations, You also might want to have a more reliable central local (LAN) database server shared for the POS stations ... independent of the ERP database .....
We design the solution where just one erp, can support many POS databases (1 per organization with private data) .. but each POS database might be shared by many POS (connected to the same database, same menu, inventory and so on).
However for demo purposes or if you have a local server (ERP) you might use the same database server for both, but the general idea is to have the ERP server in a external datacenter with internet access .. while the POS will be in a LAN environment.
Regards
Pedro Rozo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Glad to see you enjoy our contribution ....please publish your positive feedback and experience about it in the future, that help to motivate our team and it is a good contribution to give more confidence to newcomers about our project.
Regards
Pedro R.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Pedro,
I'm thinking about an approach where I don't need to maintain a server at each location. Instead, each POS needs to be fully functional by itself. Each POS still synchronizes with the remote ERP system in the external datacenter. If any POS has a problem, it's a simple swap out of that machine followed by a resynchronization for it to pull down the inventory. To achieve that goal, could I run a local Postgres db server on each Windows POS? And if I did, would I need to enforce uniqueness at some level? For example, would each POS then require its own Organization?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please have in mind for your business scenario that standalone operation for the POS is just supported for emergencies (some hours), our solution is a master (ERP) - salve (POS 1 -n ) solution where data need to be synchronized (inventory, pricing, orders) to keep consistency ... This is not like open bravo POS, where you can work as much as you want standalone and later synchronize with the ERP ...because you might have issues with inventory....
You can install a local postgres for sure, depending on your branching model (1 or many stores with independent or shared inventory you would need N orgs in SmartERP as you require and N postgres databases (1 per organization) .. regarding POS, you can share the same postgres database (per org) . you might need to be more precise with your business structure (HQ, branches, independent inventory, how many POS stations per organization and so on ) to have a better suggestion from us.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is there a person that might should assist me get the software strolling well? I assume I actually have set the whole lot up like this, however I cannot add anything into the database.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is there a person that might should assist me get the software strolling well? I assume I actually have set the whole lot up like this, however I cannot add anything into the database.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I agree that using JMS to make a loosely coupled architecture will make
a very robust ERP solution that will be successful in situations where
consistent connectivity is a problem. I tested Red1's original JMS ERP
solution and found it very nice. I've just downloaded the demo version
of SmartPOS and have a basic question about the architecture.
It appears that the Windows Client of SmartPOS uses the Postgres
database on the server in real time. Is that the case or am I
confused? If this is so, then it looks like the Windows Client cannot
operate in a disconnected mode and always needs to be connected to the
Postgres database on the server. I found that Red1's utilization of a
local Derby Database for the remote client a breakthrough architecture.
Is it possible to use that approach?
Thanks!
Sean O'Neil
Hi Sean ...
SmartPOS database usually will use a local (or LAN) postgres (just postgres is supported by now) ...different from the server side ERP postgres database .. you are confused. If you want to have many POS stations, You also might want to have a more reliable central local (LAN) database server shared for the POS stations ... independent of the ERP database .....
We design the solution where just one erp, can support many POS databases (1 per organization with private data) .. but each POS database might be shared by many POS (connected to the same database, same menu, inventory and so on).
However for demo purposes or if you have a local server (ERP) you might use the same database server for both, but the general idea is to have the ERP server in a external datacenter with internet access .. while the POS will be in a LAN environment.
Regards
Pedro Rozo
Hi Pedro,
Thanks for clearing up my confusion. Your answer makes a lot of sense and I really like that architecture.
I've got the demo working and I like what I see!
Sean
Glad to see you enjoy our contribution ....please publish your positive feedback and experience about it in the future, that help to motivate our team and it is a good contribution to give more confidence to newcomers about our project.
Regards
Pedro R.
Sean
Talking about contribution, could you give us your personal feedback/review here: https://sourceforge.net/projects/smart-pos/reviews/
Thanks
Pedro R.
Last edit: pedrorozo 2012-05-29
Hi Pedro,
I'm thinking about an approach where I don't need to maintain a server at each location. Instead, each POS needs to be fully functional by itself. Each POS still synchronizes with the remote ERP system in the external datacenter. If any POS has a problem, it's a simple swap out of that machine followed by a resynchronization for it to pull down the inventory. To achieve that goal, could I run a local Postgres db server on each Windows POS? And if I did, would I need to enforce uniqueness at some level? For example, would each POS then require its own Organization?
Sean
Please have in mind for your business scenario that standalone operation for the POS is just supported for emergencies (some hours), our solution is a master (ERP) - salve (POS 1 -n ) solution where data need to be synchronized (inventory, pricing, orders) to keep consistency ... This is not like open bravo POS, where you can work as much as you want standalone and later synchronize with the ERP ...because you might have issues with inventory....
You can install a local postgres for sure, depending on your branching model (1 or many stores with independent or shared inventory you would need N orgs in SmartERP as you require and N postgres databases (1 per organization) .. regarding POS, you can share the same postgres database (per org) . you might need to be more precise with your business structure (HQ, branches, independent inventory, how many POS stations per organization and so on ) to have a better suggestion from us.
Is there a person that might should assist me get the software strolling well? I assume I actually have set the whole lot up like this, however I cannot add anything into the database.
Is there a person that might should assist me get the software strolling well? I assume I actually have set the whole lot up like this, however I cannot add anything into the database.