How to fetch the data from ERP database thru SQL query

• NLV

  SSChasing Mays

  Points: 654

  More actions

  June 13, 2011 at 2:30 am

  #242051

  Hi,

  I want to fetch the data from ERP database thru SQL query. I want to know how to connect to ERP database to retrieve the data in to my SQL server 2005 data base.

  Thanks

  Rao.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  June 13, 2011 at 2:42 am

  #1337619

  NLV (6/13/2011)

  ---

  Hi,

  I want to fetch the data from ERP database thru SQL query. I want to know how to connect to ERP database to retrieve the data in to my SQL server 2005 data base.

  Thanks

  Rao.

  What have you tried? Is this a SQL Server database? What problems are you having?

  ---

• NLV

  SSChasing Mays

  Points: 654

  More actions

  June 13, 2011 at 3:29 am

  #1337638

  Hi,

  I am new to work with ERP databases. Vendor will provide the SQL queries to extract the data and I should store the data into my database.

  Yes, it is SQL server.

  I just want to know different procedures to connect to ERP database system. Please suggest.

  Thanks

  IVLN

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 13, 2011 at 3:36 am

  #1337641

  From the sparse information you've given, a linked server or a dataflow task in SSIS seem to be what you need. Please provide more details of what you're trying to do if you need any further help with this.

  John