Equnix Business Solution | an Open Source and Open Mind Company



PT. Trans Retail Indonesia (Carrefour)

Carrefour is the first chain-store to introduce the concept of hypermarkets and provide new shopping alternatives for its customers in Indonesia. In January 2013, Trans Corp through its subsidiary, PT. Trans Retail Indonesia takes over 100% of PT. Carrefour Indonesia so that the company name was changed to PT. Trans Retail Indonesia (Carrefour). Carrefour innovates in providing world-class services in Indonesia's retail industry.

PT. Trans Retail Indonesia as Indonesia's largest retailer has a huge necessity for high-performing Database and transactional capable services. With PostgreSQL, PT. Trans Retail Indonesia is capable to reduce the burden of considerable cost per year while maintaining high performance in more than 100 stores, and more than 3,400 POS machines, to manage more than 170,000 items of goods, with daily transactions that can reach millions of transactions per day.

Carrefour implements PostgreSQL from store-to-head office server, to accommodate transaction data both in real time online and in standalone mode. With the flexibility of the PostgreSQL mechanism, Carrefour capable to achieve optimal service levels with total Equnix services support while maintaining a low but effective investment cost. Equnix implements the Multi-Master Replication model into the PostgreSQL state-of-the-art feature in enterprise solutions. The number installed to date is over 200 Database logical instances, spread nationwide.

PT. Trans Retail Indonesia proved to be very helpful with the services of Equnix. This is evident from the entrusted Equnix by PT. Trans Retail Indonesia in the development of fields in addition to other PostgreSQL of their information systems, in particular with the inherent assistance provided professionally by Equnix. At Carrefour, Equnix also contributed to the development of the price calculation system, with an initial increase of 7 hours to calculate the price of about 7000 items, to be only 15 minutes to calculate the price of 15,000 items.

PT. Harja Gunatama Lestari (Borma)

Borma is a huge, inexpensive, and complete department store, which provides goods ranging from basic necessities, cosmetics, household appliances, electronics, building equipment, hobbies, motorcycle accessories, cars, and also computers.

Borma has a Post-of-Sale sales system that uses the PostgreSQL database as its database server. This is the right choice because Borma can save costs when using other proprietary software. A large, critical system must have a reliable database and have local professional support so that the database is always in prime condition.

Equnix is pleased to maintain the Borma database and has provided support for every case that occurs. This provides peace of mind for Borma management because if a case occurs, the case can immediately escalate to Equnix. Equnix has also optimized the reporting queries which were previously slow but now reporting can run faster.



PT Indomarco Prismatama (Indomaret)

Indomaret, a franchised retail chain in Indonesia, has more than 20,000 branches spread across the country. As the first and largest minimarket franchise company in Indonesia, Indomaret requires a high-performance database to manage its operations efficiently. With the high demand for the use of RDBMS, Indomaret planned to migrate its Oracle database to PostgreSQL.

Equnix was commissioned to convert all Oracle database modules to PostgreSQL on October 13, 2021. This included 1103 procedures, 200 functions, 902 triggers, and 15 Java extensions, with a total of 1,173,206 lines of code across all modules. One of the challenges faced during the project was converting complex modules and rebuilding the Java code into an extension that could run on PostgreSQL.

However, despite the challenges, Equnix successfully converted all modules on November 8, 2022. After going through two rehearsal stages, the new system was deployed into production on November 30, 2022. By migrating to PostgreSQL, PT Indomarco Prismatama was able to reduce costs while maintaining high performance. The migration project can be considered a success in every stage of its implementation. Equnix's commitment to teamwork was a significant factor in the project's success.

PT Akur Pratama (Yogya)

Yogya Group initially used the TPLinux POS application which is the equivalent of the Wincor/Nixdorf machine. Currently, TPLinux is entering its end of life period which requires Wincor/Nixdorf POS system users to upgrade to a newer system, namely: TP.Net. After going through various considerations, the Yogya Group finally decided to use equpos as the best solution. equpos does not depend on a particular machine and can accommodate EOD (End of Day) reporting quickly (<1 minute) while TPLinux takes 30 minutes.Equpos also provides several features not found in TPLinux, including Automatic Device, Price Overwrite, price changes on the dashboard, and automatic drawers. The Automatic Device feature automatically detects devices connected to the POS machine. Furthermore, Price Overwrite on equpos allows for adjustments to prices and discounts under specific circumstances, while TPLinux only permits price changes. Upon completion of a transaction, the drawer opens automatically, and the printer immediately produces the receipt.

equpos' features have proven to be highly beneficial for Yogya Group, as they enhance operational efficiency and effectiveness in retail. Since implementing equpos, Yogya Group has experienced enhanced convenience, comfort, and flexibility, resulting in heightened customer satisfaction. Equpos can accommodate Yogya's business requirements, such as promotions and marketing strategies, as evidenced by the implementation of 33 different promotions. By using equpos, Yogya Group can save a lot of costs that must be spent on upgrading to TP.Net which requires replacing new hardware in more than 1,500 POS terminals across 12 stores. In the future, Yogya Group plans to deploy equpos in all Yogya and Yomart stores to optimize customer service



PT. Kimia Farma Tbk.

PT Kimia Farma (Persero) Tbk, usually called Kimia Farma, has developed into an integrated health care company in Indonesia. Kimia Farma Healthcare business is supported by pharmaceutical manufacturing, research, and development, distribution and trading, marketing, pharmaceutical retail, as well as clinical laboratories and health clinics.

