---
title: "IBM Informix"
canonical: "https://wiki.yellowfinbi.com/space/yfcurrent/2196002/IBM%20Informix"
format: markdown
---
This guide shows you how to connect Yellowfin to an IBM Informix data source.

> ⚠️ 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 choose the data source option.  
> Macro (inline-media-image)

  
2. <span style="color: #000000">Select  </span>**<span style="color: #000000">IBM Informix</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 Informix</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">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>****Include Schema in SQL:** Select this checkbox to add the schema name when addressing database tables in SQL queries.  
**8. Database Host:** Enter the name or IP address of the server hosting the Informix database.  
**9. Database Port:** Yellowfin will display the correct TCP/IP port number for this connection.   
> Macro (inline-media-image)

  
10. **Database Name:** Specify the name of the Informix database to connect to. If you don't provide a database name, a connection is made to the Informix database server.  
11. **Server Name:** Use this optional parameter to specify the name of the database server.  
12. **JDBC Driver:** The JDBC driver talks to your** Informix** database.   
> Macro (inline-media-image)

  
1**3. ****Username:** Enter the user ID to connect to the database.  
14. **Password:** Specify the password for the user ID provided above.  
15.<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">16. </span>Once you have completed your connection information, you will have several options:  
> Macro (inline-media-image)



> Macro (legacy-content)