Import data sources and data models

Try Pentaho Data Integration and Analytics

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA000-11
Follow the steps in the Data Sources and Data Models Checklist to create data sources and models that are ideal for agile development of your BA solution.
Table. Table 2. Data Sources and Data Models Checklist
Task Steps Notes
Choose Data Source Types
  • Choose a Data Source type. See Pentaho Business Analytics for instructions.
  • Review the information about data sources.
  • Examine the differences between the different data models - relational data models vs. multidimensional data models.
Create Data Sources and Models
  • Tour the Data Source Wizard. See Pentaho Business Analytics for instructions.
  • Learn how the Pentaho Server and Data Source Wizard work together to create usable data sources and data models.
Create Database Table Data Sources
  • Create a database table source. See Pentaho Business Analytics for instructions.
  • Create Data Sources and preliminary data models using the Data Source Wizard.
Learn about Mondrian Schemas
  • Create and modify Mondrian schemas. See Pentaho Schema Workbench for instructions.
  • Create Mondrian schemas and add a Mondrian data source
  • Adapt the schema to work with Analyzer
  • Modify the schema in Schema Workbench