You can add data to your app from a new data source. When you add data from a new data source, a connection to the data source is created in Connections, making it easier to add more data from the same data source.
For more information about:
- Available data sources, see Adding data to the app
- Connecting to data sources, see Connecting to data sources
Do the following:
- Open an app.
- Open the Data manager and then click ú. You can also click Add data in the ¨ menu.
- Click Connect my data.
- Select the type of data source to use.
-
Enter the connection parameters required by the data source.
For example:
- File based data sources require that you specify a path to the files and select a file type.
- Databases such as Oracle and IBM DB2 require database properties and access credentials.
- Web files require the URL of the web file.
- ODBC connections require DSN credentials.
-
Select the tables and fields to load.
-
Choose whether to continue to work on the data or to load the data into the app:
-
Click Prepare data to continue to add data sources, transform the data, and associate the tables in Data manager. Date and time fields will be created automatically and mapped to autoCalendar. Data profiling is also performed to provide association recommendations. All fields that are common between tables are auto-qualified.
Information note Tables are not associated on common field names automatically, and you need to associate all tables in the Associations view of Data manager. -
Click Load data and finish to load the added data into the app and go to the sheet. This will also reload all existing data from data sources.
Tables are associated on common field names automatically.
Information noteDate and time fields will not be created if you use Load data and finish.
If serious problems are detected, you need to resolve the problems in Data manager before you can load data into the app.
-