SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only
  • 1.  Data Feed from Data Warehouse

    Posted Wed November 02, 2022 10:50 AM
    Edited by System Admin Fri January 20, 2023 04:31 PM
    I'm trying to figure out how to pull data into SPSS from a data warehouse using the data feed option in the dw.  I tried putting the data feed path into the get internet data in SPSS, but got an error message.  Is there another way of doing this? thanks Art

    - it's an atom feed

    ------------------------------
    Art Jack
    ------------------------------
    #SPSSStatistics


  • 2.  RE: Data Feed from Data Warehouse

    Posted Wed November 02, 2022 11:07 AM
    There's a lot of information missing here, but have you considered using an ODBC driver to pull the information via GET DATA TYPE=ODBC?

    --





  • 3.  RE: Data Feed from Data Warehouse

    Posted Wed June 21, 2023 07:07 AM

    There are a few other ways to pull data into SPSS from a data warehouse using the data feed option.

    One way is to use the LOAD DATA procedure. This procedure allows you to load data from a variety of sources, including data feeds. To use the LOAD DATA procedure, you will need to know the URL of the data feed. You can then use the following syntax to load the data into SPSS:

    LOAD DATA
    INFILE "https://www.example.com/datafeed.xml"
    DBMS "XML"
    REPLACE;
    

    Another way to pull data into SPSS from a data warehouse using the data feed option is to use the GET DATA procedure. This procedure allows you to import data from a variety of sources, including data feeds. To use the GET DATA procedure, you will need to know the URL of the data feed and the format of the data. You can then use the following syntax to import the data into SPSS:

    GET DATA
    /TYPE=XML
    /FILE="https://www.example.com/datafeed.xml"
    /ENCODING="UTF-8"
    /VARIABLES="variable1, variable2, ...";
    

    Finally, you can also use the IMPORT procedure to pull data into SPSS from a data warehouse using the data feed option. This procedure is similar to the LOAD DATA procedure, but it allows you to import data into a variety of formats. To use the IMPORT procedure, you will need to know the URL of the data feed, the format of the data, and the destination file. You can then use the following syntax to import the data into SPSS:

    IMPORT
    FROM "https://www.example.com/datafeed.xml"
    OF XML
    INTO WORKING MEMORY
    /VARIABLES="variable1, variable2, ...";
    

    I hope this doesn't dive away from your question ! 



    ------------------------------
    Youssef Sbai Idrissi
    Software Engineer
    ------------------------------