Devart Excel Add-ins vs. Informatica PowerExchange Connectors

Devart Excel Add-ins is really good for data comparison of one database table against another database table. There are plenty of times where the business users need help understanding with their Power BI data models are not connecting correctly and I use this tool to break down the differences between the tables they are trying to connect.

Incentivized

1.- Scenaries with poor sources of data is not recomended (Very bad ROI). The solution is for medium-big enterprises with a lot of sources of data and users. 2.- Bank and finance enviroment to integrate differente data form trading, Regulatory reports, decisions makers, fraud and financial crimes because in this kind of scenary the quality of data is the base of the business. 3.- Departments of development and test of applications in enterprises because you can design enviroments, out of the production systems, to development and test the new API's or updateds made.

Incentivized

• Devart Excel Add-in supports connectivity with various databases - which really helps to customize and massage data.
• Since data is available in cloud, it is easily accessible everywhere.
• It can also be integrated with SSIS components making it possible to resolve complex problems.

Incentivized

• Access to different RDB, API's Data (External / Internal)
• The connectors access to data from social networks such as Twitter or LinkedIn
• Connectors provide access to data in AS400 systems with a minimun development of interface
• The dashboard is is completely customizable
• for any organization

Incentivized

• The data pump feature breaks sometimes
• The profile usage monitoring is slow
• The event profiler is delayed

Incentivized

• Define customer business rulers to put the data in the repository with easy develpoment.
• Quickly transfer and integrate data between cloud and local RDB/SYSTEMS
• Very simple to navigate between data before and after integration/transformation was made

Incentivized

Devart Excel stacks up very well against its alternatives. It has significant advantages as it keeps getting an update. Features are very much suitable for smaller organizations. For larger organizations the features cannot be used directly because of the size of the company and more native requirements of IT software requirements.

Incentivized

Basically the two solutions have, more or less, the same functions and features.The difference, for me, is that ThreatQuotient make more features over the security and I think is oriented to a SOC enviroments. InformaticaExchange Connectors is oriented to the quality, integration and distribution of the data in order to ensure the reliability and access of data from different sources, as well as the integration in a single repository of enterprise data (External/internal)

Incentivized

• The data compare option saves our dev team a lot of time
• The documenter feature is nice to use for explaining table definitions
• The event profiler is great for usage metrics

Incentivized

• Positive: reduce the time of testing new API's with a data integrationin a 35% aprox.
• Positive: improve the time to access to quality data for all branchs and different offcies in the world inmore than 100%
• Positive: reduce the cost of maintenance of servers for data.(Now the data is in Cloud) in 100%(The local servers was eliminated)

Incentivized