What is a Datasource?

A Datasource is a metadata definition of a Database Table or a View. A Datasource could be used ot store your application data. You can also create reports and dashboards based on the Datasource. You can also define ComboBox or List of Values to pull the data from a Datasource.

Designing a Datasource

As a first step, we recommend designing your overall approach. By gathering requirements and making key design decisions up front, you will be able to implement the solution more efficiently.

Answer the following questions:

Data

  1. What fields and data types do you need?
  2. How would you logically group these fields into one or more Datasource?
  3. What are the mandatory fields?
  4. What fields can the user update?
  5. What fields can the user provide data while create a new record?
  6. Are there any fields you don't want the user to see for any security reasons?
  7. Are there any important fields you want to track changes?
  8. Are there any calculated fields that could be derived at runtime instead of storing it in the database?
  9. How much business logic is involved in managing the data?
  10. Where would you like the business logic to reside? In PL/SQL or Java?
  11. How are the Datasources related to each other?

Implementation Step

  • Installation

    Install & configure telidos platform on-premise or on a private/public cloud

  • Setup Authentication Method

    Setup how your users access the applications. Setup the URL, choose the Authentication Mode between Google Account, Oracle EBS Account, Windows Active Directory & Platform Managed Account.

  • Setup Roles

    Define the Roles for your application

  • Setup Datasource

    Define Datasource one for each Table and/or View for which you would like to either update or view the data.

  • Setup Pages

    Design your application across various screens/pages

  • Setup Security

    Setup access grant to the above created pages & datasource to varous roles with varied access restrictions

  • Invite Users

    Add users to your application

Navigation

Administration → Data Source List

Click on the "Create New Data Source" button to create one or click on an existing data source name to view or edit.


Once you click on the edit icon beside the datasource, you have a popup that opens up.

Location

101 California Street, Suite 2710
San Francisco, CA 94111


440 N. Wolfe Rd.
Sunnyvale, CA 94085


Office 11, 5th Floor, Building 9,
Mindspace IT Park
Hyderabad 500081

p: +1 (844) AT CloudIO (844-282-5683)
f: +1 (650) 300-5247 | e: sales@cloudio.io
© 2009, 2017 CloudIO Inc. | Terms of Use | Privacy Policy