IBM InfoSphere Information Server vs. Layer2 Cloud Connector

Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

We had a scenario where our clients have thousands of external party vendors/committees who regularly sync SharePoint data. Managing thousands of external parties can never be possible without using a Layer2 cloud connector. We managed the local network sharing and SharePoint integration by using the Layer2 connector. Layer2 is convenient with a large amount of data as the per-user license is high.

• IIS best for ETL ,not ELT , and many and diffrent source systems.
• It also can process big data , unstuctured data
• It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems

Incentivized

• Layer2 provides best connectivity with SharePoint
• It syncs local network shared files to the SharePoint
• Provides details file history

• I would be nice to have a new web development environment for DataStage.
• Connectivity Packs such as Pack for SAP Application are a little pricey.
• It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.

Incentivized

• Per User cost is expensive
• A lot of pre-requisites
• UI needs to be more user-friendly

• Scale of implementation
• IBM techsupport

Incentivized

DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS

We had also used Microsoft One Drive as a syncing tool but it requires Office365 for managing and syncing data across thousands of vendors which was not practically possible to manage users on Office 365. Layer2 resolved this issue by having 3 user licenses and they are enough to periodically sync all external parties' data with our SharePoint online.

• Productivity of the development of integration processes.
• Better documentation and governance.
• Reduce training costs of various technologies.

• Layer2 resolves the time management issue
• Resolved data syncing issues across different external vendors
• LOE optimisation with using Layer2 connector.