We have the continuous data integration feature, but it does not work very well in our given ecosystem because we have huge data volume, and it reads from archive log rather than the redo sequence. That is where it lacks, so we are not able to do continuous streaming data injection. The ability to handle heterogeneous migrations for our organization is adequate. I do not see a major value add, or see it as a marquee feature. It is a good tool, but we do not have that sort of uses requirement. In my 10 plus years of experience, I do not see that kind of requirement where I have to replicate it in real time. I leverage AWS CloudWatch for addressing migration issues. The major challenges come across CDC. We have created latency filter and everything, but there is no way to control it. Due to the nature of our business, the transactions increase during month end and year end. My transactions are supposed to increase, my workloads on my core system increases, but my DMS is not able to keep up with them, even if I increase it to a higher side. Improvements could be made in AWS Database Migration Service. Because of that, I am moving out of DMS now to a STRIIM solution. DMS works within AWS ecosystem, but they also have to look for third party solutions. Now Snowflake is a bigger player, or Databricks. Something that could be possible as a connector, whether paid or free, but giving as a connector to that ecosystem as well.