Equnix Team is present to provide solutions and specific optimizations for Kimia Farma's Point-of-Sale database. This database is used by Kimia Farma stores throughout Indonesia. The Equnix team implemented High Availability to support the database system to remain accessible. Equnix also provides several solutions related to applications so that they can access the database precisely which increases the performance of the application itself.

PT Kereta Commuter Indonesia (KCI)

PT Kereta Commuter Indonesia (KCI), a subsidiary of PT Kereta Api Indonesia, provides transportation services to commuters in Indonesia. In 2013, KCI implemented an electronic ticket system based on electronic money cards, which significantly increased the average number of passengers transported per day. However, with high traffic, KCI needed to maintain the E-Ticketing database to ensure the smooth operation of the electronic ticketing system. To achieve this, a comprehensive assessment of the system was necessary to identify areas for improvement and optimize future maintenance.

In December 2022, Equnix conducted an assessment of the entire existing system at KCI, from data entry through the gate to the central database (SOTC). The assessment revealed opportunities to increase efficiency in the current system, including data structure and topology. The assessment also identified problems such as a lack of archiving and housekeeping, issues with floating money data, and database corruption.

Based on these findings, Equnix proposed a solution with several stages to improve the system's performance and efficiency. The proposed improvements were prioritized to address critical issues and optimize the E-Ticketing system's operation. With the implementation of these improvements, KCI will be able to maintain its electronic ticketing system based on electronic money cards and continue to provide reliable and efficient transportation services to its passengers.



PT PLN (Persero)

PLN Mobile was launched to provide a convenient way for users to access PLN's services, including electricity, internet, repairs, and information on Public Electric Vehicle Charging Stations. Since its launch, the application has been downloaded by over 35 million users, making it one of the most widely used mobile applications in Indonesia.

To ensure that the PLN Mobile application can handle the large number of users and provide reliable services, PLN initiated an assessment of the system handled by the Expert: Equnix Business Solutions, PT, particularly on the database side. The assessment revealed several opportunities to optimize the performance and efficiency of the current system, including slow query optimization, data structure optimization, and INDEX optimization.

To address these issues, PLN implemented various stages of improvement, such as optimizing the database configuration and creating a new indexing strategy. PLN also introduced an OLAP database to manage old data, which helped to reduce the size of the OLTP database and improve system performance.

These improvements have resulted in a more stable and efficient PLN Mobile application, allowing PLN to provide better services to its users. The success of the PLN Mobile application has also demonstrated PLN's commitment to digital transformation and providing convenient and reliable services to its customers.

PT. Pelabuhan Tanjung Priok (PTP)

Conveniently located in North Jakarta, Port of Tanjung Priok (PTP) is the busiest port in all of Indonesia. This port handles more than 30% of Indonesian non-oil commodities, alongside 50% of the entire flow of goods in/out Indonesia through this large port. Therefore Tanjung Priok is a barometer of Indonesia's economy.

The magnificent complete intermodal facility in the Port of Tanjung Priok is able to connect with the entire city in Indonesia. Having modern technology and facilities, Tanjung Priok has been able to serve ships of the latest generation which proceeds directly to various international trade centers (direct call).

PTP has been developing a Business Intelligence (BI) application to increase the ease of monitoring all data. Equnix is turning up to provide a Data Warehouse (Deepgreen) solution as a data storage medium used by BI applications. Deepgreen is a powerful Data Warehouse application where it can be proved that BI applications running on top of Deepgreen up to now have no problems either in terms of performance or others. This is the basis that PTP is satisfied with the services provided by Equnix.


Blue Bird Group

Blue Bird Group is a business group providing services ranging from Regular Taxi (Blue Bird & Pusaka) to Executive Taxi (Silver Bird), Limousine & Car Rental (Golden Bird), Charter Bus (Big Bird), Logistic (Iron Bird Logistic), Property (Holiday Resort Lombok & Pusaka Bumi Mutiara), IT & Supporting Services (Hermis Consulting-IT SAP, Pusaka Integrasi Mandiri-EDC, Pusaka GPS -Petrol Station, Pusaka Bersatu - Lubricant, Pusaka Suku cadang Indonesia - Spare Part and Heavy Equipment (Pusaka Mainstay Perkasa & Pusaka Bumi Transportasi). Along with the growing market demand for reservations using smartphones, Blue Bird Group develops Mobile and Database applications that PostgreSQL uses.

Equnix serves Blue Bird for the implementation of the PostgreSQL Database used for the Mobile Online application. Equnix provides best practice PostgreSQL architecture according to the needs of the application. In addition to Equnix architecture also perform Database Tuning and Query Optimization to improve Database performance. Equnix also configure Streaming Replication as Standby Server for reporting needs. After configuring from the Database side, Equnix setup Monitoring and Alert System to perform operational monitoring of Blue Bird.

PT. Wijaya Karya (WIKA)

PT. Wijaya Karya (WIKA) is a state-owned enterprise with construction and building specialties that has been established since 1960. WIKA has passed a series of rapid growth phases to have various divisions covering related business activities including building construction, property and realty, concrete, metal , as well as trade and industry.

As one of the pillars of State Owned Enterprise in Indonesia, WIKA has contributed to using software from Open Source to avoid the dependence of expensive external licenses. However, the use of PostgreSQL which has been long enough in WIKA needs to be refreshed again, because it is still using the expired version.

Equnix serves WIKA to get a powerful Database performance and support the latest features, thereby increasing the speed, accuracy and maximum performance that will ultimately improve overall work efficiency.

One example, the upgrade and tuning results are jointly tested by Equnix and WIKA with complex queries from WIKA applications. The test results show a significant increase of 3100%, from 68,793,561 ms on PostgreSQL system before upgrading to 2,201,558 ms.