DataManager Sources

Using the DataManager workspace (2.6+)

Defining, saving and bookmarking permissioned data sources

Beginning with version 2.6, Omniscope features a new drag-and-drop visual workspace enabling non-technical users to import, assemble, transform (aggregate, de-pivot, tokenise, etc.), filter, sample, scramble and export tabular data sets, with no knowledge of SQL.  

File

List of values

Batch append files

OLAP cubes

Operations
URL

Sequence of values

Lookup dataOnline Sources/ConnectorsOutputs 

Database table (or view)

File metadata

Demo data

Merging feeds

 

 

 View Toolbar 

 

Block Tools:

 Block note: allows the user to insertcomment in the Block

         Rename: allows the user to Remane theBlock name

         Load into Omniscope : Load datainto Omniscope

         Update data: Load data from Omniscope(Table)to the block.

         Update OptionThese settings allow you to customise howOmniscope checks for changes for this block.

=>can be Never-Auto or Scheduled

         Preserve formulas output:Keep the formula when creating an output file.

         Create duplicate : does createa duplicate of the block

         Create a snapshot: Create asnapshot of the block

         Replace with snapshot: Replacethe block with a snapshot.

         Bookmark This block: will create a“shortcut” under Bookmark menu

        Explore to: Allow you to open a file

         Reset size: reduce the size of the block

         Maximize: Maximize the size of the window

        Remove others: Remove ALL of the blocks except for 'Rename(snapshot)'?

        Remove: Remove the block

 

Sources - using DataManager source blocks

Omniscope DataManager workspace opens to reveal a Data Bar/Blocks menu on the left side, and an Add Block menu is always available at the top of the drag-and-drop workspace.

File

The user can importe an Excel file including X number of worksheets, Omniscope will give the user the possibility to choose, individual, or a pair of working sheets:

 

 

-The name of the worksheet will appears under the buttonAll

 

-The user can also create one block and append X number of Worksheet.

or create one block for each worksheet 

 

 

File Option Block, allow the user to drag a file to DataManager window and open a file.

 

By clicking on the block the user is able to:

-See/change the directory of the file.

-Browse a new file or open and edit the file used when selecting the option Edit.-To enter a Password -Modify and import a new worksheet if needed

-Change and modifythe setting of the Table Data

 

  

 


Data Manager also gives the possibility to change thesetting of the table if the user use the option selects table data

 

 

This Option gives the possibility to Configure/Select or Remove any rows, column and Headers.

 
 
For more details of how to configure and use File Option, click Here  

 

 

URL


  Data Manager can Import data from a remote data file such as an XML, CSV file or a SpreadSheet.


Database table (or view)

 

To see how to configure the Database in DataManager click Here 

List of values

 List of values Block create a list of values that you can use as input to create any operation.

 

Sequence of values

 Sequence of values generate a sequence of values betweenStart and End values.

 

File metadata 

 
FileMedia data Block, retrieves all information about all of the media files in afolder. 

 

Batch append files

location of data files to be automatically appended into a single data set.

 Batch append files, appends a set of files whith in a designated folder

 

Lookup data 

useful data available for free

 Look up, Imports data from one of the Omniscope sample files to DM

 

Demo data

 Same as Look up option, Demo data Imports data from one of the Omniscopesample files 

 

OLAP cubes 

The OLAP cube source block provides connectivity to MDX-compliant multi-dimensional data structures (cubes) such as Microsoft SSAS and other cubes.

 

 OLAP cube, Import data from an OLAP Cube such as SQL Server Analysis Services.

 

Online Sources/Connectors

 

Under the Blocks > Sources menu, the DataManager workspace provides access to a growing number of Online Sources/Connectors allowing you to control the import of data from remote sources to which you have access.

Connectors enable Omniscope to access structured data sources unique to a publisher/platfrom or application directly via API calls, rather than via exported delimited data files or views/tables from relational databases imported using SQL statements and JDBC/ODBC protocols.

 

Note: Connectors for accessing, refreshing and synchronising with remote-hosted 'clouds' are available only from activated Omniscopes, not the free Viewer.

 

Other Data Bar Blocks in DataManager: 

Merging feeds

 

Online data sources ranging from freely-available searchable sources like Twitter and web searches to premium real-time data feed services like Bloomberg.

Using Merging feeds

 

Operations

 

The DataManager workspace also allows you to define any sequence of  transformational operations by dragging Operations blocks onto the workspace.  Operations blocks are also accessible from the Mani Toolbar Data > Operations menu and are fully documented here.

Transforming Data 

 

Outputs  

 

Any number of different file output, publishing and distribution options can alo be defined using the DataManager data flow definition workspace. Output/export and disctribution/devliery options are fully documented here.

Defining Outputs