Load Data from Informatica PowerCenter
On this page
You can connect to your SingleStoreDB cluster from Informatica PowerCenter to perform analytics and ETL operations using The SingleStore ODBC Driver.
Prerequisites
-
An active SingleStoreDB cluster
-
An Informatica PowerCenter license
Connect to SingleStoreDB from PowerCenter
Perform the following tasks to connect to your SingleStoreDB database from PowerCenter:
-
Download and install Informatica PowerCenter.
Refer to Informatica Documentation for more information. -
Download and install the SingleStore ODBC driver.
SingleStore recommends using the ANSI version of the driver. -
Place the libssodbca.
so and libssodbcw. so files in the <Informatica-installation-directory>/<PowerCenter-version>/ODBC7. 1/lib directory. -
Update the path to the libssodbca.
so and libssodbcw. so files in the odbc. ini file used by Informatica PowerCenter.
-
-
Configure SingleStoreDB as an ODBC data source in Informatica PowerCenter.
Refer to the Connecting to an ODBC Data Source for more information.
Last modified: September 29, 2023