What is our primary use case?
Our financial system is on Oracle-based, SaaS, hosted on the Oracle cloud. From different XML sources, we had to bring in high volumes of transactions into the financial system.
Before we put all of the data into the product and financial system, we need the data to go through some data messaging, and create some rules and derive some values. There are five or six million records every day.
Google has some very good tools on its platform. They have an App Engine and cluster-based programming so that you are able to achieve high performance.
How has it helped my organization?
Because this is a multiple source system, we need a centralized place where all of the data rules are maintained and where all of the data transformations are performed.
Being from an Oracle background, Oracle doesn't have the tools that Google has to transform the high volume data.
It can perform that validation for the high volume transactions in less time, it can be transformed in minutes.
What is most valuable?
I like this solution. It has a lot of abilities such as data processing and cluster data creation.
The way they use the sources efficiently and the performance are good. The cost is also less, depending on the way that you code.
There is a lot of flexibility and a lot of control if you use this efficiently.
What needs improvement?
I would like to see the drag and drop features improved. They have a lot of hand-coded coding. Now they are doing less coding and more drag and drop and configuration.
From a developer's perspective, it would make it simpler and also the less manual coding will lead to fewer defects. Less coding ability but most coding should be automated using a drag and drop functionality.
The setup could be more user-friendly.
In the next release, I would like to see improved drag and drop features, less coding abilities, or zero coding abilities. This would mean that you can do it by using your configurations, or even when you drag and drop it can be an orchestration so that anyone can do it. It would not be just some hand-coded kind of development that will be used by developers in the future.
For how long have I used the solution?
We are typically a solution provider and we implemented this solution twelve months ago.
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
The scalability is really good.
There are not many end-users who come in and log in every day, because all of these transformations are completed automatically. From the administration standpoint, there are three or four people taking care of the databases and the application layer. The product is all automated and it's a matter of a back and forth thing.
How are customer service and technical support?
I have not contacted Google support.
Which solution did I use previously and why did I switch?
We were using Oracle. Previously, we were not using any products. Other products such as JCS and ICS are not this kind of solution. They are that capable. Oracle may have some other products, but I am not aware of it.
How was the initial setup?
The initial setup was ok, although it can be made to be more user-friendly.
The length of deployment depends on the client's requirements. This particular client has very stringent requirements and it had to go through multiple QA processes. It did take some time but that had to do with the change in management.
You need three or four people with varying skillsets if you are implementing this. We had approximately five for this.
What's my experience with pricing, setup cost, and licensing?
I think that the cost is metered based on the data, but I don't have the details.
What other advice do I have?
This is an awesome product.
This solution is pretty automated. When you come from an administrative standpoint, they come and just do some maintenance now and then. They're very few.
My advice for anybody who is implementing this solution is that they have to be very careful. Though this has all of the capabilities, be very careful. Before they engage in the design, you have to understand the volume of transactions you are going to have. What are the turnaround times that you need and the performance considerations? Depending on that, you have to define the architecture of the solution. There are various factors.
There is a thought process before you go into the developing mode.
You have to go through many different people and understand what the restrictions of the various databases that Google has provided are. You have a lot of tools to select before you start developing. There are many tools on this platform and you have to pick the right ones for the right solution. Cost and performance on this type of solution dictate that.
A thorough analysis should be done before you get into this because it's not easy.
I would rate this solution a nine out of ten.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?