---
title: "IBM DB2 AS/400 (iSeries)"
canonical: "https://wiki.yellowfinbi.com/space/yfcurrent/2195778/IBM%20DB2%20AS%2F400%20(iSeries)"
format: markdown
---
Follow the instructions below to connect Yellowfin to an IBM Db2 AS400 (iSeries) database.

> ⚠️ Yellowfin does not ship with the driver required for this connection due to licensing/paywall reasons. You will need to manually upload the driver through the [Plugin Manager](https://yellowfin.atlassian.net/wiki/display/yfcurrent/Plugin+Management) or [Creating a Basic Data Source Connection.](https://yellowfin.atlassian.net/wiki/display/yfcurrent/Creating+a+Basic+Data+Source+Connection)

1. Click on the **Create** button and then on Data Source.  
> Macro (inline-media-image)

  
<span style="color: #000000">2. Select </span>**<span style="color: #000000">IBM DB2 AS/400 (iSeries)</span>****<span style="color: #000000"> </span>**<span style="color: #000000">from the databases list.</span>  
> Macro (inline-media-image)

  
<span style="color: #000000">3. </span>When the New Connection popup appears, provide a name and description for your database.  
4. **<span style="color: #000000">Connection String: </span>**<span style="color: #000000">when selecting Connection String you have the same functionality as in </span>[<span style="color: #000000">Generic JDBC Data Source</span>](https://yellowfin.atlassian.net/wiki/display/yfcurrent/Generic+JDBC+Data+Source)**<span style="color: #000000">.</span>**  
> Macro (inline-media-image)

  
**<span style="color: #000000">5. </span>****<span style="color: #000000">IBM DB2 AS400</span>**<span style="color: #000000"> configuration fields.</span>  
> Macro (inline-media-image)

  
<span style="color: #000000">6. </span>**<span style="color: #000000">Authentication Adapter: </span>**<span style="color: #000000">Specify an authentication method for the database adapter. More details</span>**<span style="color: #000000"> </span>**[<span style="color: #000000">Advanced Connection Editor</span>](https://yellowfin.atlassian.net/wiki/display/yfcurrent/Understanding+Connection+Parameters#UnderstandingConnectionParameters-AdvancedConnectionEditor)<span style="color: #000000">.</span>  
**<span style="color: #000000">7. </span>**Select the **Include Schema in SQL** checkbox to add the schema name when addressing database tables in SQL queries.  
> Macro (inline-media-image)

  
8. Next, enter the name of the server hosting the database.  
9. The TCP/IP port number required for this database, will already be displayed.  
10. Specify the name of the database containing the data that you require.  
11. Select the **Use Custom Fetch Size** checkbox if you want a specific number of data rows to be retrieved from the database after a query is executed, instead of fetching its entire result. Specify the number of rows.   
> Macro (inline-media-image)

  
12. Yellowfin will automatically select the correct JDBC driver to talk to your IBM AS2 AS400 database.  
> Macro (inline-media-image)

  
13. Enter the username and password of your database account.  
14. <span style="color: #000000">Toggle Advanced Settings</span><span style="color: #000000"> to see more settings.</span>  
> Macro (inline-media-image)

  
<span style="color: #000000">15. </span>Once you have completed your connection information, you will have several options:  
> Macro (inline-media-image)



> Macro (legacy-content)