Develop a fully independant CAS Server on a tomcat webserver connecting to an Oracle and MySQL

1. Definition of Business Need/Requirement

To remove the dependence of the central authenticating server for Efiling and CMS on the ITMS database. The table that contains usernames and passwords of the two systems resides in the ITMS database server. Hence the heavy weight ITMS database server is a single point of failure for both CMS and Efiling

2.1. Current Process and Service

Currently the ITMS database system contains several schemas. One of these schemas is called Efiling and contains local Efiling data. The Efiling schema has been granted rights to read/select from the RTMS schema. It’s in the RTMS schema that the table containing usernames and passwords called user_details resides.

The Efiling architecture consists of an authenticating and ticket management server as well as an application server. The authenticating server connects to two data sources being the ITMS database for access to usernames and passwords, as well as MySQL GALERA cluster for ticket maintenance.

The CMS architecture is such that the application authenticates its users through a web service interface with Efiling. The authentication data is still held in the ITMS database.

2.2. Current Technology Environment

The CAS server is running on a tomcat webserver connecting to an Oracle and MySQL database. Both the Efiling and CMS applications are running on a Jboss 6.4 application server

3. Validation of Project

Implementation of this will fully decouple authentication from Efiling and CMS applications. Outcomes/benefits will include the following:

• The instability/slowness/downtime of ITMS will not affect Efiling and CMS.

• Authentication will be more robust and reliable as the sever will have only one simple task to do.

4.1. Description of the technology and concepts to be used to achieve the business need

• The data in the user_details table currently on the RTMS schema will be dumped as SQL inserts, and the user_details table will be dropped from the RTMS schema.

• A replica of the user_details table will be created in the GALERA cluster currently used by the CAS application. The table will be created in each of the three nodes making up the GALERA cluster.

• The current web service interface for authentication between the Efiling and CMS applications will be decommissioned.

• A web service interface for handling authentication in to CMS will be created in CAS. CMS external registration is already done though Efiling, that will be left as is.

• A web service interfaces for push/pull of user registration data will be created on Efiling pointing to CAS. Likewise a similar web service interface will be created on the CAS application.

• The mode of authentication of the ITMS oracle forms application will not be touched and will remain as is. The oracle forms application maintains authentication data on a table separate to user_details, therefore CAS will not apply to this application

Skills: Java, MySQL, SQL

See more: want develop travel portel support server, sip server tomcat java, hardware diagram linux web server tomcat, ububtu server tomcat installation directory, ubuntu server tomcat java, connecting databases mysql sql server j2me devices, sip server tomcat, ubuntu server tomcat access, ubuntu server tomcat install, rent server tomcat, ubuntu server tomcat installation, ubuntu server tomcat webapps, ubuntu server tomcat java server, ubuntu server tomcat directory, ubuntu server tomcat

About the Employer:
( 0 reviews ) Gaborone, Botswana

Project ID: #14963299

31 freelancers are bidding on average $54/hour for this job


Hello, We have a team of Skilled Java-J2EE professionals with experience up to 8 years. ===== Our Expertise in Java / J2EE : * Desktop Applications : Swing, Eclipse Rich Client Platform, AWT, SWT, RMI * More

$50 USD / hour
(79 Reviews)

Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so More

$52 USD / hour
(47 Reviews)

Hi, I’m a Web Designer/Developer from the UK. My name is Mike. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. Let's have a quick chat whe More

$55 USD / hour
(16 Reviews)

Hello, I hope you are doing well. I have gone through your requirement and understand that you want a responsive website and mobile app to be designed and developed. I am happy to share with you that we have 10+ More

$51 USD / hour
(16 Reviews)

A proposal has not yet been provided

$55 USD / hour
(28 Reviews)

You can see my last project which are based on Algorithm Development Machine Learning and I can complete your project perfectly. We have 10+ years experience in software development. We have developed 400+ projects More

$50 USD / hour
(23 Reviews)
$55 USD / hour
(10 Reviews)

Hi there, I’m a Software Developer with a strong background developing desktop application. My expertise skills are Java, J2EE, JSP,JavaFX, Bitcoin, Struts, JPA, Hibernate, Spring, Web service, REST API's, JSON, Mave More

$50 USD / hour
(15 Reviews)

Lets Get Start Inbox Me !! Ready to start it now read requirement very carefuuly .. Looking forward positive responsefrom your side. Having more than 100+ review on freelancer in last 2 years Check this link- - htt More

$51 USD / hour
(4 Reviews)

Hi, My name is Benjamin. I'm an expert with over 14 years of experience. I have worked on Tomcat, Oracle and MySQL, and understand the concept of how the CAS server architecture is being planned. Would love to wo More

$60 USD / hour
(13 Reviews)

A proposal has not yet been provided

$50 USD / hour
(24 Reviews)

Hi Sir, I have good experience in SSO, Open IAM and CAS server development. I reviewed your requirement for the CAS server development and deployment on tomcat it's looking fine to me . I would like to discuss with yo More

$55 USD / hour
(8 Reviews)

Hello, I have gone through the description and can help you with the desired solution. Hi, Hope you are doing well! Please spare some time to talk. I have expertise over your requirement, I have a team of high More

$50 USD / hour
(8 Reviews)

I am an IITK graduate and I have 9 years of experience in software development. I have 100% completion rate and I have finished all the projects with the highest level of customer satisfaction. I usually finish project More

$55 USD / hour
(17 Reviews)

Hello Mate, Hope you are doing well. This is Ramesh CTO of Shaligram Infotech. We have vast experience in website development, software development and Mobile Application development in different technologies. W More

$50 USD / hour
(3 Reviews)
$55 USD / hour
(4 Reviews)

I’m I can start your project right now, and can work full-time on your project as well. I wish we talk more about the project during interview. Please suggest a suitable time for discussion. Sincerely.

$55 USD / hour
(4 Reviews)
$55 USD / hour
(6 Reviews)

Hi, sir I am very interested in your project. I have experience with 9 years. And also I'm very lucky so your project will be completed finely in the shortest time. Please send me message and discuss more. Thank More

$50 USD / hour
(5 Reviews)

Hi, I am 12+Yr experienced Java/JEE developer having designed/developed/supported applications for companies like HP, Manhattan Associates, Home Depot, Best Buy etc I have gone through the entire business case and I More

$50 USD / hour
(1 Review)