Project background
The company provides financial services, including mortgages. They required a dedicated, user-facing solution to streamline mortgage calculations.
Country
Israel
Technology
Java 11
Cooperation
May 2022 - June 2022
Integrating Google Sheets
Our main task on this project was to integrate the web app with Google Sheets. Previously, users couldn’t access their mortgage information. Now, it is simple. A client opens the web app, logs in and clicks “My Mortgage”. The link leads to a Google Sheets page with relevant data.
How does it work?
1 step
A user registers in the web app
2 step
The back end processes user data and sends it to the PostgreSQL database.
3 step
The software automatically creates a new Google Sheets document for the client. It contains formulas for mortgage calculations.
4 step
Using a Google library, we add user data in appropriate blank cells.The link to the document goes to PostgreSQL and a user profile.
5 step
The software automatically creates a new Google Sheets document for the client. It contains formulas for mortgage calculations.
Technologies
Our experts used several prominent technologies to satisfy project needs.
The database
As mentioned, the project’s database is PostgreSQL. It is an open-source, relational database. The software is free to use even in commercial projects. Other benefits are reliability, extensibility and SQL compliance. As of February 2023, PostgreSQL is the 4th most popular database worldwide.
Database management tools
Our experts used Liquibase and QueryDSL to simplify database management. QueryDSL is a handy Java framework. It allows coders to write type-save queries to the database. “Type-save” means that developers check queries’ syntactical validity during compilation. The benefits are fewer errors and easier refactoring. Developers use QueryDSL with various relational and non-SQL databases. The syntax is similar to SQL, ensuring convenience and efficiency.
Liquibase
Liquibase is an open-source, Java-based library. Coders use it for data migration and database management. It allows to implement and track database changes. Thus, developers can easily add new tables and columns, modify data, migrate data between different database versions and more. Database version control (change tracking) makes software development safer and faster. It also simplifies collaboration. Liquibase is a valuable DevOps tool. It facilitates CI/CD by automating database changes. The technology works with many popular databases, including PostgreSQL, MongoDB, MySQL, Oracle, AWS databases, Microsoft SQL Server, etc.
Google Sheets API
Google provides developers with handy APIs for their products and cloud services. Our team used the 4th version of Google Sheets API SDK for Java. It conforms to the REST architectural approach. The technology allowed us to set up a connection between the database and Google Sheets. Thus, we defined which data pieces from the database go into specific cells in Google Sheets.
Spring Security & OAuth 2.0
Spring Security is a robust Java framework for authentication and access control. Google APIs require OAuth 2.0 authorization protocol. We set it up using this framework. Spring Security makes authorization setup more straightforward and customizable.
1+ years
Of successful cooperation with client
3 weeks
To integrate Google Sheets
1 professional
Dedicated to the client project development team