Group matching records togetherUse the Group Records task to organize matching records in indexed fields (keys) into expandable/collapsible groups. You can also simply display your data in any orderwithout creating a new database by clicking on a column or using the Indices task. Sort your records in a specified orderCreate a new database physically sorted in the specified order. Organize your DataExplore your data by adding additional fields and grouping and ordering your data before starting deeper analysis. To back up your project, simply back upyour Working Folder. All results,macros, databases and definitions are automatically stored in this central folder. IDEA allows you to easily manage your files and results by grouping all of them in a single Working Folder.
This functionality, in conjunction with the automatic audit trail creation, allows you to easilydocument and review your work. IDEA protects the source data by allowing read-only access to your clients' data to avoid any unwanted changes andmaintain data integrity. Define the reports by using simple "point and click" tools to identify the data you need.Įxport your data and results out of IDEA in multiple formats like Excel, Access, HTML, XML, Text, RTF (Microsoft Word), PDFand more. Report ReaderCreate reports using system tools, save the reports to files (PRN or PDF), then use Report Reader to describe and capturethe data in IDEA. ODBCConnect, using ODBC, to all major relational databases such as Oracle, DB2, SQL, Sybase, SAP or AS-400. Text (Fixed and variable length) and Delimited (CSV, DEL) files AS-400, Microsoft Access or Excel files XML, dBASE, or SAP AIS databases and more Import varioustypes of data coming from legacy mainframes, mid-range accounting software and big ERP systems.
Import AssistantImport easily almost any file type from almost any source, using IDEAs Import Assistant to guide you. IDEA allows you to import your data from a multitude of formats, including files originating from large mainframe computersand accounting software.
0 kommentar(er)
