VERIFIED SOLUTION i
X

Performance statistics for loading data into postgreSQL database using Sagent Data Flow

UPDATED: August 31, 2017


Prerequisites 

  • Sagent DFS 64bit 
  • PostgreSQL 9.3
  • System Data Source Name (DSN) for PostgreSQL ODBC driver.
  • For 64bit setup create "same name system Data Source Name (DSN)" using 32bit PostgreSQL ODBC and 64bit PostgreSQL ODBC driver.

Purpose of creating "same name Data Source Name (DSN)"

  • Required 32bit PostgreSQL ODBC for Design studio to create base view and 64bit PostgreSQL ODBC for Sagent DFS server while executing plan


System details

  • Operating System: Windows server 2008 R2 Enterprise
  • RAM: 6 GB

Data and Plan components

  • Input data size: 6 GB
  • Source Transformation: Flat File
  • Sink Transformation: Save to Table

Plan execution time

  • 14 hours
Note: Sagent does not have inbuilt support for PostgreSQL database.

Environment Details

Product Feature: DataFlow Server
Operating System: Windows 2008 64bit
Database: PostgreSQL

 

Downloads

  • No Downloads