{"id":5615,"date":"2024-11-20T09:09:36","date_gmt":"2024-11-20T00:09:36","guid":{"rendered":"https:\/\/dandelions.co.jp\/blog\/?p=5615"},"modified":"2024-11-20T09:09:36","modified_gmt":"2024-11-20T00:09:36","slug":"engineering-blog-migrating-outsystems-database-to-an-external-db","status":"publish","type":"post","link":"http:\/\/dandelions.co.jp\/blog\/blog\/2024\/11\/20\/engineering-blog-migrating-outsystems-database-to-an-external-db\/","title":{"rendered":"Engineering Blog: Migrating Outsystems Database to an External DB"},"content":{"rendered":"\n

Welcome to our engineering blog, where we share the learning experiences we’re engaged in daily. This time, we’re focusing on low-code development in Unit 2.<\/p>\n\n\n\n

Today’s Theme: Migrating Outsystems Database to an External DB<\/strong><\/h2>\n\n\n\n

In Outsystems, you can request a free cloud version called the Personal Environment (PE) by creating an account. (What is an OutSystems Personal Environment – OutSystems Support<\/a>)
Using this environment, you can develop personal applications for small-scale users and are provided with 2GB of database storage.<\/p>\n\n\n\n

However, there are some inconveniences, such as limited storage capacity and the inability to access the database directly from external sources. To address these issues, we decided to migrate the internal database created in Outsystems to an external database while keeping the table definitions unchanged. Below are the results of this migration.<\/p>\n\n\n\n

Environment Information<\/strong><\/h2>\n\n\n\n

Personal Environment: Version 11.31.0 (Build 43948)
Service Studio: Version 11.54.80 \/ Build 63652
Data Extractor<\/a>: 1.4.0<\/p>\n\n\n\n

About Data Extractor<\/strong><\/h2>\n\n\n\n

By using Data Extractor, freely available on the Forge<\/a>, you can obtain the actual table DDL corresponding to the Entities created in Outsystems. Here’s how to use it:<\/p>\n\n\n\n

  1. Install “Data Extractor” from the Forge.<\/li>
  2. Launch the application via “Open In Browser.”\"\"<\/li>
  3. Log in by entering your ID and password.<\/li>
  4. Create a new snapshot by clicking “New Snapshot” on the top page.\"\"<\/li>
  5. Configure the new snapshot with the following settings:
    \u30fbSnapshot Name: Give your snapshot a name. Any name is fine.
    \u30fbExtract Configurations: Check the “Table DDL” option. Other items are optional.
    \u30fbExtract Entities: Add the Entities for which you want to output the DDL to the list.
    \u3000Use the “Search Entity to Add” feature to find Entities by prefix matching. Select the desired Entity and click “Add” to include it in the list.
    \u30fb<\/strong>Other Items: Optional. Configure as needed.\"\"<\/li>
  6. Click the “Run” button. Your snapshot will appear in the list on the top page with the status “Created.” Once the status changes to “Done,” you can download it by clicking the “\u2193” icon on the far right.\"\"<\/li>
  7. Contents of the downloaded Zip file:
    \u30fb[TableName].csv.gz: Export of data registered in the Entity.
    \u203bNote: In our testing environment, Japanese characters were displayed as “?” and could not be read correctly.
    \u30fbTableDDL.Create.sql.gz: DDL of the actual table corresponding to the Entity.
    \u203bIncludes the following:
    \u3000\u30fbCreate Table statements
    \u3000\u30fbAlter Table statements to add foreign key constraints to columns of the Entity Identifier type
    \u3000\u30fbCreate Index statements to add indexes to columns of the Entity Identifier type<\/li><\/ol>\n\n\n\n

    By executing the Create Table statements obtained through these steps, you can create tables with the same layout as the internal database on your own SQL Server.\"\"<\/p>\n\n\n\n

    To reference the tables created in the external database from Outsystems, you’ll need to create a Database Connection via the Service Center and then set up the connection to the tables through “Connect to External Table or View” in Integration Studio<\/a>.\"\"\"\"<\/p>\n\n\n\n

    Summary<\/strong><\/h2>\n\n\n\n