Post reply

Data integration/Data transfer

  • June 21, 2010 at 3:23 pm

    #387193

    We need to receive the data from the client on every tuesday.

    We can't access their database server.

    Is there any other way than receiving the data in an excel/csv/txt file/xml file or API calls?

    Thanks.

  • June 21, 2010 at 4:30 pm

    #1183022

    sql_novice_2007 (6/21/2010)

    We need to receive the data from the client on every tuesday.

    We can't access their database server.

    Is there any other way than receiving the data in an excel/csv/txt file/xml file or API calls?

    Thanks.

    You might want to put that question into some context.

    What restricts you from receiving the data in the formats you specified above?

    How much data are we talking about?

    Are there any specific security concerns?

    Are

  • June 22, 2010 at 7:45 am

    #1183333

    we are going to receive 10000 rows per day and each row will have around 19 columns.

    Securoty wise we will be able to receive either by an API call or in a flatfile/excel file.

    Thanks.

  • June 22, 2010 at 8:20 am

    #1183367

    sql_novice_2007 (6/21/2010)

    ...

    Is there any other way than receiving the data in an excel/csv/txt file/xml file or API calls?

    ...

    A lot of other ways:

    1. By phone (some one calls you and dictates data of 1000 rows, should not take long using experienced call center staff)

    2. By telegraph (unfortunately it's not available in some European contries any more)

    3. By the radio (use some long waves as spy do - it is very secured)

    4. Ask the source to put the add into the local paper (with small font they should manage to get into half page).

    5. Punch cards - this is my favoured one, (I still have some used as bookmarks)

    6. Clay tablets - old way but very robust (they still find some 5000 years old ones in Egypt)

    There are many more, just turn your fantasy on!

    :-D:-D:-D

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • June 22, 2010 at 8:56 am

    #1183393

    sql_novice_2007 (6/22/2010)

    we are going to receive 10000 rows per day and each row will have around 19 columns.

    Securoty wise we will be able to receive either by an API call or in a flatfile/excel file.

    Thanks.

    Without some kind of access to the data on the client side your options are fairly limited.

    Depending on the size and security requirements of the file you could have the client ftp it to some

    secure site of yours then have an SSIS package poll for its arrival or run on demand/schedule and process

    the file as required.

  • June 22, 2010 at 9:02 am

    #1183396

    Thank you all.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply