Create a data source and connect it to data


You are here: InLoox Support Knowledge Base Online Help InLoox for Outlook 10.0 All support articles | InLoox 10 for Outlook Dashboard view Designing dashboards Creating a data source Creating a data source and connecting to data

You can connect to various types of databases and data files using the Create Data Source wizard. This wizard allows you to establish a connection to the data store by providing the required connection parameters.

 InLoox PM provides you with its own project data sources on the side panel left in the dashboard designer.

Create Data Source Wizard

  1. Data Source Name On the first page, enter the data source name and click Next.

  2. New or Existing Data Connection  On this page, specify whether to use one of the existing connections or create a new connection, and click Next.

    This page only appears if you have already established a data connection in the current application.

  3. Connection Parameters  If the application has not yet been connected to a database, or you have chosen to create a new connection in the previous step, the connection parameters page will be displayed.
    1. First, select the required data provider from the Provider combo box. The Data Access library supports more than a dozen different data providers, including MS SQL Server, MS Access Database, Oracle and MySQL.
    2. The other settings on this page depend on which data provider is used. Typically, you will need to specify the server name or the path to the database file, the user credentials, and the database name.
    3. Finally, specify the name of the new connection in the Connection name field and click Next.
  4. Finish  On the last page, you can select a table or a view. The data from the selected table or view will be used in your application.
    1. Click Finish to close the wizard. Optionally, you can run the Query Designer, which will help you populate the new data source with data. To do this, check the Open Query Designer after closing the wizard check box before finishing.