Share via


Connect to an Informix Database

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

This page of the Table Import Wizard enables you to specify settings to connect to an Informix database. To access the wizard from the PowerPivot window, on the Home tab, in the Get External Data group, click the type of data source from which you want to import tables.

To connect to a data source, you must have the appropriate provider installed on your computer. For more information about supported data sources and providers, see Data Sources Supported in PowerPivot Workbooks.

  • Friendly connection name
    Type a unique name for this data source connection. This is a required field.

  • Server name
    Type or select the name of the server instance to connect to.

  • User name
    Specify a user name for the database connection.

  • Password
    Specify a password for the database connection.

  • Save my password
    Specify whether the password you have entered in the Password box is stored.

  • Advanced
    Set additional connection properties by using the Set Advanced Properties dialog box. For more information, see Set Advanced Properties.

  • Test Connection
    Attempt to establish a connection to the data source using the current settings. A message is displayed indicating whether the connection is successful.

See Also

Concepts

Take a Tour of the PowerPivot UI