Create Data In Corp For Stores To Pull

Execute the following SQL statements in the tab for using the "run as script" button.

insert into item (item_id, name) values (110000055, 'Soft Drink');
insert into item_selling_price (item_id, store_id, price) values (110000055, '001', 0.65);
insert into item_selling_price (item_id, store_id, price) values (110000055, '002', 1.00);

Verify Through Outgoing Batches

Verify in the tab under outgoing batches that the data was batched.

Verify Through Logging

Verify in the tab under logging that the data was pulled.

[corp-000-job-3] Routed 4 data events in 14 ms
[store-002-pull-1] Pull data received from corp:000:000.  2 rows and 1 batches were processed
[store-001-pull-1] Pull data received from corp:000:000.  2 rows and 1 batches were processed

Verify Through SQL

Verify in the tab for by executing the following sql.

select * from item_selling_price

Verify in the tab for node by executing the following sql.

select * from item_selling_price

Create Data In A Store To Push to Corp

Execute the following SQL statements in the tab for using the "run as script" button.

insert into sale_transaction (tran_id, store_id, workstation, day, seq) 
	values (1000, '001', '3', '2014-03-21', 100);
	
insert into sale_return_line_item (tran_id, item_id, price, quantity) 
	values (1000, 110000055, 0.65, 1);

Verify Through Outgoing Batches

Verify in the tab under outgoing batches that the data was batched.

Verify Through Logging

Verify in the tab under logging that the data was pushed.

[store-001-job-14] Routed 2 data events in 9 ms
[store-001-push-1] Push data sent to corp:000:000
[store-001-push-1] Pushed data to corp:000:000. 2 data and 1 batches were processed

Verify Through SQL

Verify in the tab for node by executing the following sql.

select * from sale_transaction;

select * from sale_return_line_item;