Problem statement: for many companies the number of internal mobile users for ERP/Tally ERP data on mobile are significant. Say the number of mobile users is 10. The other issues to be raised are as follows:
a.) The clients could have multiple companies.
b.) The client could desire to have complete control over the data.
c.) The costs could increase exponentially.
d.) The client could desire to give access to external stakeholders as well.
The solution to this problem can be envisaged in multiple ways. We have looked at the following ways:
a.) Giving access through excel
b.) For tamper proof access giving access through Powerbi[no database involved]
c.) For lowest cost over a large number of end users access through sql server database using row level security.
Access through Excel:
For many of the reports Tally could be used as a webserver and the data imported into Ms Excel. The data could be extracted into Excel through powerquery or odbc.
sample xml import into excel for Tally:
let
// Define the Tally URL
Tally_URL = "http://localhost:9000",
// Define the XML Input
XML_Input = "
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>Balance sheet</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<EXPLODEFLAG>Yes</EXPLODEFLAG>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
</DESC>
</BODY>
</ENVELOPE>",
// Send HTTP POST request to Tally and fetch the response
Response = Web.Contents(
Tally_URL,
[
Headers = [#"Content-Type" = "application/xml"],
Content = Text.ToBinary(XML_Input)
]
),
// Parse the XML Response
XML_Data = Xml.Tables(Response)
in
XML_Data
The odbc extract is straight forward and can be taken from Tally website.
Once the Excel sheet has been extracted it can be shared via onedrive,googledrive or shared drive.
b.) Usage of Powerbi: Powerbi offers a free on mobile version using the Microsoft platform.Our Powerbi integration would work with the following:
i.) odbc extract :Tally as a webserver
ii.) XML extract: Tally as a webserver
iii.) Json extract: no need of Tally as a webserver, unlimited companies, the business logic has been pre coded in Powerbi.
With the Powerbi version we can also design customized mobile apps for large scale viewing.
Please see our channel for lots of videos and details regarding the same.
SQL Powerbi training module:https://www.youtube.com/watch?v=ptn-rwYGUwY&list=PLZPWImFqOkLtJk2MoUPjb6ap_wFbJN53E
Summarized Powerbi app: https://www.youtube.com/watch?v=eIT4YAITIIg&list=PLZPWImFqOkLvDtnthqV9MzLoXDfoYWNSO
Points to note: If the Myworkspace in the Powerbi module is used then the app can be used by unlimited personnel.
However in case one requires row level access to the data then multiple Powerbi licenses are required. The cost of each Powerbi pro license is USD 10 a month[the data is hosted on the Microsoft cloud servers].
c.) In case the following is the scenario:
i.) Large number of people need to be given access to the data
ii.) Secure row level access for the data is required.
iii.) Data entry features are required.
Then we recommend Web app through SQL Server. The same will work with xml,odbc and json.
Website link:http://103.211.202.97:5002/
Username:Rohit
Password:Rohit@123
View reports: http://103.211.202.97:5002/view-reports?
Data entry format: http://103.211.202.97:5002/data_entry_masterpage?
In this case unlimited people can access Tally data in a secure fashion using row level security.
Please give us a chance for ETL demo.
Name:Apoorv Chaturvedi
email:support@turbodatatool.com;support@mndatasolutions.com
Phone:+91-8802466356
youtube channel:www.youtube.com\@mndatasolutions2042
No comments:
Post a Comment