Data360 Analyze enables you to acquire data from one or more sources, then analyze, reconcile, and transform the data before publishing to a file, database or external system.
Acquire data
You can import data from sources such as Microsoft Excel or CSV, or from big data platforms such as Hadoop or MongoDB by using one of the Input Connector nodes.
Build data flows to analyze your data
You can create data flows by connecting nodes and configuring their properties to customize the analysis that is performed on the underlying data at each step. Each node performs an operation on the input data and provides output data for subsequent nodes. To help beginner and intermediate users get started, you can filter the number of nodes that are displayed to show only a curated set of commonly used nodes. If you are looking for our more advanced nodes, you can easily switch to display all available nodes, or search to find a specific node. See Creating a new data flow.
At each step through your data flow, you can view the underlying data in the data viewer, allowing you to validate the business logic and to discover patterns in the data which suggest new avenues of inquiry. When viewing large data sets, you can filter and sort the data to display only relevant information. See Inspecting data.
Data flows are executed interactively using the tools in the Designer user interface. Depending on your license, you can also configure data flows to automatically execute on a scheduled basis. See Scheduling.
Simplify and reuse
You can simplify complex data flows by grouping subsets of nodes into a single composite node, and you can create custom library nodes for reuse in multiple data flows. See Grouping nodes and Creating library nodes.
Share and publish results
You can share custom nodes and data flows with other users. Data from any point within the data flow can be exported to an external file for external viewing and sharing. See Sharing documents.
Finally, you can publish the results of your analysis to a file or another system, for example to Microsoft Excel or to a data visualization tool such as Tableau or Qlik by using one of the Output Connector nodes.
Set permissions
Users with the role of Administrator can set permissions on folders and Directory objects to restrict access to specific users, or groups of users. See Managing permissions.
LDAP/AD and SSO integration
In the Server product, administrators can import users and groups from an LDAP/AD server. Data360 Analyze can be configured to synchronize with an LDAP/AD server at regular intervals. Subject to licensed features, you can also integrate Data360 Analyze with CA Single Sign-On. In this case, users can either be created on demand or locally in Data360 Analyze, or users can be created from their LDAP/AD account. See SSO and LDAP/AD integration.