OutSystems -- AS-400 Integration

I need to integrate Outsystems Platform with AS/400 – DB2 - iSeries.

Can anybody gently provide any guidance?

Best Regards to whole community...

Eduardo, Thanks for your quick response...

I am pretty clear with database connection...

I am not familiar with AS-400....How can I access DB through Integration Services...and so on..

Hello Edgardo,

AS-400 is a computer.
You're talking about connect to a database, DB2, that is in a AS-400 computer, for what I understood.

The computer is irrelevant. What is relevant is that the database must be accessible to the OutSystems Server.
If you already created the connection to the database in Service Center, you can follow the instructions in the second link.

It is just a matter of using the Integration Studio Wizard.

More information at the end of this masterclass: https://www.outsystems.com/learn/lesson/1120/integrations-and-extensibility/

Cheers.

1. You need to install IBM DB2 iAccess on your Outsystems Platform Server.

2. Create DB connection in /ServiceCenter > Administration > DB Connection, complete connection string and user/password then do Test Connection.

3. Launch Integration Studio, connect to your platform server, create/name your new extension.

4. Right click on Entity node > Connect to External Database

5. Choose your newly created database connection

6. Choose schema and tables you would like to import.

    (after import, make sure Identifier column is set on each table)

7. Choose name for Logical Database Connection

8. Publish extension

9. At the end of publishing, there's a link to ServiceCenter where you map your physical db connection to logical db connection

10. Your extension will be visible at Service Studio under Independent Modules

11. In your main module, just do manage dependency, then search for your extension name.

12. Done.

Hello all,

we have installed the  IBM DB2 iAccess software in Outsystems Server.

When configuring the Database Connection in Service Center, after clicking in TEST CONNECTION, it shows the yellow Loading message at the bottom left for some time and when it disappears no error or success message is shown.

In Integration Studio, after selecting the connection we get the error : "Error retrieving database: The underlying connection was closed. A connection that was expected to be kept alive was closed by the server."

Any ideas?

Thanks.

Hi everyone here. 

I am also trying to create a connection from Service Center to an IBMi DB2 database. Can't pass the TEST CONNECTION though. So far I could not find in the links to documentation something that can't tell what the error can be. Attaching an image below. May be there is something wrong I am overlooking. 

Forgot to add: in Database I keyed the name of the machine as DB2 for i is just one database. I also tried keying in an Schema name and without it as per the picture As server I keyed the internal IP Address of the machine (in our intranet)

Thanks in advance

Hi Henry,

Did you try the 'Advanced configuration' option? Some time ago i was facing the same problem, we couldn't make it work, it took us days. Then we had a remote session with some IBM engineers and it turned out that we were using the wrong database and/or schema name. 

Thanks Leen,

Here is how I tried with advanced. But still getting the same error.Do you think  I am missing quotes or something?

Henry,

I don't think you're missing quotes. The only things i can think of is a schema name and whether the account you're using has sufficient rights. I would also team up with the database administrator to see what request is being received on the other side.  

Leen Rietveld wrote:

Henry,

I don't think you're missing quotes. The only things i can think of is a schema name and whether the account you're using has sufficient rights. I would also team up with the database administrator to see what request is being received on the other side.  

Thanks for your reply Leen; I included the schema but after checking the Logs in the AS400 it seems I am not even hitting it from OutSystems server (which is on premises in the same network). May be the DB2 for i .NET provider is not set up correctly in the outsystems windows server. May be you have some info on how to set it up?



Henry,

Unfortunately, i have not, because i worked with OutSystems cloud. Presumably, the necessary drivers and configuration are in place there. Maybe you can ask support?

Hi Henry,

Maybe there is a firewall blocking the traffic. Even in an internal network firewalls are there to prevent unauthorized access. In my experience integration problems are often caused by firewall and other security related issues. 

The first step is checking the connection. The first is a simpele ping. In Oracle the next is a tnsping. Maybe the as400 has something similar. It is a ping on the database connection.

Succes, Eric

Eric Slikker wrote:

Hi Henry,

Maybe there is a firewall blocking the traffic. Even in an internal network firewalls are there to prevent unauthorized access. In my experience integration problems are often caused by firewall and other security related issues. 

The first step is checking the connection. The first is a simpele ping. In Oracle the next is a tnsping. Maybe the as400 has something similar. It is a ping on the database connection.

Succes, Eric

Thanks for the suggestion Eric. Will try that.