DataStage Connectivity using ODBC

Moderator: NorbertKrupa

Post Reply
nikx_8_7
Newbie
Newbie
Posts: 7
Joined: Tue Jun 05, 2012 2:26 pm

DataStage Connectivity using ODBC

Post by nikx_8_7 » Tue Jun 05, 2012 2:31 pm

Hi, we are using Datastage as an ETL tool and vertica as our target database. Wanted to know if anyone has tried connecting to vertica through Datastage using ODBC connection.
Top
jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:
Contact jpcavanaugh

Re: DataStage Connectivity using ODBC

Post by jpcavanaugh » Wed Jun 06, 2012 8:49 pm

Yes - this is a known data path against Vertica.
Top
nikx_8_7
Newbie
Newbie
Posts: 7
Joined: Tue Jun 05, 2012 2:26 pm

Re: DataStage Connectivity using ODBC

Post by nikx_8_7 » Thu Jun 07, 2012 3:58 am

So, how is the performance while loading data through oDBC stage to vertica?
Top
jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:
Contact jpcavanaugh

Re: DataStage Connectivity using ODBC

Post by jpcavanaugh » Thu Jun 07, 2012 8:08 pm

The ODBC drivers for Vertica have been completely rewritten as of version 5.1. Internally when doing bulk loading the driver invokes the bulk loader so you should get very good performance. How many concurrent loads are you planning on doing via DataStage?
Top
nikx_8_7
Newbie
Newbie
Posts: 7
Joined: Tue Jun 05, 2012 2:26 pm

Re: DataStage Connectivity using ODBC

Post by nikx_8_7 » Wed Jun 13, 2012 2:11 pm

We are planning to go 4 node config file for Datastage.
Top
jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:
Contact jpcavanaugh

Re: DataStage Connectivity using ODBC

Post by jpcavanaugh » Wed Jun 13, 2012 6:50 pm

Ok - I would suggest you run multiple streams in parallel.
Top
Post Reply

Return to “ODBC”