Large and medium sized businesses use disparate applications to run their business and one of the major areas that need to converge amongst these applications is the Accounting, Financial and Inventory information. Tally is the default Accounting, Inventory and Statutory Compliance software used by enterprises in these segments. Integrating Tally with these 3rd party vendors becomes critical to ensure business continuity and to eliminate redundancy. Mark IT’s Tally Integration Solutions are designed to ensure that the existing investments in Software (ERP, Legacy and other Enterprise systems) remain intact by seamlessly integrating information with new systems, technologies and custom applications within the enterprise, as well as with companies with whom the business deals with.
Need and Benefits of Integration
To meet the challenges of the new business environment, information systems need to communicate with each other as seamlessly as possible, provide right-time visibility of transactions across the entire enterprise and be flexible enough to accommodate the changing structure of the business. When more and more information needs to be shared across traditional business boundaries, the way you integrate your systems and processes is rapidly becoming one of the most important priorities in business today.
Tally ODBC Interface (Read Only)
ODBC (Open Database Connectivity) makes it possible to access data from any application, regardless of which Database Management System (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver between an application and the DBMS. The purpose of this layer is to translate the application’s database queries into commands that the DBMS can understand. For this to function, both the application and the DBMS must be ODBC compliant i.e., the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them. Tally provides the ODBC Interface that makes it possible for applications to talk to Tally Database. By using this interface, external applications will be able to retrieve data from Tally. Tally acts as a Server delivering Data to external applications.
Using the ODBC Interface, Tally.ERP 9 can make ODBC calls to an External Database and retrieve data from them. In such a case Tally acts as a Client to pull Data from disparate Data Sources. This data can be consumed in Tally as per requirement.
Tally XML Interface (Read and Write)
XML (Extensible Markup Language) is the standard for information exchange with external systems. Tally.ERP 9 supports standardized message formats for Request/Response. Tally.ERP 9 can communicate with any environment capable of sending and receiving XML over HTTP. Tally can act as an HTTP Server capable of receiving an XML Request and responding with an XML Response. The entire Tally Data can be made available to the requesting application. It is also possible for the application to store data into Tally Database. Using the same interface, Tally has the capability to interact with a Web Service delivering Data over HTTP. In this scenario, Tally behaves as a client retrieving and storing data into an external database. The Web Service capable of handling Tally Request/Response serves as a layer between Tally and External Database.
Interface & Integrate-ability
Tally.ERP 9 integrates with your other existing (or planned) IT solutions with ease, thanks to the many industry standard interfaces that are supported.
A spreadsheet in MS-Excel ® can be programmed to extract timely information from Tally.ERP 9 using the ODBC interface. An SMS alert product can poll this interface and keep you updated on your cash and bank balances. These are simple examples of the many integration capabilities available to you.
The most versatile and powerful interface is the SOAP capability of Tally.ERP 9. All standard IT products, programming languages and development tools support XML. Without writing a single line of code in TDL an application can read and write into Tally.ERP 9. Already using other business solutions and want to use the power of accounting, finance and reporting of Tally.ERP 9? Your development team or our development partners can export the data format from Tally.ERP 9, build the XML structure with data, and push it into Tally.ERP 9.
In the same way, query any report that is available (or developed with TDL), get that data in XML, and pull that into other applications.
Advanced capabilities, internal unique identifiers, multi-lingual and error responses will meet your most exacting needs of integration.
The opposite is also supported – need to look at a report in Tally.ERP 9 with data that is externally available? Say a comparison with actual and planned values, the planned values available in another application.
Whatever your need – Tally.ERP 9 as the ‘hub’ in an IT solution stack, or a ‘spoke’, the technical capabilities are available by default, at no extra cost.
Tally Integration Capabilities
Tally.ERP 9 has been developed keeping in mind that some users will require features and capabilities that are not delivered out of the box. This calls for the ability to reach out to other software applications.
The many strengths of Tally.ERP 9 also make it an ideal product for integration with other products – which calls for the ability to provide the necessary APIs for read and write.
Tally.ERP 9 as a complete business solution provides different ways to integrate data. The various API’s available in Tally are:
These allows seamless integration between application/database in two modes:
Tally to Tally using Synchronization
Tally to External Application and vice versa using the Interfaces Available
Tally to Web Service using HTTP Interface
Tally to External Applications using Export
Data from External Application in XML using Import
Features and capabilities
Tally.ERP 9 to Tally.ERP 9 integration is done through synchronization. All the branches can periodically synchronize their data with the head office. Data Synchronization refers to a process where data is replicated between two or more locations. It enables the branch offices to send data to the head office and vice versa, over a network with a dynamic IP address or static IP address. Data Synchronization flows both ways, i.e., data flows from the Client to the Server and vice-versa.
Tally.ERP 9 is architectured to be a platform and is designed to support extensive customizations. Tally.ERP 9 comes with an execution Kernel, an interpreter and a development language Tally Definition Language (TDL). Using TDL, you can enhance or change the default behavior of Tally ERP 9. Extend core functionality by interfacing a bespoke application facilitated by Tally ERP 9’s support for custom built DLLs and XSLT.
TDL permits changes to user interface, document print outs, reports, functionalities, addition of data elements and business logics. Tally.ERP 9 supports ODBC and import & export of data in standard data formats like XML & CSV. Tally.ERP 9 has a SOAP listener, which helps in online integration with other business tools.
If the masters and transactions is available in Tally.ERP 9 compatibly XML format, they can be directly imported in Tally.ERP 9.Export
Tally.ERP 9 allows the export of reports in four standard formats, viz. ASCII (Comma Delimited), Excel, HTML, and XML.Tally API's
Tally.ERP 9 communicates with External Application using these interfaces:
- XML Interface (Get/Post)
Using this interface Tally.ERP 9 can behave as a Server handing XML Request from external Applications. Tally as a Client can also send an XML Request to a Web Service
- ODBC Interface (Read Only)
External Applications can retrieve data from the Tally.ERP 9 database by making an ODBC/SQL call. In the same way Tally.ERP 9 can retrieve data from External Data Source using an ODBC/SQL call.
The DLLs developed using other application can be used to perform operations that are not available in the product. These external DLLs can be called from Tally.ERP 9 using the TDL language.
- XML Interface (Get/Post)