Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Question whether MobiLink is the proper tool
25 views
Skip to first unread message
daniel....@gmail.com
Dec 6, 2012, 4:22:34 PM12/6/12
to
The reason i am asking the question here is because the Mobilink tutorials didn't really answer my question and they're rather confusing.
We're an accounting company with several franchises across the united states. Every franchise has our proprietary software and (sybase)database and they perform accounting work for small businesses in their area.
As a franchisor we need to gather data from our franchisee. The amount of data isn't that big. We need to collect basic client information for every franchisee such as name, address, type of business etc. This is strictly for statistic purposes that we need to report to the different states. In addition to that, we need to gather royalty information. Every month, the clients are billed and a royalty amount is calculated on the total billing.
That's about it. We're talking about 4 tables, 2 of which can have hundred of records and the 2 other may only have dozen of them.
We're also studying the possibility of using Mobilink to push messages to our software using a table that would contain messages from home office which would show in a tab in our software.
Based on the tutorial, i think i would know how to setup the synchronization of the message table since the data flows from the consolidation database to the remote database(s). This is basically what the tutorial shows you.
My questionning occurs when i think about having to send the client information from the remote database to the consolidated one. Obviously the data from one remote database to another is different. The same goes for the royalty information. So the synchronization needs to be done only from the remote to the consolidation database.
So both remote database have the following client table format
Office number, CLIENT ID , Client Name, Address , UniqueID
One remote database has the following data
123456 , CLIENT1, Adress1, 1
123456 , CLIENT2, Adress2, 2
And another remote database has the following
234567 , CLIENT1, Address1, 1
234567 , CLIENT2, Address2, 2
Where office number is unique to each remote database and the Unique ID is unique to every row... the primary key is (office number, uniqueid) so that in the consilidated database i dont get duplicate.
Is there a way after the synchronization to have the consolidation table showing
123456 , CLIENT1, Adress1, 1
123456 , CLIENT2, Adress2, 2
234567 , CLIENT1, Address1, 1
234567 , CLIENT2, Address2, 2
From what i seem to understand, the synchronization appears to be an all of nothing. Meaning that once it synchronize with office 123456, it will synchronize all that data back to 234567?
If not, and if Mobilink appears to be the proper tool to achieve that, can someone give me pointers on where to start? So far i have the table schema being the same in the consolidation database and the remote database. I tried to create a sync script based on the tutorials but i couldnt get the remote database to PUSH data to the consolidated database
We're an accounting company with several franchises across the united states. Every franchise has our proprietary software and (sybase)database and they perform accounting work for small businesses in their area.
As a franchisor we need to gather data from our franchisee. The amount of data isn't that big. We need to collect basic client information for every franchisee such as name, address, type of business etc. This is strictly for statistic purposes that we need to report to the different states. In addition to that, we need to gather royalty information. Every month, the clients are billed and a royalty amount is calculated on the total billing.
That's about it. We're talking about 4 tables, 2 of which can have hundred of records and the 2 other may only have dozen of them.
We're also studying the possibility of using Mobilink to push messages to our software using a table that would contain messages from home office which would show in a tab in our software.
Based on the tutorial, i think i would know how to setup the synchronization of the message table since the data flows from the consolidation database to the remote database(s). This is basically what the tutorial shows you.
My questionning occurs when i think about having to send the client information from the remote database to the consolidated one. Obviously the data from one remote database to another is different. The same goes for the royalty information. So the synchronization needs to be done only from the remote to the consolidation database.
So both remote database have the following client table format
Office number, CLIENT ID , Client Name, Address , UniqueID
One remote database has the following data
123456 , CLIENT1, Adress1, 1
123456 , CLIENT2, Adress2, 2
And another remote database has the following
234567 , CLIENT1, Address1, 1
234567 , CLIENT2, Address2, 2
Where office number is unique to each remote database and the Unique ID is unique to every row... the primary key is (office number, uniqueid) so that in the consilidated database i dont get duplicate.
Is there a way after the synchronization to have the consolidation table showing
123456 , CLIENT1, Adress1, 1
123456 , CLIENT2, Adress2, 2
234567 , CLIENT1, Address1, 1
234567 , CLIENT2, Address2, 2
From what i seem to understand, the synchronization appears to be an all of nothing. Meaning that once it synchronize with office 123456, it will synchronize all that data back to 234567?
If not, and if Mobilink appears to be the proper tool to achieve that, can someone give me pointers on where to start? So far i have the table schema being the same in the consolidation database and the remote database. I tried to create a sync script based on the tutorials but i couldnt get the remote database to PUSH data to the consolidated database
0 new messages