# Load Data from Informatica PowerCenter

You can connect to your SingleStore cluster from Informatica PowerCenter to perform analytics and ETL operations using [The SingleStore ODBC Driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-odbc/the-singlestore-odbc-driver.md).

## Prerequisites

* An active SingleStore cluster
* An Informatica PowerCenter license

## Connect to SingleStore from PowerCenter

Perform the following tasks to connect to your SingleStore database from PowerCenter:

1. Download and install Informatica PowerCenter. Refer to [Informatica Documentation](https://docs.informatica.com/data-integration/powercenter/10-5-3.html) for more information.

2. [Download and install](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-odbc/the-singlestore-odbc-driver.md) the SingleStore ODBC driver. SingleStore recommends using the ANSI version of the driver.
   > **📝 Note**: Informatica PowerCenter only supports 32-bit data sources on Windows. Hence, use the 32-bit version of the SingleStore ODBC driver to connect to your SingleStore database from PowerCenter on Windows.
   1. Place the **libssodbca.so** and **libssodbcw\.so** files in the **\<Informatica-installation-directory>/\<PowerCenter-version>/ODBC7.1/lib** directory.

   2. Update the path to the **libssodbca.so** and **libssodbcw\.so** files in the **odbc.ini** file used by Informatica PowerCenter.

3. Configure SingleStore as an ODBC data source in Informatica PowerCenter. Refer to the [Connecting to an ODBC Data Source](https://docs.informatica.com/data-integration/powercenter/10-5/installation-for-powercenter-and-data-quality/appendix-b--connecting-to-databases-from-unix-or-linux/connecting-to-an-odbc-data-source.html) for more information.

***

Modified at: July 2, 2024

Source: [/db/v9.1/load-data/integrate-with-singlestore/load-data-from-informatica-powercenter/](https://docs.singlestore.com/db/v9.1/load-data/integrate-with-singlestore/load-data-from-informatica-powercenter/)

(An index of the documentation is available at /llms.txt)