It is possible save records in Outsystems and  feed an external database?

It is possible save records in Outsystems and  feed an external database?

  

I have an External Database,  my question is how i save the records in Outsystems and feed this database? please help! I'm new in Outsystems

Hi,

Try this, http://www.outsystems.com/help/IntegrationStudio/9.1/index.htm#t=Managing_Extensions%2FImport_entities_from_Database.htm

You have to configure the connection on service center and then import entities with Integration Studio.

Nelson Inácio wrote:

Hi,

Try this, http://www.outsystems.com/help/IntegrationStudio/9.1/index.htm#t=Managing_Extensions%2FImport_entities_from_Database.htm

You have to configure the connection on service center and then import entities with Integration Studio.


Link is working fine on my computer.

"

To create a new database connection, follow these steps:


    1. In Service Center, under the 'Administration' tab, click 'Database Connections';

    2. On the left side choose 'New Database Connection';

    3. Fill in the fields with the information about the database to connect to.
      You can use the 'Advanced Configuration' option to customize the connection string to connect to the database.
      The database user needs to have permissions to list the tables and views, and perform Create, Read, Update, and Delete operations. Check the System Requirements to learn more.

Import a table from an external database


    1. In Integration Studio connect to the environment where the database connection is configured;

    2. In the left side right-click the Entities folder, and choose 'Connect to External Table or View'

    3. On the Welcome window click 'Next';

    4. The OutSystems Platform displays a list of database servers that can be reached using the already configured database connections, or database servers that can be reached via Linked Server. Choose a database server from this list;

    5. Choose a database schema or catalog;

    6. In the 'Available Tables and Views' box choose the tables and views you want to import.
      To automatically import tables pointed by foreign keys, set the 'Levels of related tables' to import;

    7. In the 'Imported Tables and Views Report' the wizard displays information detailing the expected result of the import you are about to make.
      You can click the 'View Report...' button to see a full report;

    8. After importing the tables and views, review their names, descriptions and data types for each attribute;

    9. You can also review the 'Table or View Name' field, since this is the name that will be used to represent the database table. You can customize this field using for example database synonyms.
      Make sure that the Runtime User that is specified in the Configuration Tool can access the table, view or synonym using the object name you define here.

    10. To publish the extension module, click the 1-Click Publish button.

Configure the Database Connection

After the publishing is finished, the OutSystems platform notifies that you still need to configure which database connection to use. For this, click the 'Configure' button.

Once in Service Center, choose a database connection from the ones available.

Now this extension module is ready to be used in Service Studio. Learn how to use the Extension in an eSpace module.

If later you make changes to the table or view in thew source database, you can update your extension by refreshing the entity. See Refresh an Entity."