Deka Technology

Overview: Bulutistan, founded in 2015 in Istanbul, is a leading Turkish cloud technology company with global connections. They specialize in SAP Cloud solutions and serve numerous large organizations. The company has received investments and awards for its rapid growth and high-quality services. Bulutistan is known for its strong security standards and supports digital transformation in dynamic sectors through pay-as-you-use cloud services.

The Challenge: One of Türkiye’s leading cloud providers, Bulutistan, was looking to establish a new data analytics platform to monitor their customers’ resource allocations, the status of VMs, backup jobs, incidents, customer requests, and changes. Firstly, we focused on setting up a new DataWarehouse and a comprehensive ETL architecture that consolidates all data needed for the project scope.

Clients’ required reports were being prepared manually, resulting in time and effort loss. Data used in these reports can mainly be obtained by calling respective applications’ APIs or directly from their databases. The complexity of the virtualization platform API structure and lack of structured data for other information made preparing reports a challenge.

Additionally, the requirement of using related information for invoicing makes generated data more critical. Therefore, providing top data accuracy was a significant challenge for the project.

What did Deka Technology do: After a detailed analysis and design phase, delivery of the following high-level scope was raised:

1. Design and architecture of a DWH platform based on MS SQL Server
2. Data pipeline setup for ingestion of data generated by consuming APIs
3. Design and implementation of the ETL processes by using SSIS
4. Design and implementation of Power BI reports

The Results:

1. Over 1,100 VMs’ status of resources, utilization, backup jobs, etc. can be monitored
2. Invoicing of top 25 customers could be done automatically
3. >99% accuracy rate of data on DataLake
4. Improved business monitoring and decision-making process
5. Improved time and cost efficiency

Overview: Starting from May 5, 2021, AgeSA Hayat ve Emeklilik has been on a path guided by the equal partnership principle shared between Sabancı Holding and Ageas, an esteemed international insurance group with nearly two centuries of history. Currently, 20% of the company’s shares are publicly traded on Borsa Istanbul under the code “AGESA”. Originally founded in 2007 as AvivaSA Emeklilik ve Hayat, the company officially adopted the name “AgeSA Hayat ve Emeklilik” on July 1, 2021.

The Challenge: It was necessary to enable AD integration with Oracle EBS, which is currently used within AvivaSA. Afterwards, what is required by AvivaSA is to ensure that the authentication processes of EBS users are managed from the Active Directory environment. Users who left their jobs or changed departments were still able to access EBS with the same privileges.

What did Deka Technology do:

After a detailed analysis and design phase, delivery of the following high-level scope was raised:

1. Since the EBS version is outdated, it cannot query directly from AD. Therefore, OID was installed and continuous replication was performed from AD.
2. Oracle access manager was installed and configured to query credentials.
3. Weblogic installations were made for OID and OAM
4. Webgate and accessgate configurations for reverse proxy purposes are defined on WebLogic.
5. All components have been tested to work properly. Incoming and outgoing requests and responses over HTTP were tested.According to the above requirements, the following architecture was implemented.

The Results:

• Oracle EBS system was integrated with AD and users were able to log in with their AD username and password. There is no longer a need for a second password for EBS
• Users were automatically created with E-Expense authority on the Oracle EBS system
• Speed and profit were achieved in operational transactions.
• The findings of the internal audit were closed and compliance rules were fulfilled.
• Users added, deleted and updated in AD are automatically synchronized with the Oracle-EBS system