I am using mysql executor to fetch pvoutput.org data into my mysql databases. The whole data is being fetched but its not going into my mysql databases

It seems there are some issues with how the quotation marks are used. Try something like this:

INSERT INTO stations.observation (station_id, 
                                  date, 
                                  time, 
                                  energy, 
                                  power, 
                                  average, 
                                  temperature, 
                                  voltage)
VALUES (1,
        @Value(interval_start), -- Numeric value, not quoted
        '@Value(_timeOutSubstring)', -- String value, must be quoted
        '@Value(_dataEnergyOutString)',
        '@Value(_dataPowerOutString)',
        '@Value(_dataPowerAvgString)',
        '@Value(_dataTempString)',
        '@Value(_dataVoltString)')

Notes:

• In SQL, single quotes are necessary for string literals. Note that you'll need to use straight quotes such as 'string', slanted quotes such as `string` usually won't work. You should not quote numeric values, although some database implementations will silently ignore the quotes for you.

   

• In FME, don't put a semicolon at the end of the SQL statement unless you also define FME_SQL_DELIMITER at the start of your SQL statement, see this article for more info.

What kind of error message are you getting? It's difficult to be specific without knowing your data and your database schema.