X

Managing Data Sources

MANAGING DATA SOURCES

Defining and managing data sources is a vital part of any TDM project. BizDataX supports connecting to a variety of data sources including, but not limited to:

  • Relational DBMS like DB2, Oracle, SQL Server, Informix, mySQL..
  • File based data sources like XML, VSAM, texf files, CSV
  • Any other data source accessible via ADO.NET, ODBC, OLE DB or web services

Figure 18: Creating new data source

After assigning a data source to a project, user can explore details about data source schemas, tables, columns and relationships.


Figure 19: Data source artefacts – schemas, tables and columns

Data sources created within the BizDataX Portal could be assigned to an arbitrary number of projects. Naturally, data sources could also be removed from projects.

project datasourcesFigure 20: Managing data sources relevant for the project